/**
* 根据表名,判断数据库表是否存在<br>
* @param tableName
* @return true or false
*/
public boolean HasTable(String tableName) {
//判断某一个表是否存在
boolean result = false;
try {
//Connection conn = getYourConnection();
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/test?
useUnicode=true&characterEncoding=utf8", "root", "test");
DatabaseMetaData meta = (DatabaseMetaData) conn.getMetaData();
ResultSet set = meta.getTables (null, null, tableName, null);
while (set.next()) {
result = true;
}
} catch (Exception eHasTable) {
System.err.println(eHasTable);
eHasTable.printStackTrace ();
}
System.out.println("###result:=="+result);
return result;
}
* 根据表名,判断数据库表是否存在<br>
* @param tableName
* @return true or false
*/
public boolean HasTable(String tableName) {
//判断某一个表是否存在
boolean result = false;
try {
//Connection conn = getYourConnection();
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/test?
useUnicode=true&characterEncoding=utf8", "root", "test");
DatabaseMetaData meta = (DatabaseMetaData) conn.getMetaData();
ResultSet set = meta.getTables (null, null, tableName, null);
while (set.next()) {
result = true;
}
} catch (Exception eHasTable) {
System.err.println(eHasTable);
eHasTable.printStackTrace ();
}
System.out.println("###result:=="+result);
return result;
}