//获取数据表名
public List<String> getDataTableName(String database) {
Connection connection = getConnection();
List<String> list = new ArrayList<>();
try {
DatabaseMetaData databaseMetaData = connection.getMetaData();
ResultSet resultSet = databaseMetaData.getTables(database,"root","%",new String[]{"TABLE"});
while (resultSet.next()){
list.add(resultSet.getString("TABLE_NAME"));
}
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
参考文章:
查询避免Unknown column ‘xxx’ in ‘where clause’
ResultSet getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
throws SQLException
catalog指的是数据库
schemaPattern是数据库的用户
tableNamePattern是表名
types指的是table、view等