ResultSetMetaData获取数据库表字段

使用ResultSetMetaData获取MySQL数据库字段信息

最新推荐文章于 2024-08-09 04:08:38 发布

原创最新推荐文章于 2024-08-09 04:08:38 发布 · 3k 阅读

1 ·

CC 4.0 BY-SA版权

这篇博客介绍了如何利用Java中的ResultSetMetaData类获取数据库表字段的详细信息，包括字段名称、类型和标志等，展示了如何遍历并打印ResultSetMetaData中的字段元数据。

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]