Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

114
115
116
117
118
119
120
121
122
123
124
           
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_LT_FROM_LD);
                String ld = ObjectUtil.findNewCell(selectedRow, "RI", "LD").getColumnValue().toString();
                dao.setString(1, ld);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        currentLt = rs.getString("LT");
                    }
                    rs.close();
View Full Code Here
358
359
360
361
362
363
364
365
366
367
368
                else
                    r_lamt = Double.parseDouble((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_ALL_B_SQL);
                ResultSet rs = dao.executeQuery();
                try {
                    while (rs.next()) {
                        Vector rowData = new Vector();
                        String b = rs.getString("B");
                        String ruser = rs.getString("RUSER");
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, budget.b);
                dao.setObject(4, budget.ruser);
                dao.setObject(5, budget.rmonth);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next())
                        result = true;
                    else
                        result = false;
View Full Code Here
721
722
723
724
725
726
727
728
729
730
731
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, rowData.get(0));
                dao.setObject(4, rowData.get(1));
                dao.setObject(5, rowData.get(2));
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next())
                        rowData.set(4, rs.getDouble("LAMT"));
                    rs.close();
                } catch (Exception e) {
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
               
                DAO dao = DAO.getInstance();
                dao.query(SELECT_COLUMN_SQL);
                dao.setString(1, tableName);
                dao.setString(2, columnName);
                ResultSet rs = dao.executeQuery();
                try {                   
                    if (rs.next()) {
                        int clsId = rs.getInt("CLSID");
                        column = new Column(clsId, tableName, columnName);
                    }
View Full Code Here
986
987
988
989
990
991
992
993
994
995
996
            Cell cell = ObjectUtil.findNewCell(taxRow, "TAX", "TAXT");
//            System.err.println(cell.getColumnValue());
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_CO_TAXDEP_FROM_TAXT_SQL);
            dao.setObject(1, cell.getColumnValue());
            ResultSet rs = dao.executeQuery();
            String co = "";
            String taxdep = "";
            try {
                if (rs.next()) {
                    co = rs.getString("CO");
View Full Code Here
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
            String p = co + "." + taxdep;
           
            dao.query(Resources.SELECT_NS_FROM_P_SQL);
            dao.setObject(1, p);
            rs = dao.executeQuery();
            String ns = "";
            String defpa = "";
            try {
                if (rs.next()) {
                    ns = rs.getString("NS");
View Full Code Here
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
        DAO dao = DAO.getInstance();
        dao.query(Resources.GET_PA_SQL);
        dao.setString(1, ns);
        dao.setString(2, p);
        dao.setString(3, pa);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                result = rs.getBoolean("BLOCK");
            }
            rs.close();
View Full Code Here
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
            double sumLamt = -1;
       
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_SUM_LAMT_SQL);
            dao.setInt(1, r);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
                    sumLamt = rs.getDouble(1);
                }
                rs.close();
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
                        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
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.