Examples with ResultSetMetaData java.sql.ResultSetMetaData used on opensource projects

Example 61 with ResultSetMetaData

use of java.sql.ResultSetMetaData in project voltdb by VoltDB.

the class TestJDBC method testDecimal.

public void testDecimal() {
    String ddl = "create table test (cash decimal default 23.587);";
    String dml = "insert into test values (123.45678911111);";
    String query = "select * from test;";
    Connection dbconn;
    try {
        Class.forName("org.hsqldb_voltpatches.jdbcDriver");
        dbconn = DriverManager.getConnection("jdbc:hsqldb:mem:x1", "sa", "");
        dbconn.setAutoCommit(true);
        dbconn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
        Statement stmt = dbconn.createStatement();
        stmt.execute(ddl);
        SQLWarning warn = stmt.getWarnings();
        if (warn != null)
            System.out.println("warn: " + warn.getMessage());
        assertTrue(warn == null);
        long ucount = stmt.executeUpdate(dml);
        assertTrue(ucount == 1);
        ResultSet rs = stmt.executeQuery(query);
        assertTrue(rs != null);
        ResultSetMetaData rsmd = rs.getMetaData();
        assertTrue(rsmd != null);
        assertTrue(rsmd.getColumnCount() == 1);
        /*System.out.printf("Typename %s, Type %d, Precision %s, Scale %d, Classname %s\n",
                    rsmd.getColumnTypeName(1),
                    rsmd.getColumnType(1),
                    rsmd.getPrecision(1),
                    rsmd.getScale(1),
                    rsmd.getColumnClassName(1));*/
        boolean success = rs.next();
        assertTrue(success);
        BigDecimal x = rs.getBigDecimal(1);
        assertNotNull(x);
        //System.out.printf("Value: %.10f\n", x.doubleValue());
        BigDecimal expected = new BigDecimal(123.4567);
        assertTrue(x.subtract(expected).abs().doubleValue() < .01);
        try {
            stmt.execute("SHUTDOWN;");
        } catch (Exception e) {
        }
        ;
        dbconn.close();
        System.gc();
    } catch (Exception e) {
        e.printStackTrace();
        assertTrue(false);
    }
}

Example 62 with ResultSetMetaData

use of java.sql.ResultSetMetaData in project voltdb by VoltDB.

the class TestJDBC method testTinyInt.

public void testTinyInt() {
    String ddl = "create table test (cash tinyint default 0);";
    String dml = "insert into test values (123);";
    String query = "select * from test;";
    Connection dbconn;
    try {
        Class.forName("org.hsqldb_voltpatches.jdbcDriver");
        dbconn = DriverManager.getConnection("jdbc:hsqldb:mem:x1", "sa", "");
        dbconn.setAutoCommit(true);
        dbconn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
        Statement stmt = dbconn.createStatement();
        stmt.execute(ddl);
        SQLWarning warn = stmt.getWarnings();
        if (warn != null)
            System.out.println("warn: " + warn.getMessage());
        assertTrue(warn == null);
        long ucount = stmt.executeUpdate(dml);
        assertTrue(ucount == 1);
        ResultSet rs = stmt.executeQuery(query);
        assertTrue(rs != null);
        ResultSetMetaData rsmd = rs.getMetaData();
        assertTrue(rsmd != null);
        assertTrue(rsmd.getColumnCount() == 1);
        /*System.out.printf("Typename %s, Type %d, Precision %s, Scale %d, Classname %s\n",
                    rsmd.getColumnTypeName(1),
                    rsmd.getColumnType(1),
                    rsmd.getPrecision(1),
                    rsmd.getScale(1),
                    rsmd.getColumnClassName(1));*/
        boolean success = rs.next();
        assertTrue(success);
        int x = rs.getInt(1);
        assertTrue(x == 123);
        try {
            stmt.execute("SHUTDOWN;");
        } catch (Exception e) {
        }
        ;
        dbconn.close();
        System.gc();
    } catch (Exception e) {
        e.printStackTrace();
        assertTrue(false);
    }
}

Example 63 with ResultSetMetaData

use of java.sql.ResultSetMetaData in project voltdb by VoltDB.

the class DatabaseManager method formatResultSet.

void formatResultSet(ResultSet r) {
    if (r == null) {
        String[] g = new String[1];
        g[0] = "Result";
        gResult.setHead(g);
        g[0] = "(empty)";
        gResult.addRow(g);
        return;
    }
    try {
        ResultSetMetaData m = r.getMetaData();
        int col = m.getColumnCount();
        String[] h = new String[col];
        for (int i = 1; i <= col; i++) {
            h[i - 1] = m.getColumnLabel(i);
        }
        gResult.setHead(h);
        while (r.next()) {
            for (int i = 1; i <= col; i++) {
                try {
                    h[i - 1] = r.getString(i);
                    if (r.wasNull()) {
                        h[i - 1] = "(null)";
                    }
                } catch (SQLException e) {
                }
            }
            gResult.addRow(h);
        }
        r.close();
    } catch (SQLException e) {
    }
}

Example 64 with ResultSetMetaData

use of java.sql.ResultSetMetaData in project MSEC by Tencent.

the class DBUtil method findMoreRefResult.

//查询数据库，返回所有满足条件的记录， 使用java反射机制，将记录映射到java类T
public <T> ArrayList<T> findMoreRefResult(String sql, List<Object> params, Class<T> cls) throws Exception {
    ArrayList<T> list = new ArrayList<T>();
    int index = 1;
    pstmt = connection.prepareStatement(sql);
    if (params != null && !params.isEmpty()) {
        for (int i = 0; i < params.size(); i++) {
            pstmt.setObject(index++, params.get(i));
        }
    }
    resultSet = pstmt.executeQuery();
    ResultSetMetaData metaData = resultSet.getMetaData();
    int cols_len = metaData.getColumnCount();
    while (resultSet.next()) {
        T resultObject = cls.newInstance();
        for (int i = 0; i < cols_len; i++) {
            String cols_name = metaData.getColumnName(i + 1);
            Object cols_value = resultSet.getObject(cols_name);
            if (cols_value == null) {
                cols_value = "";
            }
            Field field = cls.getDeclaredField(cols_name);
            //��javabean�ķ���Ȩ��
            field.setAccessible(true);
            field.set(resultObject, cols_value);
        }
        list.add(resultObject);
    }
    resultSet.close();
    pstmt.close();
    return list;
}

Example 65 with ResultSetMetaData

use of java.sql.ResultSetMetaData in project MSEC by Tencent.

the class DBUtil method findSimpleResult.

//查询数据库，只返回一条记录，该记录的字段保存在Map里返回，字段名作为key，字段值作为value
public Map<String, Object> findSimpleResult(String sql, List<Object> params) throws SQLException {
    Map<String, Object> map = new HashMap<String, Object>();
    int index = 1;
    pstmt = connection.prepareStatement(sql);
    if (params != null && !params.isEmpty()) {
        for (int i = 0; i < params.size(); i++) {
            pstmt.setObject(index++, params.get(i));
        }
    }
    resultSet = pstmt.executeQuery();
    ResultSetMetaData metaData = resultSet.getMetaData();
    int col_len = metaData.getColumnCount();
    if (resultSet.next()) {
        for (int i = 0; i < col_len; i++) {
            String cols_name = metaData.getColumnName(i + 1);
            Object cols_value = resultSet.getObject(cols_name);
            if (cols_value == null) {
                cols_value = "";
            }
            map.put(cols_name, cols_value);
        }
    }
    resultSet.close();
    pstmt.close();
    return map;
}