Package realcix20.utils

Examples of realcix20.utils.DAO.executeUpdate()

1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
    public static void deleteR(int r) {
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_R_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();
       
    }      
   
}
View Full Code Here
513
514
515
516
517
518
519
520
521
522
523
                    dao.setObject(currentParameter, value);
                    currentParameter++;
                }
            }
           
            result = dao.executeUpdate();
           
            if (test) {
                dao.rollback();
            }
            else {
View Full Code Here
594
595
596
597
598
599
600
601
602
603
604
                    dao.setObject(currentParameter, value);
                    currentParameter++;
                }
            }
           
            result = dao.executeUpdate();
           
            if (test)
                dao.rollback();
            else {
                if (!result)
View Full Code Here
639
640
641
642
643
644
645
646
647
648
649
            for (int i = 0; i < whereColumns.size(); i++) {
                Column column = (Column)columns.get(i);
                Cell cell = ObjectUtil.findNewCell(row, column.getTableName(), column.getColumnName());
                dao.setObject(i+1, cell.getColumnValue());
            }             
            dao.executeUpdate(); 
        }             
        //Delete mainTables
        StringBuffer sb = new StringBuffer("DELETE FROM ");
        sb.append(mainTableName + " WHERE ");
        Vector whereColumns = new Vector();
View Full Code Here
661
662
663
664
665
666
667
668
669
670
671
        for (int i = 0; i < whereColumns.size(); i++) {
            Column column = (Column)columns.get(i);
            Cell cell = ObjectUtil.findNewCell(row, column.getTableName(), column.getColumnName());
            dao.setObject(i+1, cell.getColumnValue());
        }        
        dao.executeUpdate(); 
        dao.commit();
        dao.setAutoCommit(true);       
        return true;       
    }
   
View Full Code Here
694
695
696
697
698
699
700
701
702
703
704
            for (int i = 0; i < whereColumns.size(); i++) {
                Column column = (Column)whereColumns.get(i);
                Cell cell = ObjectUtil.findNewCell(row, column.getTableName(), column.getColumnName());
                dao.setObject(i+1, cell.getColumnValue());               
            }
            dao.executeUpdate();
            dao.commit();
            dao.setAutoCommit(true);
        }      
        return true;       
    }
View Full Code Here
757
758
759
760
761
762
763
764
765
766
767
                Object value = getOldCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
           
            result = dao.executeUpdate();
           
            if (test) {
                dao.rollback();
            } else {
                if (!result) {
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
        private static void deleteRelativeThings(int r){
            //first,delete rpn
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_RPN_BY_R_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();
            //next,delete budgets(BI)
            dao.update(Resources.DELETE_BI_BY_R_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();         
        }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
            dao.setInt(1, r);
            dao.executeUpdate();
            //next,delete budgets(BI)
            dao.update(Resources.DELETE_BI_BY_R_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();         
        }
       
        public static void delete(int r){
          deleteRelativeThings(r);         
          DAO dao = DAO.getInstance();
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
          deleteRelativeThings(r);         
          DAO dao = DAO.getInstance();
//          Delete childTables
          dao.update(Resources.DELETE_RI_SQL);
      dao.setInt(1, r);
      dao.executeUpdate();
//      Delete mainTables     
          dao.update(Resources.DELETE_R_SQL);
      dao.setInt(1, r);
      dao.executeUpdate();
        }
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.