转载文章:Java判断数据库表是否存在的方法 - Mr_nie - 博客园
方法1:
建立JDBC数据源,通过Java.sql.DatabaseMetaData接口来判断
public boolean isTableExistEntrust(String tableName) throws SQLException {
StringBuffer sb = new StringBuffer();
Connection conn = dataSource.getConnection();
DatabaseMetaData meta = conn.getMetaData();
ResultSet rs = meta.getTables(null, null, tableName, null);
boolean result = false;
try {
if (rs.next()) {
result = true;
} else {
sb = sb.append(tableName);
log.info(String.valueOf(sb));
}
}catch (Exception e) {
e.printStackTrace ();
}finally {
if(conn !=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return result;
}
方法2:
sql:select * from user_all_tables where table_name='tableName'
如果结果为空则表示不存在,如何结果不为空则表示存在;