Package realcix20.utils

Examples of realcix20.utils.DAO.executeQuery()

150
151
152
153
154
155
156
157
158
159
160
            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"))) ) {
                    result = true;
                }
                rs.close();
View Full Code Here
296
297
298
299
300
301
302
303
304
305
306
                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;
                String urp = null;
                String urpa = null;
                PublicKey pubkey = null;
                try {
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
    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()) {
                childNames.add(rs.getString("MENU2"));
            }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    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");
                if (mnemonic != 0) {
                    menu.setText(MnemonicGenerator.generateMnemonicString(getMenuTxt(menuName), mnemonic));
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
            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()) {
                childMenuNames.add(rs.getString("MENU2"));                           
            }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    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");
                if (mnemonic != 0) {
                    menuItem.setText(MnemonicGenerator.generateMnemonicString(getMenuTxt(menuName), mnemonic));
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    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;
            rs.close();
        } catch (Exception e) {
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
        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()) {
                txt = rs.getString("LONG");
            } else {
                dao.query(Resources.SELECT_TXT_TABLE_SQL);
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
                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");
                }
            }
            rs.close();
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
      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);
            if(layoutId==0) reportSelector.setSelectedItem(item);
            while (rs.next()) {
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.