java获取表的列名和备注信息
代码如下
package cn.gwc.jdbc.mysql;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import cn.gwc.jdbc.util.MetaUtil;
public class MetaTest {
public static void main(String[] args) throws Exception {
Connection conn = getConnection();
MetaUtil.getColumnRemark(conn,"USERDEMO",conn.getCatalog(),conn.getSchema());
conn.close();
System.out.println(conn.isClosed());
}
public static List<String> getColumnRemark(Connection conn,String tableName,String catalog,String schema) {
System.out.println("catalog "+catalog+" schema: "+schema);
List<String> pkList=new ArrayList<>();
DatabaseMetaData metaData;
try {
metaData = conn.getMetaData();
ResultSet rs=metaData.getColumns(catalog, schema, tableName, "%");
while (rs.next()) {
String columnName = rs.getString("COLUMN_NAME");
String remarks = rs.getString("REMARKS");
System.out.println("columnName "+columnName + " "+remarks);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return pkList;
}
public static Connection getConnection() throws Exception {
final String url = "jdbc:mysql://127.0.0.1:3306/testdb?serverTimezone=GMT%2B8&useSSL=false&characterEncoding=utf8&allowMutiQueries=true";
final String name = "com.mysql.jdbc.Driver";
final String user = "root";
final String password = "root";
Connection conn = null;
Class.forName(name);//指定连接类型
conn = DriverManager.getConnection(url, user, password);//获取连接
if (conn!=null) {
boolean auto=conn.getAutoCommit();
System.out.println("获取连接成功 auto:"+auto);
}else {
System.out.println("获取连接失败");
}
return conn;
}
}