java抽取mysql数据库表结构

import java.sql.*;

public class DatabaseSchemaExtractor {
    public static void main(String[] args) {
        // MySQL数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        try {
            // 加载MySQL JDBC驱动
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);

            // 获取数据库元数据
            DatabaseMetaData metaData = conn.getMetaData();

            // 获取所有表的结果集
            ResultSet tables = metaData.getTables(null, null, null, new String[]{"TABLE"});

            // 遍历表结构信息
            while (tables.next()) {
                // 获取表名
                String tableName = tables.getString("TABLE_NAME");
                System.out.println("表名: " + tableName);

                // 获取表的列信息
                ResultSet columns = metaData.getColumns(null, null, tableName, null);

                // 遍历列信息
                while (columns.next()) {
                    String columnName = columns.getString("COLUMN_NAME");
                    String columnType = columns.getString("TYPE_NAME");
                    int columnSize = columns.getInt("COLUMN_SIZE");
                    System.out.println("列名: " + columnName);
                    System.out.println("数据类型: " + columnType);
                    System.out.println("列大小: " + columnSize);
                }

                System.out.println();
                columns.close();
            }

            tables.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}