歡迎您光臨本站 註冊首頁

Java輕鬆獲取資料庫欄位名

←手機掃碼閱讀     火星人 @ 2014-03-09 , reply:0
ResultSetMetaData metaDate = rs.getMetaData();
int number = metaDate.getColumnCount();
String[] column = new String[number];
for (int j = 0; j < column.length; j )
{
column[j] = metaDate.getColumnName(j 1);
}
//將欄位名保存到數組column中
String getCatalogName(int column)
Gets the designated column's table's catalog name.
String getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.
int getColumnCount()
Returns the number of columns in this ResultSet object.
int getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters.
String getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays.
String getColumnName(int column)
Get the designated column's name.
int getColumnType(int column)
Retrieves the designated column's SQL type.
String getColumnTypeName(int column)
Retrieves the designated column's database-specific type name.
int getPrecision(int column)
Get the designated column's number of decimal digits.
int getScale(int column)
Gets the designated column's number of digits to right of the decimal point.
String getSchemaName(int column)
Get the designated column's table's schema.
String getTableName(int column)
Gets the designated column's table name


[火星人 ] Java輕鬆獲取資料庫欄位名已經有335次圍觀

http://coctec.com/docs/java/show-post-59962.html