Package realcix20.utils

Examples of realcix20.utils.DAO

632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
                    sb.append(pkColumn.getColumnName() + "=? AND ");
                }               
            }
            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());
            }             
            dao.executeUpdate(); 
        }             
        //Delete mainTables
        StringBuffer sb = new StringBuffer("DELETE FROM ");
        sb.append(mainTableName + " WHERE ");
        Vector whereColumns = new Vector();
        Iterator pkColumnIter = pkColumns.iterator();
        while (pkColumnIter.hasNext()) {
            Column pkColumn = (Column)pkColumnIter.next();
            if (pkColumn.getTableName().equals(mainTableName)) {
                whereColumns.add(pkColumn);
                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());
        }        
        dao.executeUpdate(); 
        dao.commit();
        dao.setAutoCommit(true);       
        return true;       
    }
View Full Code Here
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
                }
            }
            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());               
            }
            dao.executeUpdate();
            dao.commit();
            dao.setAutoCommit(true);
        }      
        return true;       
    }
View Full Code Here
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
            }
            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()) {
                Column column = (Column)columnIterator.next();
                Object value = getNewCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
            columnIterator = whereColumns.iterator();
            while (columnIterator.hasNext()) {
                Column column = (Column)columnIterator.next();
                Object value = getOldCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
           
            result = dao.executeUpdate();
           
            if (test) {
                dao.rollback();
            } else {
                if (!result) {
                    dao.rollback();
                }
                else {
                   
                    dao.commit();
                   
                    Iterator rowIter = row.getRowSet().getRows().iterator();
                    while (rowIter.hasNext()) {
                       
                        Row childRow = (Row)rowIter.next();
                        if (childRow.isDelete())
                            classDelete_Child(childRow);
                        else if (childRow.isAdd())
                            classInsert_Child(childRow, false);
                        else if (childRow.isModify())
                            classUpdate_Child(childRow, false);
                       
                    }
                                       
                }
            }
                   
            dao.setAutoCommit(true);
           
            return result;
           
    }
View Full Code Here
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
            }
            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()) {
                Column column = (Column)columnIterator.next();
                Object value = getNewCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
            columnIterator = whereColumns.iterator();
            while (columnIterator.hasNext()) {
                Column column = (Column)columnIterator.next();
                Object value = getOldCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
           
            result = dao.executeUpdate();
           
            if (test)
                dao.rollback();
            else {
                if (!result)
                    dao.rollback();
                else
                    dao.commit();
            }
           
            dao.setAutoCommit(true);
                           
        return result;
       
    }
View Full Code Here
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
            public LDTableModel() {                                   
                    Vector names = new Vector();
                    Vector dataValues = new Vector();
                    names.add(ObjectUtil.findColumnTxt(200, "LD", "LD"));
                    names.add(ObjectUtil.findColumnTxt(200, "LD", "RUSER"));
                    DAO dao = DAO.getInstance();
                    dao.query(Resources.SELECT_ALL_LD_FROM_LD_SQL);
                    ResultSet rs = dao.executeQuery();
                    try {
                        while (rs.next()) {
                            Vector rowDatas = new Vector();
                            rowDatas.add(rs.getString("LD"));
                            rowDatas.add(rs.getString("RUSER"));
View Full Code Here
36
37
38
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
            dao.executeUpdate();         
        }
       
        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);
      dao.executeUpdate();
        }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
      dao.executeUpdate();
        }
       
        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);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
        }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
162
163
            ObjectUtil.findNewCell(newRegRow, "R", "CREATED").setColumnValue(now);
            ObjectUtil.findNewCell(newRegRow, "R", "CREATEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
            ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGED").setColumnValue(now);
            ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
            ObjectUtil.findNewCell(newRegRow, "R", "TXT256").setColumnValue(TxtManager.getTxt("VIEW.CURRENCYEVALUATION.TITLE"));
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_RI_XR_INFO_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                int i = 1;
                double sum = 0.0;
                while (rs.next()) {
                    if (rs.getDouble("LAMT") != 0.0) {       
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
220
221
222
            String ip = ObjectUtil.findNewCell(ipRow, "IP", "IP").getColumnValue().toString();
            RegClass reg = (RegClass)ClassManager.createClass(510);
            StringBuffer sb = new StringBuffer(reg.getBasicSQL());
            sb.append(" WHERE RI.IM=? AND RI.IP=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.setObject(1, im);
            dao.setObject(2, ip);
            ResultSet rs = dao.executeQuery();
            try {
                if ( (rs.next()) && (im.equals(rs.getObject("IM"))) && (ip.equals(rs.getObject("IP"))) ) {
                    result = true;
                }
                rs.close();
View Full Code Here
TOP

Related Classes of realcix20.utils.DAO

  • com.jgoodies.forms.factories.DefaultComponentFactory
  • com.jgoodies.forms.layout.CellConstraints
  • com.jgoodies.forms.layout.ColumnSpec
  • com.jgoodies.forms.layout.FormLayout
  • com.jgoodies.forms.layout.RowSpec
  • info.clearthought.layout.TableLayout
  • org.jdesktop.swingx.decorator.AlternateRowHighlighter
  • org.jdesktop.swingx.decorator.HighlighterPipeline
  • org.jdesktop.swingx.decorator.RolloverHighlighter
  • org.jdesktop.swingx.JXTable
    • Copyright © 2018 www.massapicom. 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.