mysql 中的db是啥意思_数据库中的表段名/字段名分别是啥意思

2017-07-28

Java获得数据库字段名方法是什么呢？

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 ta...全部

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。

收起