如何获取mysql表列数据_Java 获取Mysql数据库表的列

public class GetTableSchema {

private static final String DRIVER = "com.mysql.jdbc.Driver";

private static final String URL = "jdbc:mysql://localhost:3306/loctest";

private static final String USERNAME = "root";

private static final String PASSWORD = "***";

public static void main(String[] args) throws Exception {

Class.forName(DRIVER);

Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

DatabaseMetaData metadata = connection.getMetaData();

ResultSet resultSet = metadata.getColumns(null, null, "loctest.user", null);

while (resultSet.next()) {

String name = resultSet.getString("COLUMN_NAME");

String type = resultSet.getString("TYPE_NAME");

int size = resultSet.getInt("COLUMN_SIZE");

System.out.println("Column name: [" + name + "]; type: [" + type + "]; size: [" + size + "]");

}

connection.close();

}

}