Package realcix20.utils

Examples of realcix20.utils.DAO.query()

422
423
424
425
426
427
428
429
430
431
432
            String taxt = null;
            Cell 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
552
553
554
555
556
557
558
559
560
561
562
            }
           
            formula = sb.toString();
                       
            String sql = "CALL " + formula;
            dao.query(sql);           
            try {
                ResultSet rs = dao.executeQuery();
                if (rs.next()) {
                    result = rs.getDouble(1);
                }
View Full Code Here
628
629
630
631
632
633
634
635
636
637
638
               
                int newR = 0;
                int newRi = 1;

                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_MAX_R_FROM_R_SQL);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next())
                        newR = rs.getInt(1) + 1;
                    rs.close();
View Full Code Here
668
669
670
671
672
673
674
675
676
677
678
//                    System.err.println("isAdd = " + isAdd);
                    //LD
                    String ld = "";
                    String user = GlobalValueManager.getValue("SESSION.LOGINUSER");
                    Cell taxtCell = ObjectUtil.findNewCell(row, "TAXI", "TAXT");
                    dao.query(Resources.SELECT_LD_BY_TAXTYPE_SQL);
                    dao.setObject(1, taxtCell.getColumnValue());
                    dao.setObject(2, user);
                    rs = dao.executeQuery();
                    try {
                        if (rs.next()) {
View Full Code Here
719
720
721
722
723
724
725
726
727
728
729
//                    System.err.println("R = " + r);
//                    System.err.println("RI = " + ri);

                    //LC
                    String lc = "";
                    dao.query(Resources.SELECT_LC_FROM_FAMILY_SQL);
                    rs = dao.executeQuery();
                    try {
                        if (rs.next()) {
                            lc = rs.getString("LC");
                        }
View Full Code Here
738
739
740
741
742
743
744
745
746
747
748
                    String tdate;
                    tdate = tdateCell.getColumnValue().toString();                                      

                    //XR
                    double xr = 1.0;
                    dao.query(Resources.SELECT_XR_SQL);
                    dao.setObject(1, lc);
                    dao.setObject(2, tc);
                    dao.setObject(3, lc);
                    dao.setObject(4, tc);
                    dao.setObject(5, tdate);
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
                String ns = (String)noEncryData.get(0);
                String p = (String)noEncryData.get(1);
                String pa = (String)noEncryData.get(2);
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_PUBKEY_PRIKEY_FROM_PA_SQL);
                dao.setObject(1, ns);
                dao.setObject(2, p);
                dao.setObject(3, pa);
                ResultSet rs = dao.executeQuery();
                try {
View Full Code Here
818
819
820
821
822
823
824
825
826
827
828
                   
                }
               
                if (hasNewRow) {
                    dao = DAO.getInstance();
                    dao.query(Resources.SELECT_SUM_LAMT_SQL);
                    dao.setObject(1, newR);
                    double sumLamt = 0.0;
                    rs = dao.executeQuery();
                    try {
                        if (rs.next())
View Full Code Here
834
835
836
837
838
839
840
841
842
843
844
                   
                    if (sumLamt != 0.0) {
                       
                        //LD
                        String ld="";
                        dao.query(Resources.SELECT_DEFLD_FROM_LT_SQL);
                        dao.setObject(1, "X");
                        rs = dao.executeQuery();
                        try {
                            if (rs.next())
                                ld = rs.getString("DEFLD");
View Full Code Here
847
848
849
850
851
852
853
854
855
856
857
                            e.printStackTrace();
                        }
                       
                        //LC
                        String lc = "";
                        dao.query(Resources.SELECT_LC_FROM_FAMILY_SQL);
                        rs = dao.executeQuery();
                        try {
                            if (rs.next()) {
                                lc = rs.getString("LC");
                            }
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.