Package realcix20.utils

Examples of realcix20.utils.DAO.update()

633
634
635
636
637
638
639
640
641
642
643
                }               
            }
            sb.delete(sb.lastIndexOf("AND"), sb.lastIndexOf("AND") + 3);
            String sql = sb.toString();
            DAO dao = DAO.getInstance();       
            dao.update(sql);
            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());
            }             
View Full Code Here
655
656
657
658
659
660
661
662
663
664
665
                sb.append(pkColumn.getColumnName() + "=? AND ");
            }               
        }
        sb.delete(sb.lastIndexOf("AND"), sb.lastIndexOf("AND") + 3);
        String sql = sb.toString();  
        dao.update(sql);
        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());
        }        
View Full Code Here
688
689
690
691
692
693
694
695
696
697
698
            }
            sb.delete(sb.lastIndexOf("AND"), sb.lastIndexOf("AND") + 3);
            String sql = sb.toString();
            //Delete Child Row
            DAO dao = DAO.getInstance();
            dao.update(sql);
            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());               
            }
View Full Code Here
738
739
740
741
742
743
744
745
746
747
748
            sb.delete(sb.lastIndexOf("AND"),sb.lastIndexOf("AND") + 3);
            String sql = sb.toString();     
           
            //Update rows
            DAO dao = DAO.getInstance();
            dao.update(sql);
            dao.setAutoCommit(false);
           
            int currentParameter = 1;
            columnIterator = needModifyColumns.iterator();
            while (columnIterator.hasNext()) {
View Full Code Here
825
826
827
828
829
830
831
832
833
834
835
            sb.delete(sb.lastIndexOf("AND"),sb.lastIndexOf("AND") + 3);
            String sql = sb.toString();
           
            //Update rows
            DAO dao = DAO.getInstance();
            dao.update(sql);
            dao.setAutoCommit(false);
           
            int currentParameter = 1;
            columnIterator = needModifyColumns.iterator();
            while (columnIterator.hasNext()) {
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
       
       
        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);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
            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();         
        }
       
        public static void delete(int r){
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
       
        public static void delete(int r){
          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);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
//          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();
        }
       
        public static void deleteRelativeThings(int r, int ri) {
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
        }
       
        public static void deleteRelativeThings(int r, int ri) {
            //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);
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.