Package realcix20.utils

Examples of realcix20.utils.DAO.update()

262
263
264
265
266
267
268
269
270
271
272
  private void deleteTMPXR_TMPFC() {
    DAO dao = DAO.getInstance();
    dao.update(Resources.DELETE_TMPXR_SQL);
    dao.executeUpdate();
    dao.update(Resources.DELETE_TMPFC_SQL);
    dao.executeUpdate();
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getActionCommand().equals("Cancel")) {
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
      }
     
      //TODO ɾ���ɵ������ĵ�
      if(isDelOldCUR.isSelected()){
        DAO dao = DAO.getInstance();
        dao.update(Resources.SELECT_REVALUATION_R);
        ResultSet rs = dao.executeQuery();
       
        DAO daor = DAO.getInstance();
        try {
          while(rs.next()){
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
        private void updateI18NText(String i18nID, String workText) {
           
                Column pkColumn = (Column)container.getCurrentObject().getPkColumns().get(0);
                String id = "." + pkColumn.getColumnName() + "." + i18nID;               
                DAO dao = DAO.getInstance();
                dao.update(Resources.DELETE_TXT_SQL);
                dao.setString(1, id);
                dao.setString(2, workLang);
                dao.executeUpdate();
                if ( (workText != null) && (workText.length() > 0) ) {
                    dao.update(Resources.INSERT_TXT_SQL);
View Full Code Here
262
263
264
265
266
267
268
269
270
271
272
                dao.update(Resources.DELETE_TXT_SQL);
                dao.setString(1, id);
                dao.setString(2, workLang);
                dao.executeUpdate();
                if ( (workText != null) && (workText.length() > 0) ) {
                    dao.update(Resources.INSERT_TXT_SQL);
                    dao.setString(1, id);
                    dao.setString(2, workLang);
                    if (workText.trim().length() == 0) {
                        dao.setString(3, " ");
                    } else
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        public static void deleteDependThings(Row partnerRow) {           
            String ns = ObjectUtil.findNewCell(partnerRow, "P", "NS").getColumnValue().toString();
            String p = ObjectUtil.findNewCell(partnerRow, "P", "P").getColumnValue().toString();
            DAO dao = DAO.getInstance();
            String sql = ("DELETE FROM PB WHERE PB.NS=? AND PB.P=?");
            dao.update(sql);
            dao.setObject(1, ns);
            dao.setObject(2, p);
            dao.executeUpdate();
           
            sql = ("DELETE FROM ADDR WHERE ADDR.NS=? AND ADDR.P=?");
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
            dao.setObject(1, ns);
            dao.setObject(2, p);
            dao.executeUpdate();
           
            sql = ("DELETE FROM ADDR WHERE ADDR.NS=? AND ADDR.P=?");
            dao.update(sql);
            dao.setObject(1, ns);
            dao.setObject(2, p);
            dao.executeUpdate();         
        }
       
View Full Code Here
441
442
443
444
445
446
447
448
449
450
451
                while (rowIter.hasNext()) {
                    Row row = (Row)rowIter.next();
                    Cell cell1 = ObjectUtil.findOldCell(row, "RI", "R");
                    Cell cell2 = ObjectUtil.findOldCell(row, "RI", "RI");
                    DAO dao = DAO.getInstance();
                    dao.update(Resources.INSERT_RPN_SQL);
                    dao.setObject(1, cell1.getColumnValue());
                    dao.setObject(2, cell2.getColumnValue());
                    if (dao.executeUpdate())
                        result = true;
                }
View Full Code Here
462
463
464
465
466
467
468
469
470
471
472
                while (rowIter.hasNext()) {
                    Row row = (Row)rowIter.next();
                    Cell cell1 = ObjectUtil.findOldCell(row, "RI", "R");
                    Cell cell2 = ObjectUtil.findOldCell(row, "RI", "RI");
                    DAO dao = DAO.getInstance();
                    dao.update(Resources.DELETE_RPN_SQL);
                    dao.setObject(1, cell1.getColumnValue());
                    dao.setObject(2, cell2.getColumnValue());
                    if (dao.executeUpdate())
                        result = true;
                }
View Full Code Here
513
514
515
516
517
518
519
520
521
522
523
                                               
                DAO dao = DAO.getInstance();
                Iterator nardsIter = notAssignedRowDatas.iterator();
                while (nardsIter.hasNext()) {
                    Vector rowData = (Vector)nardsIter.next();
                    dao.update(Resources.DELETE_BI_SQL);
                    dao.setObject(1, r);
                    dao.setObject(2, ri);
                    dao.setObject(3, rowData.get(0));
                    dao.setObject(4, rowData.get(1));
                    dao.setObject(5, rowData.get(2));
View Full Code Here
534
535
536
537
538
539
540
541
542
543
544
                    dao.setObject(4, rowData.get(1));
                    dao.setObject(5, rowData.get(2));
                    ResultSet rs = dao.executeQuery();
                    try {
                        if (rs.next()) {
                            dao.update(Resources.UPDATE_BI_SQL);
                            dao.setObject(1, rowData.get(4));
                            dao.setObject(2, rowData.get(5));
                            cell = ObjectUtil.findNewCell(row, "RI", "TXT256");
                            dao.setObject(3, cell.getColumnValue());
                            dao.setObject(4, r);
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.