JDBC query table definition

来源:互联网 发布:mac mini是什么 编辑:程序博客网 时间:2024/06/06 18:56


JDBC retrieve table columns information

    public void describeTable(String tableName) {        try {            PreparedStatement pstmt = conn                    .prepareStatement("select * from <TABLENAME> where 1 = 0");            ResultSet rs = pstmt.executeQuery();            ResultSetMetaData rsmd = rs.getMetaData();            for (int i = 1; i <= rsmd.getColumnCount(); i++) {                System.out.printf(                        "Column[%02d]: %s    %s(%d, %d)\n", i,                        rsmd.getColumnName(i), rsmd.getColumnTypeName(i),                        rsmd.getPrecision(i), rsmd.getScale(i));            }            rs.close();            pstmt.close();        } catch (SQLException e) {            e.printStackTrace();        }    }


0 0
原创粉丝点击