根据数据库的四大参数获取指定库中的所有表
//根据数据库的参数获取指定库中的所有表
public static List<Map<String, String>> getDbTables(String driver, String url, String user, String pwd) {
Connection conn = null;
ResultSet rs = null;
List<Map<String, String>> tables = new ArrayList<>();
try {
conn = getConnections(driver, url, user, pwd);
DatabaseMetaData dbMetaData = conn.getMetaData();
rs = dbMetaData.getTables(null, getSchema(conn), null, new String[]{"TABLE"});
while (rs.next()) {
Map<String, String> map = new HashMap<>(1 << 3);
//获取数据库的表名
map.put("tableNam", rs.getString("TABLE_NAME"));
//获取数据库的表类型
map.put("tableType", rs.getString("TABLE_TYPE"));
// 所属数据库
map.put("tableCat", rs.getString("TABLE_CAT"));
// 所属用户
map.put("tableSchem", rs.getString("TABLE_SCHEM"));
map.put("tableRemarks", rs.getString("REMARKS"));
tables.add(map);
}
} catch (Exception e) {
LoggerUtil.error(String.valueOf(RetCode.DB_CONN_ERROR), Utils.getSt