因为,mysql驱动好像不支持将创建表的语句写在一行内,所以会报错。
这样写在String,后面预编译不能通过,直接报出Unknow database
CREATE TABLE tt (id INT AUTO_INCREMENT,word VARCHAR(100),translation VARCHAR(100),eg VARCHAR(1000),egTranslation VARCHAR(2000),PRIMARY KEY (id))
这样子就不会出错了
String sql = "CREATE TABLE ? (" +
"id INT AUTO_INCREMENT," +
"word VARCHAR(100)," +
"translation VARCHAR(100)," +
"eg VARCHAR(1000)," +
"egTranslation VARCHAR(2000)," +
"PRIMARY KEY (id))";