Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

629
630
631
632
633
634
635
636
637
638
639
                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();
                } catch (Exception e) {
View Full Code Here
671
672
673
674
675
676
677
678
679
680
681
                    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()) {
                            ld = rs.getString(1);                              
                        }
                        rs.close();
View Full Code Here
720
721
722
723
724
725
726
727
728
729
730
//                    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");
                        }
                        rs.close();
View Full Code Here
744
745
746
747
748
749
750
751
752
753
754
                    dao.setObject(1, lc);
                    dao.setObject(2, tc);
                    dao.setObject(3, lc);
                    dao.setObject(4, tc);
                    dao.setObject(5, tdate);
                    rs = dao.executeQuery();
                    try {
                        if (rs.next())
                            xr = rs.getDouble(1);
                        rs.close();
                    } catch (Exception e) {
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
                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 {
                    if (rs.next()) {
                        publicKey = (PublicKey)rs.getObject("PUBKEY");
                        result = 401;
                    } else {
View Full Code Here
821
822
823
824
825
826
827
828
829
830
831
                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())
                            sumLamt = rs.getDouble(1);
                        rs.close();
                    } catch (Exception e) {
View Full Code Here
836
837
838
839
840
841
842
843
844
845
846
                       
                        //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");
                            rs.close();
                        } catch (Exception e) {
View Full Code Here
848
849
850
851
852
853
854
855
856
857
858
                        }
                       
                        //LC
                        String lc = "";
                        dao.query(Resources.SELECT_LC_FROM_FAMILY_SQL);
                        rs = dao.executeQuery();
                        try {
                            if (rs.next()) {
                                lc = rs.getString("LC");
                            }
                            rs.close();
View Full Code Here
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
    Cell newCell = ObjectUtil.findNewCell(selectedRow, "TAX", "TAXT");
    String taxt = (String) newCell.getColumnValue();
    DAO dao = DAO.getInstance();
    dao.query(Resources.SELECT_FROM_TAXT_SQL);
    dao.setString(1, taxt);
    ResultSet rs = dao.executeQuery();
    try {
      if (rs.next()) {
        String formula = rs.getString("FORMULA");
        result = (formula.indexOf("[B2]") != -1);
      }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
                tracks = new Vector();
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_FROM_ZN_BY_CLSID_SQL);
                dao.setInt(1, clsId);
                String n1 = null;
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        n1 = rs.getString("N");
                    }
                    rs.close();
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.