如何使用java获得mysql表和列的注释？

String url = "jdbc:mysql://localhost:3306/your_database_name";
String username = "your_username";
String password = "your_password";

Connection connection = DriverManager.getConnection(url, username, password);

DatabaseMetaData metaData = connection.getMetaData();
ResultSet tables = metaData.getTables(null, null, null, new String[]{"TABLE"});

while (tables.next()) {
    String tableName = tables.getString("TABLE_NAME");
    String tableComment = tables.getString("REMARKS");
    
    System.out.println("表名：" + tableName);
    System.out.println("表注释：" + tableComment);
    
    ResultSet columns = metaData.getColumns(null, null, tableName, null);
    
    while (columns.next()) {
        String columnName = columns.getString("COLUMN_NAME");
        String columnComment = columns.getString("REMARKS");
        
        System.out.println("列名：" + columnName);
        System.out.println("列注释：" + columnComment);
    }
    
    columns.close();
}

tables.close();

connection.close();