Package realcix20.utils

Examples of realcix20.utils.DAO.update()

32
33
34
35
36
37
38
39
40
41
42
        try {
            KeyPairGenerator keyGen = KeyPairGenerator.getInstance(KEY_GENERATE_ALGORITHM);
            keyGen.initialize(1024);
            KeyPair key = keyGen.generateKeyPair();
            DAO dao = DAO.getInstance();
            dao.update(Resources.GENERATE_KEY_SQL);
            dao.setObject(1, (Object)key.getPublic());
            dao.setObject(2, (Object)key.getPrivate());
            dao.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    }
   
    public static void updateKeyPair(PublicKey publicKey, PrivateKey privateKey) {
       
        DAO dao = DAO.getInstance();
        dao.update(Resources.GENERATE_KEY_SQL);
        dao.setObject(1, (Object)publicKey);
        dao.setObject(2, (Object)privateKey);
        dao.executeUpdate();
       
    }      
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
        public void setCurrentUser(Row currentUser) {
           
                //will be modified
                DAO dao = DAO.getInstance();
                dao.update(Resources.UPDATE_GLOBALVAR_TABLE_SQL);
                Cell userCell = ObjectUtil.findNewCell(currentUser, "LOGINENTRY", "RUSER");               
                dao.setObject(1, userCell.getColumnValue());
                dao.setObject(2, "loginuser");
                dao.executeUpdate();
View Full Code Here
9
10
11
12
13
14
15
16
17
18
19
    }
   
    public static void deleteLayout(int clsId, int layoutId) {       
        DAO dao = DAO.getInstance();
        dao.setAutoCommit(true);
        dao.update(Resources.DELETE_LAYOUT_BY_CLSID_AND_LAYOUT_1);
        dao.setInt(1, clsId);
        dao.setInt(2, layoutId);
        dao.executeUpdate();
        dao.update(Resources.DELETE_LAYOUT_BY_CLSID_AND_LAYOUT_2);
        dao.setInt(1, clsId);
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
        dao.setAutoCommit(true);
        dao.update(Resources.DELETE_LAYOUT_BY_CLSID_AND_LAYOUT_1);
        dao.setInt(1, clsId);
        dao.setInt(2, layoutId);
        dao.executeUpdate();
        dao.update(Resources.DELETE_LAYOUT_BY_CLSID_AND_LAYOUT_2);
        dao.setInt(1, clsId);
        dao.setInt(2, layoutId);
        dao.executeUpdate();
        dao.update(Resources.DELETE_LAYOUT_NAME);
        String txtId = "CL." + clsId + "." + layoutId;
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
        dao.executeUpdate();
        dao.update(Resources.DELETE_LAYOUT_BY_CLSID_AND_LAYOUT_2);
        dao.setInt(1, clsId);
        dao.setInt(2, layoutId);
        dao.executeUpdate();
        dao.update(Resources.DELETE_LAYOUT_NAME);
        String txtId = "CL." + clsId + "." + layoutId;
        dao.setString(1, txtId);
        dao.executeUpdate();
    }
   
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
        dao.executeUpdate();
    }
   
    public static void updateReportIsFavorite(int clsId, int layoutId, boolean stat) {       
        DAO dao = DAO.getInstance();
        dao.update(Resources.UPDATE_CL_ISFAVORITE_SQL);
        dao.setBoolean(1, stat);
        dao.setInt(2, clsId);
        dao.setInt(3, layoutId);
        dao.executeUpdate();       
    }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
       
        boolean flag = false;
       
        if (container.getCommand().equals("ADD")||container.getCommand().equals("COPY")) {
           
            dao.update(Resources.INSERT_CL_SQL);
            dao.setInt(1, clsId);
            dao.setInt(2, layout);
            dao.setString(3, sql);
            dao.setBoolean(4, false);
            dao.setString(5,csql);
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
            dao.setString(3, sql);
            dao.setBoolean(4, false);
            dao.setString(5,csql);
            flag = dao.executeUpdate();
        } else if (container.getCommand().equals("EDIT")) {
            dao.update(Resources.UPDATE_CL_SQL);
            dao.setString(1, sql);
            dao.setString(2,csql);
            dao.setInt(3, clsId);
            dao.setInt(4, layout);
            flag = dao.executeUpdate();
View Full Code Here
262
263
264
265
266
267
268
269
270
271
272
        //update CLFIELDS Table
       
        if (flag) {
           
            //delete old rows
            dao.update(Resources.DELETE_CLFIELDS_SQL);
            dao.setInt(1, clsId);
            dao.setInt(2, layout);
            dao.executeUpdate();
           
            //addDisplayColumns
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.