@Test
/**
* @Description: 创建表
*/
public void createUserTable() throws Exception {

    String sql = "CREATE TABLE `user` (\n" +
            "  `id` int(10) NOT NULL AUTO_INCREMENT,\n" +
            "  `username` varchar(100) DEFAULT NULL,\n" +
            "  `password` varchar(100) DEFAULT NULL,\n" +
            "  PRIMARY KEY (`id`)\n" +
            ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n" +
            "\n";
    jdbcTemplate.execute(sql);
}