Package realcix20.utils

Examples of realcix20.utils.DAO.query()

111
112
113
114
115
116
117
118
119
120
121
        }
       
        private void setCurrentLt() {
           
                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()) {
View Full Code Here
357
358
359
360
361
362
363
364
365
366
367
                    r_lamt = ((Number)cell.getColumnValue()).doubleValue();
                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");
View Full Code Here
453
454
455
456
457
458
459
460
461
462
463
                    ri = ((Number)cell.getColumnValue()).intValue();
                else
                    ri = Integer.parseInt((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_BI_BY_ALLPK_SQL);
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, budget.b);
                dao.setObject(4, budget.ruser);
                dao.setObject(5, budget.rmonth);
View Full Code Here
715
716
717
718
719
720
721
722
723
724
725
                    ri = ((Number)cell.getColumnValue()).intValue();
                else
                    ri = Integer.parseInt((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_BI_BY_ALLPK_SQL);
                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));
View Full Code Here
11
12
13
14
15
16
17
18
19
20
21
        public static Column getColumn(String tableName, String columnName) {
           
                Column column = null;
               
                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()) {
View Full Code Here
984
985
986
987
988
989
990
991
992
993
994
            Vector values = new Vector();
           
            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 {
View Full Code Here
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
                e.printStackTrace();
            }

            String p = co + "." + taxdep;
           
            dao.query(Resources.SELECT_NS_FROM_P_SQL);
            dao.setObject(1, p);
            rs = dao.executeQuery();
            String ns = "";
            String defpa = "";
            try {
View Full Code Here
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
        boolean result = true;
        String ns = (String)ObjectUtil.findNewCell(taxRow, "TAX", "NS").getColumnValue();
        String p = (String)ObjectUtil.findNewCell(taxRow, "TAX", "P").getColumnValue();
        String pa = (String)ObjectUtil.findNewCell(taxRow, "TAX", "PA").getColumnValue();
        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 {
View Full Code Here
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
    public static double getSUMLamt(int r) {
       
            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);
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
            if (action.equals("Add")) {
                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
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.