Package realcix20.utils

Examples of realcix20.utils.DAO.executeUpdate()

56
57
58
59
60
61
62
63
64
65
66
      dao.setInt(1, r);
      dao.executeUpdate();
//      Delete mainTables     
          dao.update(Resources.DELETE_R_SQL);
      dao.setInt(1, r);
      dao.executeUpdate();
        }
       
        public static void deleteRelativeThings(int r, int ri) {
            //first,delete rpn
            DAO dao = DAO.getInstance();
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
            //first,delete rpn
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_RPN_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
            //next,delete budgets(BI)
            dao.update(Resources.DELETE_BI_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
            dao.executeUpdate();
            //next,delete budgets(BI)
            dao.update(Resources.DELETE_BI_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
        }
       
        public static boolean validateDelete(Row regRow, MainView container) {
            boolean result = true;
            Iterator regItemRows = regRow.getRowSet().getRows().iterator();
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.CLEAR_RITAXI_BY_TAXT_TAX_SQL);
            dao.setString(1, taxt);
            dao.setInt(2, tax);
            dao.executeUpdate();
       
    }
   
    public void addAllTaxedRegs(Vector taxs) {                   
       
View Full Code Here
777
778
779
780
781
782
783
784
785
786
787
                                dao.setObject(4, now);                              
                                dao.setObject(5, user);
                                dao.setObject(6, now);
                                dao.setObject(7, user);
                                dao.setObject(8, "TAX");
                                dao.executeUpdate();
                            }
                           
                            //insert ri tables
                            Vector values = getNSAndPAndPA(row);
                            dao.update(Resources.INSERT_RI_SQL);                           
View Full Code Here
797
798
799
800
801
802
803
804
805
806
807
                            dao.setObject(10, values.get(0));
                            dao.setObject(11, values.get(1));
                            dao.setObject(12, values.get(2));
                            for (int i = 13; i <= 22; i++)
                                dao.setObject(i, null);
                            dao.executeUpdate();
                           
                            //update taxRows
                            Cell rCell = ObjectUtil.findNewCell(row, "TAXI", "R");
                            rCell.setColumnValue(r);
                            rCell = ObjectUtil.findOldCell(row, "TAXI", "R");
View Full Code Here
882
883
884
885
886
887
888
889
890
891
892
                        dao.setObject(7, lc);
                        dao.setObject(8, xr);
                        dao.setObject(9, lamt);
                        for (int i = 10; i <= 22; i++)
                            dao.setObject(i, null);
                        dao.executeUpdate();
                       
                    }
                       
                }
               
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
    }
   
    private void updateRPN() {
        DAO dao = DAO.getInstance();
        dao.update(Resources.DELETE_ALL_RPN_SQL);
        dao.executeUpdate();
        ClearRegsManagerTableModel model = (ClearRegsManagerTableModel)table.getModel();
        Vector datas = model.getDataVector();
        Iterator rowDatasIter = datas.iterator();
        while (rowDatasIter.hasNext()) {
            Vector rowDatas = (Vector)rowDatasIter.next();
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
                int r = (Integer)ObjectUtil.findNewCell(regRow, "RI", "R").getColumnValue();
                int ri = (Integer)ObjectUtil.findNewCell(regRow, "RI", "RI").getColumnValue();
                dao.update(Resources.INSERT_RPN_SQL);
                dao.setInt(1, r);
                dao.setInt(2, ri);
                dao.executeUpdate();
            }
        }
    }
   
    public void actionPerformed(ActionEvent e) {
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
  private void insertTMPFC(java.sql.Date evaluationDate) {
    DAO dao = DAO.getInstance();
    dao.update(Resources.INSERT_TMPFC_SQL);
    dao.setObject(1, evaluationDate);
    dao.executeUpdate();
  }

  private void insertTMPXR(java.sql.Date evaluationDate) {
    DAO dao = DAO.getInstance();
    dao.update(Resources.INSERT_TMPXR_SQL);
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.