Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

228
229
230
231
232
233
234
235
236
237
238
  public Vector validateXRMaintain() {
    Vector tcs = new Vector();
    DAO dao = DAO.getInstance();
    dao.query(Resources.VALIDATE_XR_MAINTAIN_SQL);
    ResultSet rs = dao.executeQuery();
    try {
      while (rs.next()) {
        tcs.add(rs.getString("TC"));
      }
      rs.close();
View Full Code Here
284
285
286
287
288
289
290
291
292
293
294
     
      //TODO ɾ���ɵ������ĵ�
      if(isDelOldCUR.isSelected()){
        DAO dao = DAO.getInstance();
        dao.update(Resources.SELECT_REVALUATION_R);
        ResultSet rs = dao.executeQuery();
       
        DAO daor = DAO.getInstance();
        try {
          while(rs.next()){
            int r = rs.getInt("R");
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
                                String columnName = (String)st.nextElement();
                                ComponentExt tempComponentExt = getRelationManager().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 = getRelationManager().findComponentExt(column.getTableName(), rsmd.getColumnName(i));
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
            sb.append(" WHERE PA.LD=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.query(sql);
            dao.setObject(1, ld);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
                    result = true;                   
                }               
            } catch (SQLException sqle) {               
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
            StringBuffer sb = new StringBuffer(partner.getBasicSQL());
            sb.append(" WHERE P.NS=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.setObject(1, ns);
            ResultSet rs = dao.executeQuery();
            try {
               if ( (rs.next()) && (ns.equals(rs.getObject("NS"))) ) {
                   result = true;
               }
               rs.close();
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
            String user = ObjectUtil.findNewCell(userRow, "RUSER", "RUSER").getColumnValue().toString();
            PartnerClass partner = (PartnerClass)ClassManager.createClass(250);
            String sql = partner.getBasicSQL();
            DAO dao = DAO.getInstance();
            dao.query(sql);
            ResultSet rs = dao.executeQuery();
            try {
                ResultSetMetaData rsmd = rs.getMetaData();               
                int nsColumn = -1;
                int ruserColumn = -1;
                for (int i = 1; i <= rsmd.getColumnCount(); i++) {
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
                String pa = null;
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_MAX_PA_SQL);
                dao.setString(1, ns);
                dao.setString(2, p);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        pa = rs.getString(1) + "1";
                    }
                    rs.close();
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
        public static int getMAXADD() {
           
                int maxADD = 0;
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_MAX_ADDR_SQL);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        maxADD = rs.getInt(1);
                    }
                    rs.close();
View Full Code Here
621
622
623
624
625
626
627
628
629
630
631
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_PA_SQL);
                dao.setString(1, "ME");
                dao.setString(2, ruser);
                dao.setString(3, ruserPA);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        publicKey = (PublicKey)rs.getObject("PUBKEY");
                    }
                    rs.close();
View Full Code Here
645
646
647
648
649
650
651
652
653
654
655
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_PA_SQL);
                dao.setString(1, "ME");
                dao.setString(2, ruser);
                dao.setString(3, ruserPA);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        privateKey = (PrivateKey)rs.getObject("PRIKEY");
                    }
                    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.