使用JDBC获取数据库表的信息

pom.xml引入jdbc依赖

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.22</version>
</dependency>

Java类GetTableInfo

package cn.code;

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

public class GetTableInfo {
    //输出表名
    public static void printTableNames(DatabaseMetaData databaseMetaData)throws Exception{
        //获取表名的结果集
        ResultSet rs = databaseMetaData.getTables(null, null, null, new String[]{"TABLE"});
        while(rs.next()){
            String tableName = rs.getString("TABLE_NAME");
            System.out.println(tableName);
        }
    }

    //输出列名、类型、注释
    public static void printColumnInfo(DatabaseMetaData databaseMetaData)throws Exception{
        ResultSet rs = databaseMetaData.getColumns(null, "%", "student", "%");
        while(rs.next()){
            //列名
            String columnName = rs.getString("COLUMN_NAME");
            //类型
            String typeName = rs.getString("TYPE_NAME");
            //注释
            String remarks = rs.getString("REMARKS");
            System.out.println(columnName + "--" + typeName + "--" + remarks);
        }
    }

    public static void main(String[] args) throws Exception{
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://192.168.126.133:3306/itrip";
        String user = "root";
        String password = "123456";
        Connection connection = DriverManager.getConnection(url, user, password);
        DatabaseMetaData databaseMetaData = connection.getMetaData();
        //printTableNames(databaseMetaData);
        printColumnInfo(databaseMetaData);
    }
}