com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception，jdbc4.0

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception，jdbc4.0

1、錯誤描述

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxError Exception：You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 'notnull,user_name varchar(255) )' at line 1

2、錯誤原因

StringBuilder sql = new StringBuilder();sql.append("create table t_you_su_ta(");sql.append(" id int primary key,");sql.append(" user_id int notnull,");sql.append(" user_name varchar(255))");

在拼接建立資料庫表時，要使user_id不為空白，定義成了“notnull”

3、解決辦法

   在拼接user_id時，應改成“user_id int not null”