Package realcix20.utils

Examples of realcix20.utils.DAO.executeUpdate()

783
784
785
786
787
788
789
790
791
792
793
                dao.setObject(17, ObjectUtil.findNewCell(correspondenceRow, "TI", "IM").getColumnValue());
                dao.setObject(18, ObjectUtil.findNewCell(correspondenceRow, "TI", "IP").getColumnValue());
                dao.setObject(19, ObjectUtil.findNewCell(correspondenceRow, "TI", "IPUOM").getColumnValue());
                dao.setObject(20, ObjectUtil.findNewCell(correspondenceRow, "TI", "IPQUAN").getColumnValue());
                dao.setObject(21, ObjectUtil.findNewCell(correspondenceRow, "TI", "IPPRICE").getColumnValue());
                dao.executeUpdate();           
               
//                System.err.println("ObjectUtil.findNewCell(correspondenceRow, 'TI', 'MPRICE') =  " + ObjectUtil.findNewCell(correspondenceRow, "TI", "MPRICE").getColumnValue());
        }
       
        public static String getLD(Row correspondenceRow) {
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
        StringBuffer sb = new StringBuffer("DELETE FROM " + anaProfile.getChildTableName() + " WHERE AT=?");
        String sql = sb.toString();
        DAO dao = DAO.getInstance();     
        dao.update(sql);
        dao.setObject(1, at);
        dao.executeUpdate();  
        sb = new StringBuffer("DELETE FROM " + anaProfile.getMainTableName() + "" +
                " WHERE APF NOT IN (SELECT APF FROM " + anaProfile.getChildTableName() + ")");
        sql = sb.toString();
//        System.out.println(sql);
        dao.update(sql);
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
        sb = new StringBuffer("DELETE FROM " + anaProfile.getMainTableName() + "" +
                " WHERE APF NOT IN (SELECT APF FROM " + anaProfile.getChildTableName() + ")");
        sql = sb.toString();
//        System.out.println(sql);
        dao.update(sql);
        dao.executeUpdate();
    }
   
    public static boolean validateDelete(Row anaTypeRow, MainView container) {       
        boolean result = true;
        String at = ObjectUtil.findNewCell(anaTypeRow, "AT", "AT").getColumnValue().toString();
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
                    if (rs.next()) {
                        dao.update(Resources.UPDATE_TXT_SQL);
                        dao.setString(1, long_c);
                        dao.setString(2, txtId);
                        dao.setString(3, lang);
                        dao.executeUpdate();
                    } else {
                        dao.update(Resources.INSERT_TXT_SQL);                           
                        dao.setString(1, txtId);
                        dao.setString(2, lang);
                        dao.setString(3, long_c);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
                    } else {
                        dao.update(Resources.INSERT_TXT_SQL);                           
                        dao.setString(1, txtId);
                        dao.setString(2, lang);
                        dao.setString(3, long_c);
                        dao.executeUpdate();
                    }
                    rs.close();
                } catch (Exception ee) {
                }
                container.setEnabled(true);
View Full Code Here
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
                                    dao.update(Resources.UPDATE_CL_ISFAVORITE_SQL);
                                    dao.setBoolean(1, favorite);
                                    dao.setInt(2, getContainer().getCurrentObject().getClsId());
                                    dao.setInt(3, oj.layout);
                                    dao.executeUpdate();
                                    getContainer().updateTree();
                                   
                                }
                            }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
        dao.setObject(3, null);
        dao.setObject(4, null);
        dao.setObject(5, null);
        dao.setObject(6, null);
        dao.setString(7, co);
        dao.executeUpdate();
        String defpa = "1";
        String ownername = p;                               
        String apLD = UserClass.getDEFLD("AP");
        String txt256 = TxtManager.getTxt("VIEW.OBJECTEDIT.RUSER.DEFAULTACCOUNT");               
        PrivateKey prikey = null;
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
        dao.setObject(6, apLD);
        dao.setObject(7, txt256);
        dao.setObject(8, prikey);
        dao.setObject(9, pubkey);
        dao.setObject(10, block);               
        dao.executeUpdate();
    }
   
    public static void deleteDependThings(Row taxDepRow) {
        String co = ObjectUtil.findNewCell(taxDepRow, "TAXDEP", "CO").getColumnValue().toString();
        String taxDep = ObjectUtil.findNewCell(taxDepRow, "TAXDEP", "TAXDEP").getColumnValue().toString();       
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
        String sql = sb.toString();
        DAO dao = DAO.getInstance();
        dao.setAutoCommit(false);
        dao.update(sql);
        dao.setObject(1, p);
        dao.executeUpdate();

        sb = new StringBuffer("DELETE FROM " + partner.getChildTableName() + " WHERE NS='TAX' AND P=?");
        sql = sb.toString();
        dao.update(sql);
        dao.setObject(1, p);
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        sb = new StringBuffer("DELETE FROM " + partner.getChildTableName() + " WHERE NS='TAX' AND P=?");
        sql = sb.toString();
        dao.update(sql);
        dao.setObject(1, p);
        dao.executeUpdate();
        dao.commit();
        dao.setAutoCommit(true);
    }
   
    public static boolean validateDelete(Row taxDepRow, MainView container) {       
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.