DatabaseMetaData 有关整个数据库的信息:表名、表的索引、数据库产品的名称和版本、数据库支持的操作。
ResultSetMetaData metaData = resultSet2.getMetaData();
System.out.println(metaData);
int columnCount = metaData.getColumnCount();
for (int i = 1; i <= columnCount; i++) {
System.out.println(metaData.getColumnName(i));
columnNameList.add(metaData.getColumnName(i));
}
System.out.println(metaData);的结果为
com.mysql.jdbc.ResultSetMetaData@300bbb05 - Field level information:
com.mysql.jdbc.Field@52235de7[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_id,originalColumnName=db_id,mysqlType=253(FIELD_TYPE_VAR_STRING),flags= PRIMARY_KEY, charsetIndex=33, charsetName=UTF-8]
com.mysql.jdbc.Field@fea12d2[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_comment_id,originalColumnName=db_comment_id,mysqlType=253(FIELD_TYPE_VAR_STRING),flags=, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@5079a127[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_type,originalColumnName=db_type,mysqlType=253(FIELD_TYPE_VAR_STRING),flags= MULTI_KEY, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@2337044[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_service_ip,originalColumnName=db_service_ip,mysqlType=253(FIELD_TYPE_VAR_STRING),flags=, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@52fe350f[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_service_port,originalColumnName=db_service_port,mysqlType=3(FIELD_TYPE_LONG),flags=, charsetIndex=63,
charsetName=US-ASCII]
com.mysql.jdbc.Field@2f4d965a[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_user_name,originalColumnName=db_user_name,mysqlType=253(FIELD_TYPE_VAR_STRING),flags=, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@eca06f9[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_user_password,originalColumnName=db_user_password,mysqlType=253(FIELD_TYPE_VAR_STRING),flags=, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@718fcd04[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_service_name,originalColumnName=db_service_name,mysqlType=253(FIELD_TYPE_VAR_STRING),flags=, charsetIndex=33,
charsetName=UTF-8]
com.mysql.jdbc.Field@17dcfbdb[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=db_max_connect,originalColumnName=db_max_connect,mysqlType=3(FIELD_TYPE_LONG),flags=, charsetIndex=63,
charsetName=US-ASCII]
com.mysql.jdbc.Field@2d1af31a[catalog=dbms,tableName=dbms_database_info,originalTableName=dbms_database_info,columnName=isValid,originalColumnName=isValid,mysqlType=254(FIELD_TYPE_STRING),flags=, charsetIndex=33, charsetName=UTF-8]
metaData.getColumnName(i)是获取表字段的名字