Package realcix20.utils

Examples of realcix20.utils.DAO.query()

110
111
112
113
114
115
116
117
118
119
120
            }
        }
        sb.delete(sb.lastIndexOf("AND"), sb.lastIndexOf("AND") + 3);
        String sql = sb.toString();
        DAO dao = DAO.getInstance();
        dao.query(sql);
        for (int i = 0; i < whereValues.size(); i++) {
            dao.setObject(i + 1, whereValues.get(i));
        }
        ResultSet rs = dao.executeQuery();
        try {
View Full Code Here
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
                    Vector names = new Vector();
                    Vector dataValues = new Vector();
                    names.add(ObjectUtil.findColumnTxt(200, "LD", "LD"));
                    names.add(ObjectUtil.findColumnTxt(200, "LD", "RUSER"));
                    DAO dao = DAO.getInstance();
                    dao.query(Resources.SELECT_ALL_LD_FROM_LD_SQL);
                    ResultSet rs = dao.executeQuery();
                    try {
                        while (rs.next()) {
                            Vector rowDatas = new Vector();
                            rowDatas.add(rs.getString("LD"));
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
            ObjectUtil.findNewCell(newRegRow, "R", "CREATEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
            ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGED").setColumnValue(now);
            ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
            ObjectUtil.findNewCell(newRegRow, "R", "TXT256").setColumnValue(TxtManager.getTxt("VIEW.CURRENCYEVALUATION.TITLE"));
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_RI_XR_INFO_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                int i = 1;
                double sum = 0.0;
                while (rs.next()) {
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
            RegClass reg = (RegClass)ClassManager.createClass(510);
            StringBuffer sb = new StringBuffer(reg.getBasicSQL());
            sb.append(" WHERE RI.NS=? AND RI.P=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.query(sql);
            dao.setObject(1, ns);
            dao.setObject(2, p);
            ResultSet rs = dao.executeQuery();
            try {
                if ( (rs.next()) && (ns.equals(rs.getObject("NS"))) && (p.equals(rs.getObject("P"))) ) {
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    RelationManager relationManager = container.getRelationManager();
    Vector parameters = relationManager.getParameters_Defvalue(componentExt);
    if (parameters != null) {
        String sql = relationManager.getSQL_Defvalue(componentExt, parameters);
        DAO dao = DAO.getInstance();
        dao.query(sql);
        for (int i = 0; i < parameters.size(); i++) {
            String parameter = (String)parameters.get(i);
            StringTokenizer st = new StringTokenizer(parameter, ".");
            String tableName = (String)st.nextElement();
            String columnName = (String)st.nextElement();
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
                        RelationManager relationManager = container.getRelationManager();
                        Vector parameters = relationManager.getParameters_Defvalue(componentExt);
                        if (parameters != null) {
                            String sql = relationManager.getSQL_Defvalue(componentExt, parameters);
                            DAO dao = DAO.getInstance();
                            dao.query(sql);
                            for (int i = 0; i < parameters.size(); i++) {
                                String parameter = (String)parameters.get(i);
                                StringTokenizer st = new StringTokenizer(parameter, ".");
                                String tableName = (String)st.nextElement();
                                String columnName = (String)st.nextElement();
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
            return false;
        }
        int r = Integer.parseInt(ObjectUtil.findNewCell(regItemRow, "RI", "R").getColumnValue().toString());
        int ri = Integer.parseInt(ObjectUtil.findNewCell(regItemRow, "RI", "RI").getColumnValue().toString());
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_TAXI_BY_R_RI_SQL);
        dao.setInt(1, r);
        dao.setInt(2, ri);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    public static boolean isTaxtUsedInTax(Row taxTypeRow) {       
        boolean result = false;
        String taxt = ObjectUtil.findNewCell(taxTypeRow, "TAXT", "TAXT").getColumnValue().toString();
        TaxClass tax = (TaxClass)ClassManager.createClass(530);
        DAO dao = DAO.getInstance();
        dao.query(tax.getBasicSQL());
        ResultSet rs = dao.executeQuery();
        try {
            ResultSetMetaData rsmd = rs.getMetaData();
            int i;
            for (i = 1; i <= rsmd.getColumnCount(); i++) {
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
            String taxt = null;
            cell = ObjectUtil.findNewCell(row, "TAX", "TAXT");
            taxt = (String)cell.getColumnValue();
           
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_FROM_TAXT_SQL);                                  
            dao.setObject(1, taxt);           
            try {
                ResultSet rs = dao.executeQuery();
                if (rs.next()) {
                    formula = rs.getString("FORMULA");
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
            }
           
            formula = sb.toString();
                       
            String sql = "CALL " + formula;
            dao.query(sql);           
            try {
                ResultSet rs = dao.executeQuery();
                if (rs.next()) {
                    cell = ObjectUtil.findNewCell(row, "TAXI", "TAMT");
                    cell.setColumnValue(rs.getObject(1));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.