Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

153
154
155
156
157
158
159
160
161
162
163
            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()) {
                    if (rs.getDouble("LAMT") != 0.0) {       
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
            sb.append(" WHERE RI.IM=? AND RI.IP=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.setObject(1, im);
            dao.setObject(2, ip);
            ResultSet rs = dao.executeQuery();
            try {
                if ( (rs.next()) && (im.equals(rs.getObject("IM"))) && (ip.equals(rs.getObject("IP"))) ) {
                    result = true;
                }
                rs.close();
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
            String columnName = (String)st.nextElement();
            ComponentExt tempComponentExt = relationManager.findComponentExt(tableName, columnName);
            JComponent tempComponent = tempComponentExt.getComponent();                                   
            dao.setObject(i+1, ComponentManager.getValue(tempComponent));
        }
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                ResultSetMetaData rsmd = rs.getMetaData();
                for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                    ComponentExt tempComponentExt = relationManager.findComponentExt(column.getTableName(), rsmd.getColumnName(i));
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
                                String columnName = (String)st.nextElement();
                                ComponentExt tempComponentExt = relationManager.findComponentExt(tableName, columnName);
                                JComponent tempComponent = tempComponentExt.getComponent();                                   
                                dao.setObject(i+1, ComponentManager.getValue(tempComponent));
                            }
                            ResultSet rs = dao.executeQuery();
                            try {
                                if (rs.next()) {
                                    ResultSetMetaData rsmd = rs.getMetaData();
                                    for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                                        ComponentExt tempComponentExt = relationManager.findComponentExt(column.getTableName(), rsmd.getColumnName(i));
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        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()) {
                result = true;                   
            }
            rs.close();
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
        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++) {
                if ( (rsmd.getTableName(i).equals("TAX")) && (rsmd.getColumnName(i).equals("TAXT")) )
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
           
            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");
                    para1 = rs.getDouble("PARA1");
                    para2 = rs.getDouble("PARA2");
                    para3 = rs.getDouble("PARA3");
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
            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));
                }
                rs.close();
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
           
            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");
                    para1 = rs.getDouble("PARA1");
                    para2 = rs.getDouble("PARA2");
                    para3 = rs.getDouble("PARA3");
View Full Code Here
554
555
556
557
558
559
560
561
562
563
564
            formula = sb.toString();
                       
            String sql = "CALL " + formula;
            dao.query(sql);           
            try {
                ResultSet rs = dao.executeQuery();
                if (rs.next()) {
                    result = rs.getDouble(1);
                }
                rs.close();
            } catch (Exception e) {
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.