Package realcix20.utils

Examples of realcix20.utils.DAO

791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
        }
       
        public static String getLD(Row correspondenceRow) {
           
                String ld = null;
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_LD_FROM_PA_SQL);
                dao.setObject(1, ObjectUtil.findNewCell(correspondenceRow, "T", "NS").getColumnValue().toString());
                dao.setObject(2, ObjectUtil.findNewCell(correspondenceRow, "T", "P").getColumnValue().toString());
                dao.setObject(3, ObjectUtil.findNewCell(correspondenceRow, "T", "PA").getColumnValue().toString());
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        ld = rs.getString("LD");
                    }
                    rs.close();
View Full Code Here
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
                Cell paCell = ObjectUtil.findNewCell(mainRow, "T", "PA");
                String pa = (String)paCell.getColumnValue();
               
                String urns = null;
                String urp = null;
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_URNS_URP_FORM_P_SQL);
                dao.setObject(1, ns);
                dao.setObject(2, p);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        urns = rs.getString("URNS");
                        urp = rs.getString("URP");
                    }
                    rs.close();
                } catch (Exception e) {
                    e.printStackTrace();
                }
               
                String urpa = null;
                dao.query(Resources.SELECT_URPA_FROM_PA_SQL);
                dao.setObject(1, ns);
                dao.setObject(2, p);
                dao.setObject(3, pa);
                rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        urpa = rs.getString("URPA");
                    }
                    rs.close();
View Full Code Here
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
       
        private boolean isthisPartnerAccountCanTransfer(String ns, String p, String pa) {
           
                boolean result = false;
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_URPA_FROM_PA_SQL);
                dao.setObject(1, ns);
                dao.setObject(2, p);
                dao.setObject(3, pa);               
                ResultSet rs = dao.executeQuery();
                try {                   
                    if (rs.next()) {                       
                        String urpa = rs.getString("urpa");                      
                        if ( (urpa == null) || (urpa.trim().equals("")) )
                            result = false;
View Full Code Here
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
       
        private PrivateKey getPriKey(String ns, String p, String pa) {
           
                PrivateKey priKey = null;
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_PRIKEY_FROM_PA_BY_NS_P_PA_SQL);
                dao.setObject(1, ns);
                dao.setObject(2, p);
                dao.setObject(3, pa);
                dao.setObject(4, ns);
                dao.setObject(5, p);
                dao.setObject(6, pa);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next())
                        priKey = (PrivateKey)rs.getObject("PRIKEY");
                    rs.close();
                } catch (Exception e) {
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    public static void deleteDependThings(Row anaTypeRow) {       
        String at = ObjectUtil.findNewCell(anaTypeRow, "AT", "AT").getColumnValue().toString();
        AnaProfileClass anaProfile = (AnaProfileClass)ClassManager.createClass(130);       
        StringBuffer sb = new StringBuffer("DELETE FROM " + anaProfile.getChildTableName() + " WHERE AT=?");
        String sql = sb.toString();
        DAO dao = DAO.getInstance();     
        dao.update(sql);
        dao.setObject(1, at);
        dao.executeUpdate();  
        sb = new StringBuffer("DELETE FROM " + anaProfile.getMainTableName() + "" +
                " WHERE APF NOT IN (SELECT APF FROM " + anaProfile.getChildTableName() + ")");
        sql = sb.toString();
//        System.out.println(sql);
        dao.update(sql);
        dao.executeUpdate();
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
        if (e.getActionCommand().equals("Cancel")) {
          container.setEnabled(true);
            dispose();
        } else if (e.getActionCommand().endsWith("Confirm")) {
            if (!nameField.getText().trim().equals("")) {
                DAO dao = DAO.getInstance();
                String txtId = "CL." + object.getClsId() + "." + layout;
                Item item = (Item)languageChooser.getSelectedItem();
                String lang = item.getFactValue().toString();
                String long_c = nameField.getText();

                dao.query(Resources.SELECT_TXT_TABLE_SQL);
                dao.setString(1, txtId);
                dao.setString(2, lang);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        dao.update(Resources.UPDATE_TXT_SQL);
                        dao.setString(1, long_c);
                        dao.setString(2, txtId);
                        dao.setString(3, lang);
                        dao.executeUpdate();
                    } else {
                        dao.update(Resources.INSERT_TXT_SQL);                           
                        dao.setString(1, txtId);
                        dao.setString(2, lang);
                        dao.setString(3, long_c);
                        dao.executeUpdate();
                    }
                    rs.close();
                } catch (Exception ee) {
                }
                container.setEnabled(true);
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
388
389
//              make selectedRow 1 as templateRow
                if(i==0){
                  newRow = ObjectUtil.cloneRow(getContainer().getCurrentObject(),row);                 
                    //set child row need added & set new primary key to childRows
                    //get new PrimaryKey R.R , RI.R                   
                    DAO dao = DAO.getInstance();
                    dao.query(Resources.SELECT_MAX_R_FROM_R_SQL);
                    ResultSet rs = dao.executeQuery();
                    try {
                        if (rs.next())
                            newR = rs.getInt(1) + 1;
                        rs.close();
                    } catch (Exception e) {
View Full Code Here
494
495
496
497
498
499
500
501
502
503
504
505
506
            container.getCurrentObject().loadChilds(selectedRow);           
            Row newRow = ObjectUtil.cloneRow(container.getCurrentObject(), selectedRow);
            //set child row need added & set new primary key to childRows
            //get new PrimaryKey R.R , RI.R
            int newR = 0;
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_MAX_R_FROM_R_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next())
                    newR = rs.getInt(1) + 1;
                rs.close();
            } catch (Exception e) {
View Full Code Here
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
                DefaultMutableTreeNode node = (DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
                if (node.getUserObject() instanceof ObjectInfo) {
                    ObjectInfo oj = (ObjectInfo)node.getUserObject();
                    if (oj.flag.equals("layout")) {

                        DAO dao = DAO.getInstance();
                        dao.query(Resources.SELECT_CL_SQL);
                        dao.setInt(1, getContainer().getCurrentObject().getClsId());
                        dao.setInt(2, oj.layout);
                        ResultSet rs = dao.executeQuery();
                        try {

                            if (rs.next()) {
                                if (rs.getBoolean("ISFAVORITE") == !favorite) {

                                    dao.update(Resources.UPDATE_CL_ISFAVORITE_SQL);
                                    dao.setBoolean(1, favorite);
                                    dao.setInt(2, getContainer().getCurrentObject().getClsId());
                                    dao.setInt(3, oj.layout);
                                    dao.executeUpdate();
                                    getContainer().updateTree();
                                   
                                }
                            }
View Full Code Here
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
    }
   
    private void exitApplication() {      
            int n = DialogManager.showYesNoDialog(getContainer(), TxtManager.getTxt("alert.exit"));          
            if (n == 0) {//exit application
                DAO dao = DAO.getInstance();
                dao.commit();
                dao.deleteDAO();
                System.exit(0);               
            }
       
    }       
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.