直接上代码:
@Test
public void getTableConstruct() {
try {
Connection conn = getJdbcConn();
DatabaseMetaData dbmd = conn.getMetaData();
ResultSet rs = dbmd.getColumns(conn.getCatalog(), "DB2ADMIN", tableName, null);
while(rs.next()){
String columnName = rs.getString("COLUMN_NAME");
System.out.print(columnName+"\t");
String typeName = rs.getString("TYPE_NAME");
System.out.println(typeName);
}
} catch (SQLException e) {
e.printStackTrace();
}
}