public void addAppVisit(String appVisitDate) { Connection conn = null; String tableName = "appVisit" + appVisitDate; try { conn = getHibernateTemplate().getSessionFactory() .getCurrentSession().connection(); DatabaseMetaData metaDate = conn.getMetaData(); ResultSet rs = metaDate.getTables(null, null, tableName, new String[] { "TABLE" }); if (rs.next()) { System.out.println(tableName + ": 表存在! "); } else { String sql ="CREATE TABLE `"+ tableName +"` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `appId` BIGINT(20) DEFAULT NULL, `userAttr` VARCHAR(255) DEFAULT NULL, `userCA` VARCHAR(255) DEFAULT NULL, `userIP` VARCHAR(255) DEFAULT NULL, `userMAC` VARCHAR(255) DEFAULT NULL, `visitDate` VARCHAR(255) DEFAULT NULL, `visitSource` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=INNODB DEFAULT CHARSET=utf8;"; conn.prepareStatement(sql).execute(); } } catch (Exception e) { e.printStackTrace(); } }
转载请注明原文地址: https://www.6miu.com/read-850278.html