Package realcix20.utils

Examples of realcix20.utils.DAO.query()

792
793
794
795
796
797
798
799
800
801
802
       
        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 {
View Full Code Here
873
874
875
876
877
878
879
880
881
882
883
                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()) {
View Full Code Here
888
889
890
891
892
893
894
895
896
897
898
                } 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 {
View Full Code Here
959
960
961
962
963
964
965
966
967
968
969
        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 {                   
View Full Code Here
986
987
988
989
990
991
992
993
994
995
996
        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);
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
                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()) {
View Full Code Here
378
379
380
381
382
383
384
385
386
387
388
                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();
View Full Code Here
495
496
497
498
499
500
501
502
503
504
505
            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();
View Full Code Here
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
                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 {
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
        FixedAssetClass fixedAsset = (FixedAssetClass)ClassManager.createClass(220);
        StringBuffer sb = new StringBuffer(fixedAsset.getBasicSQL());
        sb.append(" WHERE FA.LD=?");
        String sql = sb.toString();
        DAO dao = DAO.getInstance();
        dao.query(sql);
        dao.setObject(1, ld);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                result = true;
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.