java怎么获取mysql表注释-编程学习网

这篇文章将为大家详细讲解有关java怎么获取mysql表注释，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

MySQL 表注释获取

方法 1：JDBC 元数据

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

public class GetTableCommentsJDBC {

    public static void main(String[] args) throws SQLException {
        // Establish a connection to the database
        Connection connection = ...;

        // Get the database metadata
        DatabaseMetaData metadata = connection.getMetaData();

        // Get the table metadata
        ResultSet resultSet = metadata.getTables(null, null, "%", new String[] {"TABLE"});

        // Iterate over the results
        while (resultSet.next()) {
            // Get the table name
            String tableName = resultSet.getString("TABLE_NAME");

            // Get the table comment
            String tableComment = resultSet.getString("REMARKS");

            // Print the table name and comment
            System.out.println(String.format("Table: %s, Comment: %s", tableName, tableComment));
        }

        // Close the result set and connection
        resultSet.close();
        connection.close();
    }
}

方法 2：SQL 查询

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GetTableCommentsSQL {

    public static void main(String[] args) throws SQLException {
        // Establish a connection to the database
        Connection connection = ...;

        // Create a statement
        Statement statement = connection.createStatement();

        // Execute the SQL query to get the table comments
        ResultSet resultSet = statement.executeQuery("SELECT TABLE_NAME, TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = "<database_name>"");

        // Iterate over the results
        while (resultSet.next()) {
            // Get the table name
            String tableName = resultSet.getString("TABLE_NAME");

            // Get the table comment
            String tableComment = resultSet.getString("TABLE_COMMENT");

            // Print the table name and comment
            System.out.println(String.format("Table: %s, Comment: %s", tableName, tableComment));
        }

        // Close the result set, statement, and connection
        resultSet.close();
        statement.close();
        connection.close();
    }
}

注意事项：