Package realcix20.utils

Examples of realcix20.utils.DAO.query()

90
91
92
93
94
95
96
97
98
99
100
    public static JComponent getComponent(GV gv) {       
        JComponent component = null;
        if (gv.getInputtype() == 1) {
            JComboBox comboBox = new JComboBox();
            DAO dao = DAO.getInstance();
            dao.query(gv.getInputpar());
            ResultSet rs = dao.executeQuery();
            try {
                while (rs.next()) {
                    ResultSetMetaData rsmd = rs.getMetaData();
                    Item item = null;
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  public SelectCurrencyEvaluationDialog(MainView container) {
    super(container);
   

    DAO dao = DAO.getInstance();
    dao.query(Resources.SELECT_EARLIST_RDATE);
    ResultSet rs = dao.executeQuery();
    try {
      if (rs.next()) {
        startDate = rs.getDate(1);
      }
View Full Code Here
227
228
229
230
231
232
233
234
235
236
237
  }

  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"));
      }
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
                    } else if (action.equals("Add")) {
                        Vector parameters = getRelationManager().getParameters_Defvalue(componentExt);
                        if (parameters != null) {
                            String sql = getRelationManager().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
93
94
95
96
97
98
99
100
101
102
103
            PartnerClass partner = (PartnerClass)ClassManager.createClass(250);
            StringBuffer sb = new StringBuffer(partner.getBasicSQL());
            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;                   
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
            boolean result = false;
            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;
View Full Code Here
454
455
456
457
458
459
460
461
462
463
464
       
        public static String getNewPA(String ns, String p) {
           
                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()) {
View Full Code Here
474
475
476
477
478
479
480
481
482
483
484
       
        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);
                    }
View Full Code Here
617
618
619
620
621
622
623
624
625
626
627
           
                PublicKey publicKey = null;
                String ruser = (String)ObjectUtil.findNewCell(partnerAccountRow, "PA", "RUSER").getColumnValue();
                String ruserPA = (String)ObjectUtil.findNewCell(partnerAccountRow, "PA", "RUSERPA").getColumnValue();
                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 {
View Full Code Here
641
642
643
644
645
646
647
648
649
650
651
           
                PrivateKey privateKey = null;
                String ruser = ObjectUtil.findNewCell(partnerAccountRow, "PA", "RUSER").getColumnValue().toString();
                String ruserPA = ObjectUtil.findNewCell(partnerAccountRow, "PA", "RUSERPA").getColumnValue().toString();
                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 {
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.