java判断数据库表是否存在，否则创建

public void createCustUnicomTable(Statement stm,StringBuilder builder,String tableName){
try {
String sqlTab ="select TABLE_NAME from information_schema.TABLES where table_schema ='test' and table_name = '"+tableName+"'";
ResultSet being = stm.executeQuery(sqlTab);
if(being.next()){
stm.execute(builder.deleteCharAt(builder.length() - 1).append(";").toString());
}else{
//创建联通客户表
String createTab = "CREATE TABLE `"+tableName+"` "
+ "(`cid` int(11) NOT NULL AUTO_INCREMENT,"
+ "`cust_id` int(11) NOT NULL COMMENT '与客户表关联字段',"
+ "`activity_id` varchar(64) DEFAULT NULL COMMENT '活动id',"
+ "`customer_id` varchar(64) DEFAULT NULL COMMENT '客户id',"
+ "`provide_id` varchar(64) DEFAULT NULL COMMENT '省份id',"
+ " PRIMARY KEY (`cid`)) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8";
stm.execute(createTab);
stm.execute(builder.deleteCharAt(builder.length() - 1).append(";").toString());
}
} catch (SQLException e) {
e.printStackTrace();
}

}