java获取数据库表名的原理就是通过connection获取数据库元数据DatabaseMetaData,然后通过元数据的getTables()方法查出表信息
-
Connection conn = ConnectionPool.getConnection();
-
try {
-
DatabaseMetaData dbm = conn.getMetaData();
-
ResultSet rs = dbm.getTables(null, null, "%o%", null);//通配符获取表名称中所有含有字符o的表
-
while(rs.next()){
-
System.out.println(rs.getString(3)); //打印表名
-
}
-
} catch (SQLException e) {
-
e.printStackTrace();
-
}