jdbc获取数据库信息转-优快云博客

本文链接：https://blog.youkuaiyun.com/jslfl/article/details/84237412

本文演示如何使用Java连接MySQL数据库，获取指定数据库中所有表及其列详细信息，包括表名、表注释、列名、列注释及数据类型。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class GetDBTablesInfo {

/**
* @param args
*/
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?user=root&password=123456";
Connection conn = DriverManager.getConnection(url);

DatabaseMetaData databaseMetaData = conn.getMetaData();

// 获取所有表
ResultSet tableSet = databaseMetaData.getTables(null, "%", "%",
new String[] { "TABLE" });
while (tableSet.next()) {
String tableName = tableSet.getString("TABLE_NAME");
String tableComment = tableSet.getString("REMARKS");
System.out.println("tableName=" + tableName);
System.out.println("tableComment=" + tableComment);

// 获取tableName表列信息
ResultSet columnSet = databaseMetaData.getColumns(null, "%",
tableName, "%");
while (columnSet.next()) {
String columnName = columnSet.getString("COLUMN_NAME");
String columnComment = columnSet.getString("REMARKS");
String sqlType = columnSet.getString("DATA_TYPE");
System.out.println(columnName);
System.out.println(columnComment);
System.out.println(sqlType);
}
}

}

}

http://www.zhuoda.org/lunzi/97624.html