Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

881
882
883
884
885
886
887
888
889
890
891
                        //test
                        if (isMyBook)
                            bookNode.add(objectNode);
                        dao.query(Resources.SELECT_CLS_ALL_LAYOUTS_SQL);
                        dao.setObject(1, clsId);
                        ResultSet rs1 = dao.executeQuery();
                        try {                           
                            while (rs1.next()) {
                                str = new String("CL." + clsId + "." + rs1.getInt("LAYOUT"));
                                DefaultMutableTreeNode layoutNode = new DefaultMutableTreeNode(new ObjectInfo(clsId, rs1.getInt("LAYOUT"), TxtManager.getTxt(str), "report", rs1.getBoolean("ISFAVORITE")));
                                //fixȥ�����������ڵ�ı����ӽڵ�
View Full Code Here
908
909
910
911
912
913
914
915
916
917
918
                DefaultMutableTreeNode bookSettingsNode = new DefaultMutableTreeNode(new ObjectInfo(-1,
                    TxtManager.getTxt("VIEW.MAINFRAME.TREE.ACCOUNTSETTINGNODE"), "accountSettings"));
               
                dao = DAO.getInstance();
                dao.query(Resources.SELECT_ALL_MOD_SQL);
                rs = dao.executeQuery();
                try {                  
                   
                    while (rs.next()) {
                        String mod = rs.getString("MOD");
                        DefaultMutableTreeNode moduleNode = new DefaultMutableTreeNode(new ObjectInfo(-1,
View Full Code Here
917
918
919
920
921
922
923
924
925
926
927
                        String mod = rs.getString("MOD");
                        DefaultMutableTreeNode moduleNode = new DefaultMutableTreeNode(new ObjectInfo(-1,
                                TxtManager.getTxt("MOD.".concat(mod)), "module"));
                        dao.query(Resources.SELECT_MOD_PROPERTIES_SQL);
                        dao.setString(1, mod);
                        ResultSet rs1 = dao.executeQuery();
                        boolean isMyBookSettings = false;
                        while (rs1.next()) {
                            isMyBookSettings = true;
                            int clsId = rs1.getInt("CLSID");
                            String str = new String("CLS." + clsId);
View Full Code Here
929
930
931
932
933
934
935
936
937
938
939
                                    TxtManager.getTxt(str), "object"));
                            //test
                           
                            dao.query(Resources.SELECT_CLS_ALL_LAYOUTS_SQL);
                            dao.setObject(1, clsId);
                            ResultSet rs2 = dao.executeQuery();
                            try {
                                while (rs2.next()) {
                                    str = new String("CL." + clsId + "." + rs2.getInt("LAYOUT"));
                                    DefaultMutableTreeNode layoutNode = new DefaultMutableTreeNode(new ObjectInfo(clsId, rs2.getInt("LAYOUT"),
                                            TxtManager.getTxt(str), "report", rs2.getBoolean("ISFAVORITE")));
View Full Code Here
270
271
272
273
274
275
276
277
278
279
280
            setCurrentObject(currentObject);
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_CL_SQL);
            dao.setInt(1, currentObject.getClsId());
            dao.setInt(2, layoutId);
            ResultSet rs = dao.executeQuery();
            String report_basic_sql = null;
            //fix CSQL
            String csql = null;
            try {
                if (rs.next()){
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
        int ri = (Integer)ObjectUtil.findNewCell(regRow, "RI", "RI").getColumnValue();
        DAO dao = DAO.getInstance();
        dao.query(Resources.REGS_MANAGER_R_RI_SQL);
        dao.setInt(1, r);
        dao.setInt(2, ri);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                result = rs.getBoolean("STATUS");
            }
            rs.close();
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    //��ȡ��GV�����GVGroup���ϲ������ӦGV��
    public static Vector generateGVGroups() {       
        Vector gvGroups = new Vector();           
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_GROUPS_FROM_GV_SQL);
        ResultSet rs = dao.executeQuery();
        try {
            while (rs.next()) {
                GVGroup gvGroup = new GVGroup(rs.getString("GRP"), new Vector());
                gvGroups.add(gvGroup);
            }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }                  
        dao.query(Resources.SELECT_GV_SQL);
        rs = dao.executeQuery();
        try {
            while (rs.next()) {                   
                String vid = rs.getString("VID");
                String vvalue = rs.getString("VVALUE");
                int ordinal = rs.getInt("ORDINAL");
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
        JComponent component = null;
        if (gv.getInputtype() == 1) {
            JComboBox comboBox = new JComboBox();
            DAO dao = DAO.getInstance();
            dao.query(gv.getInputpar());
            ResultSet rs = dao.executeQuery();
            try {
                while (rs.next()) {
                    ResultSetMetaData rsmd = rs.getMetaData();
                    Item item = null;
                    if (rsmd.getColumnCount() == 1) {
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    super(container);
   

    DAO dao = DAO.getInstance();
    dao.query(Resources.SELECT_EARLIST_RDATE);
    ResultSet rs = dao.executeQuery();
    try {
      if (rs.next()) {
        startDate = rs.getDate(1);
      }
    } catch (SQLException e1) {
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.