package jfir.smtiger.test;
import java.sql. Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql. ResultSet;
public class GetDBTablesInfo {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
Class.forName( "com.mysql.jdbc.Driver" );
String url = "jdbc:mysql://localhost:3306/test?user=root&password=123456" ;
Connection conn = DriverManager.getConnection(url);
DatabaseMetaData databaseMetaData = conn.getMetaData();
// 获取所有表
ResultSet tableSet = databaseMetaData.getTables(null, "%" , "%" ,
new String[] { "TABLE" });
while (tableSet.next()) {
String tableName = tableSet.getString( "TABLE_NAME" );
String tableComment = tableSet.getString( "REMARKS" );
System.out.println( "tableName=" + tableName);
System.out.println( "tableComment=" + tableComment);
// 获取tableName表列信息
ResultSet columnSet = databaseMetaData.getColumns(null, "%" ,
tableName, "%" );
while (columnSet.next()) {
String columnName = columnSet.getString( "COLUMN_NAME" );
String columnComment = columnSet.getString( "REMARKS" );
String sqlType = columnSet.getString( "DATA_TYPE" );
System.out.println(columnName);
System.out.println(columnComment);
System.out.println(sqlType);
}
}
}
}
import java.sql. Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql. ResultSet;
public class GetDBTablesInfo {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
Class.forName( "com.mysql.jdbc.Driver" );
String url = "jdbc:mysql://localhost:3306/test?user=root&password=123456" ;
Connection conn = DriverManager.getConnection(url);
DatabaseMetaData databaseMetaData = conn.getMetaData();
// 获取所有表
ResultSet tableSet = databaseMetaData.getTables(null, "%" , "%" ,
new String[] { "TABLE" });
while (tableSet.next()) {
String tableName = tableSet.getString( "TABLE_NAME" );
String tableComment = tableSet.getString( "REMARKS" );
System.out.println( "tableName=" + tableName);
System.out.println( "tableComment=" + tableComment);
// 获取tableName表列信息
ResultSet columnSet = databaseMetaData.getColumns(null, "%" ,
tableName, "%" );
while (columnSet.next()) {
String columnName = columnSet.getString( "COLUMN_NAME" );
String columnComment = columnSet.getString( "REMARKS" );
String sqlType = columnSet.getString( "DATA_TYPE" );
System.out.println(columnName);
System.out.println(columnComment);
System.out.println(sqlType);
}
}
}
}