首页 > 代码库 > SQL关键字与数据库字段冲突产生的错误!

SQL关键字与数据库字段冲突产生的错误!

Caused by: java.sql.SQLException: 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 ‘group)values(0,600,‘1‘,null,‘è‰??·???€???‘,‘2014-06-07~~2014-08-09‘,‘???????????‘ at line 1 Query: insert into project (ptotalpeo,pnumpeo,pstate,nlist,pname,betime,paddress,sche,group)values(?,?,?,?,?,?,?,?,?) Parameters: [0, 600, 1, null, 艺淘一班, 2014-06-07~~2014-08-09, 温图二楼301室, 每周一:早上三节课,下午二节课, 2014-06-07~~2014-08-09]
 at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
 at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:455)
 at com.zjartedu.admin.AdminDao.createsignup(AdminDao.java:161)