67,513
社区成员
发帖
与我相关
我的任务
分享
java.sql.Connection con = getYourConnection();
ResultSet rs = con.getMetaData().getTables(null, null, "yourTable", null );
if (rs.next()) {
//yourTable exist
}else {
//yourTable not exist
}
//name 表名
public boolean HasTable(String name) {
//判断某一个表是否存在
boolean result = false;
try {
DatabaseMetaData meta = sqlConn.getMetaData();//sqlConn 数据库连接
ResultSet set = meta.getTables (null, null, name, null);
while (set.next()) {
result = true;
}
} catch (Exception e) {
System.err.println(e);
e.printStackTrace ();
}
return result;
}
try
{
Statement stmt = connect.createStatement();
stmt.executeQuery( "select count(*) from yourTable ");
}
catch(SQLException e)
{
System.out.print( "not exits "+ e.getMessage());
}