java 获取数据库所有表结构

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.Statement;import java.util.ArrayList;import java.util.List;public class Test {private Connection connection;private Statement statement;public static void main(String[] args) throws Exception{Test test=new Test();test.initConnection("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://192.168.0.1:1433;databaseName=database","sa","root");StringBuffer sb = new StringBuffer();ResultSet resultSet=test.getMetaDataTables();List<String> list=new ArrayList<>();while(resultSet.next()){list.add(resultSet.getString("name"));}for(int i=0;i<list.size();i++){System.out.println("\n"+"table:"+list.get(0)+"\n");test.displayMetaData(test.getMetaDataFromTable("sys_user"));} }public void initConnection(String driverClass, String dbUrl, String username, String password) throws Exception {Class.forName(driverClass);this.connection = DriverManager.getConnection(dbUrl, username, password);this.statement = this.connection.createStatement();}public ResultSet getMetaDataTables() throws Exception {String sql = "select name from sysobjects where xtype='U' ";ResultSet rs = this.statement.executeQuery(sql);return rs;}public ResultSetMetaData getMetaDataFromTable(String tableName) throws Exception {String sql = "SELECT * FROM " + tableName.toUpperCase() + " WHERE 1 != 1";ResultSet rs = this.statement.executeQuery(sql);return rs.getMetaData();}public void displayMetaData(ResultSetMetaData metaData) throws Exception {StringBuffer sb = new StringBuffer();for (int i = 0; i < metaData.getColumnCount(); i++) {sb.append("\n");sb.append(metaData.getTableName(i + 1));sb.append(".");sb.append(metaData.getColumnName(i + 1));sb.append("|");sb.append(metaData.getColumnType(i + 1));sb.append("|");sb.append(metaData.getColumnTypeName(i + 1));sb.append("|");sb.append(metaData.getColumnDisplaySize(i + 1));sb.append("|");}System.out.println(sb.toString());}

}