Package realcix20.utils

Examples of realcix20.utils.DAO.query()

147
148
149
150
151
152
153
154
155
156
157
            CorrespondenceClass correspondence = (CorrespondenceClass)ClassManager.createClass(520);
            StringBuffer sb = new StringBuffer(correspondence.getBasicSQL());
            sb.append(" WHERE T.NS=? AND T.P=?");
            String sql = sb.toString();
            DAO dao = DAO.getInstance();
            dao.query(sql);
            dao.setString(1, ns);
            dao.setString(2, p);
            ResultSet rs = dao.executeQuery();
            try {
                if ( (rs.next()) && (ns.equals(rs.getObject("NS"))) && (p.equals(rs.getObject("P"))) ) {
View Full Code Here
292
293
294
295
296
297
298
299
300
301
302
                boolean result = true;               
                String ns = ObjectUtil.findNewCell(correspondenceRow, "T", "NS").getColumnValue().toString();
                String p = ObjectUtil.findNewCell(correspondenceRow, "T", "P").getColumnValue().toString();
                String pa = ObjectUtil.findNewCell(correspondenceRow, "T", "PA").getColumnValue().toString();
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_PA_SQL);
                dao.setString(1, ns);
                dao.setString(2, p);
                dao.setString(3, pa);
                ResultSet rs = dao.executeQuery();
                String urns = null;
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
        
    //��ڳ��򣬸�ݱ�ZMENUR�в˵����ϵ��b��Ӧ�˵������ָ����������м��ￄ1�7
    public static JMenuBar createMenu(ActionListener listener) {           
        JMenuBar menuBar = new JMenuBar();
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_ZMENUR_SQL);
        dao.setString(1, "ROOT");
        ResultSet rs = dao.executeQuery();
        Vector childNames = new Vector();
        try {
            while (rs.next()) {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
       
    //��bmenuName�ӱ�ZMENU���ҵ�ָ��JMenu������װ��
    private static JMenu createMenu(String menuName, ActionListener listener) {
        JMenu menu = new JMenu();
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_ZMENU_SQL);
        dao.setString(1, menuName);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                int mnemonic = rs.getInt("MNEMONIC");
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_ZMENUR_SQL);
        dao.setString(1, menuName);
        rs = dao.executeQuery();
        Vector childMenuNames = new Vector();
        try {                   
            while (rs.next()) {
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
       
    //��bmenuName�ӱ�ZMENU���ҵ�ָ��JMenuItem������װ��
    private static JMenuItem createMenuItem(String menuName, ActionListener listener) {
        JMenuItem menuItem = new JMenuItem();
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_ZMENU_SQL);
        dao.setString(1, menuName);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                int mnemonic = rs.getInt("MNEMONIC");
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
       
    //�ж�һ��˵����Ƿ����Ӳ˵��1�7
    private static boolean isMenu(String menuName) {
        boolean result = false;
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_FROM_ZMENUR_SQL);
        dao.setString(1, menuName);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next())
                result = true;
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
   
    //���TXTID��ָ������4ȡ�ù�ʻ��ı��ￄ1�7
    public static String getTxt(String txtId, String lang) {
        String txt = txtId;      
        final DAO dao = DAO.getInstance();                 
        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
21
22
23
24
25
26
27
28
29
30
31
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {
                txt = rs.getString("LONG");
            } else {
                dao.query(Resources.SELECT_TXT_TABLE_SQL);
                dao.setString(1, txtId);
                dao.setString(2, "EN");
                rs = dao.executeQuery();
                if (rs.next()) {
                    txt = rs.getString("LONG");
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
  public void updateReportSelector() {
      reportSelector.removeActionListener(this);
        reportSelector.removeAllItems();
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_CLS_ALL_LAYOUTS_SQL);
        dao.setObject(1, object.getClsId());
        ResultSet rs = dao.executeQuery();
        try {
            Item item = new Item(object.getClsId() + "." + "0", TxtManager.getTxt("VIEW.XTABLE.REPORTSELECTORALL"));
            reportSelector.addItem(item);
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.