Package realcix20.utils

Examples of realcix20.utils.DAO.query()

57
58
59
60
61
62
63
64
65
66
67
    public static PublicKey getPublicKey() {    
       
        PublicKey key = null;
       
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_PUB_AND_PRI_KEY_SQL);
        ResultSet rs = dao.executeQuery();
        try {
           
            if (rs.next())
                key = (PublicKey)rs.getObject("PUBKEY");
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    public static PrivateKey getPrivateKey() {
               
        PrivateKey key = null;
       
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_PUB_AND_PRI_KEY_SQL);
        ResultSet rs = dao.executeQuery();
        try {
           
            if (rs.next())
                key = (PrivateKey)rs.getObject("PRIKEY");
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
                case 2:
                   
                    if ( (column.getPControls() == null) || (column.getPControls().equals("")) ) {
                       
                        DAO dao = DAO.getInstance();
                        dao.query(column.getInputPar());
                        ResultSet rs = dao.executeQuery();
                        try {

                            ResultSetMetaData rsmd = rs.getMetaData();
                            if (rsmd.getColumnCount() == 1) {
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
       
        //set initial value
        ((JComboBox)childComponent).removeAllItems();

        DAO dao = DAO.getInstance();
        dao.query(sql);
        for (int i = 1; i <= components.size(); i++) {
            JComponent tempComponent = (JComponent)components.get(i - 1);
            dao.setObject(i, ComponentManager.getValue(tempComponent));
        }
        ResultSet rs = dao.executeQuery();
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
                    public void actionPerformed(ActionEvent e) {
                       
                        ((JComboBox)childComponent).removeAllItems();
                       
                        DAO dao = DAO.getInstance();
                        dao.query(sql);
                        for (int i = 1; i <= components.size(); i++) {
                            JComponent tempComponent = (JComponent)components.get(i - 1);
                            dao.setObject(i, ComponentManager.getValue(tempComponent));
                        }
                        ResultSet rs = dao.executeQuery();
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
    }
   
    protected void initialComponent7Value(JComponent component ,String columnName, String sql, Vector parameters) {
       
        DAO dao = DAO.getInstance();
        dao.query(sql);
        if (parameters != null) {
            for (int i = 1; i <= parameters.size(); i++) {
                dao.setObject(i, parameters.get(i - 1));
            }
        }
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
            //addFilterColumns
            for (int i = 0; i < caModel.getRowCount(); i++) {
                Column column = (Column)caModel.getValueAt(i, 1);
                String filterString = (String)caModel.getValueAt(i, 2);
                if ( (filterString != null) && (filterString.trim().length() > 0) ) {                
                    dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_AND_TABLENAME_AND_COLUMNNAME);
                    dao.setObject(1, clsId);
                    dao.setObject(2, layout);
                    dao.setObject(3, column.getTableName());
                    dao.setObject(4, column.getColumnName());
                    ResultSet rs = dao.executeQuery();
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
            boolean result = false;
            String ns = (String)ObjectUtil.findNewCell(correspondenceRow, "T", "NS").getColumnValue();
            String p = (String)ObjectUtil.findNewCell(correspondenceRow, "T", "P").getColumnValue();
            String pa = (String)ObjectUtil.findNewCell(correspondenceRow, "T", "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
98
99
100
101
102
103
104
105
106
107
108
                return false;
            }
            int r = Integer.parseInt(ObjectUtil.findNewCell(regItemRow, "RI", "R").getColumnValue().toString());
            int ri = Integer.parseInt(ObjectUtil.findNewCell(regItemRow, "RI", "RI").getColumnValue().toString());
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_FROM_TI_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
            CorrespondenceClass correspondence = (CorrespondenceClass)ClassManager.createClass(520);
            StringBuffer sb = new StringBuffer(correspondence.getBasicSQL());
            sb.append(" WHERE TI.IM=? AND TI.IP=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.query(sql);
//            System.out.println("im = " + im + "   ip = " + ip);
            dao.setObject(1, im);
            dao.setObject(2, ip);
            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.