第3个回答 2018-07-17
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
//detec unknow tables by name
// TableName:tablename
public class Main {
public static void main(String[] argv) throws Exception {
Connection c = null; //db connection
DatabaseMetaData dbm = c.getMetaData();
ResultSet rs = dbm.getTables(null, null, "tablename", null);
if (rs.next()) {
System.out.println("Exists");
}
else {
System.out.println("Not Exist");
}
}
}