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
- JDBC query table definition
- DB2 check table definition
- Generate DB2 table definition COPYBOOK
- spring jdbc之query
- MySQL Error 1293 - Incorrect table definition (TIMESTAMP)
- Query index for a table
- query which table is locked
- JDBC(PreparedStatement)--Create Table
- JDBC(Statement)--Create Table
- The definition of JIL Widget manager database table
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- 解决ADF quick query/query with table bug 12551764
- Flashback Query Flashback Version Query Flashback Table Flashback Transaction
- 46、Power Query-Table.FillDown函数简介
- one of methods of query table a and table b
- 后台JSON与JAVA数据的转换
- 基于laravel 的antvel 迁移数据出错
- 博弈——Nim&SG函数函数(hdu1848)
- Objective C 学习
- sql中AUTO INCREMENT 字段
- JDBC query table definition
- 漫画告诉你什么是DDoS攻击?
- kafka-node
- OPENCV HS算法源码
- HDU1274 Hat’s Words(字典树 数组实现)
- 图像缩放双立方插值
- DB2 define external scalar java user-defined function
- 数据结构(六)——栈的应用
- 使用 Eclipse Memory Analyzer 进行堆转储文件分析