Package net.lr.tutorial.karaf.db.command

Examples of net.lr.tutorial.karaf.db.command.ShellTable

64
65
66
67
68
69
70
71
72
            throw new RuntimeException("No DataSource selected");
        }
        Connection con = dataSource.getConnection();
        DatabaseMetaData metaData = con.getMetaData();
        ResultSet rs = metaData.getTables(null, null, null, null);
        ShellTable table = printResult(rs);
        rs.close();
        return table;
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        Connection con = dataSource.getConnection();
        Statement stmt = null;
        try {
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            ShellTable table = printResult(rs);
            rs.close();
            return table;
        } catch (Exception e) {
            throw e;
        } finally {
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
            }
        }
    }

    private ShellTable printResult(ResultSet rs) throws SQLException {
        ShellTable table = new ShellTable();
        ResultSetMetaData meta = rs.getMetaData();
        for (int c = 1; c <= meta.getColumnCount(); c++) {
            table.header.add(meta.getColumnLabel(c));
        }
        while (rs.next()) {
            List<String> row = table.addRow();
            for (int c = 1; c <= meta.getColumnCount(); c++) {
                row.add(rs.getString(c));
            }
        }
        return table;
View Full Code Here
62
63
64
65
66
67
68
69
70
            throw new RuntimeException("No DataSource selected");
        }
        Connection con = dataSource.getConnection();
        DatabaseMetaData metaData = con.getMetaData();
        ResultSet rs = metaData.getTables(null, null, null, null);
        ShellTable table = printResult(rs);
        rs.close();
        return table;
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
        Connection con = dataSource.getConnection();
        Statement stmt = null;
        try {
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            ShellTable table = printResult(rs);
            rs.close();
            return table;
        } catch (Exception e) {
            throw e;
        } finally {
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
            }
        }
    }

    private ShellTable printResult(ResultSet rs) throws SQLException {
        ShellTable table = new ShellTable();
        ResultSetMetaData meta = rs.getMetaData();
        for (int c = 1; c <= meta.getColumnCount(); c++) {
            table.header.add(meta.getColumnLabel(c));
        }
        while (rs.next()) {
            List<String> row = table.addRow();
            for (int c = 1; c <= meta.getColumnCount(); c++) {
                row.add(rs.getString(c));
            }
        }
        return table;
View Full Code Here
70
71
72
73
74
75
76
77
78
            throw new RuntimeException("No DataSource selected");
        }
        Connection con = dataSource.getConnection();
        DatabaseMetaData metaData = con.getMetaData();
        ResultSet rs = metaData.getTables(null, null, null, null);
        ShellTable table = printResult(rs);
        rs.close();
        return table;
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
        Connection con = dataSource.getConnection();
        Statement stmt = null;
        try {
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            ShellTable table = printResult(rs);
            rs.close();
            return table;
        } catch (Exception e) {
            throw e;
        } finally {
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
            }
        }
    }

    private ShellTable printResult(ResultSet rs) throws SQLException {
        ShellTable table = new ShellTable();
        ResultSetMetaData meta = rs.getMetaData();
        for (int c = 1; c <= meta.getColumnCount(); c++) {
            table.header.add(meta.getColumnLabel(c));
        }
        while (rs.next()) {
            List<String> row = table.addRow();
            for (int c = 1; c <= meta.getColumnCount(); c++) {
                row.add(rs.getString(c));
            }
        }
        return table;
View Full Code Here
TOP

Related Classes of net.lr.tutorial.karaf.db.command.ShellTable

  • net.lr.tutorial.karaf.db.service.DbAccess
    • 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.