Mr_老大爷 2016-06-16 10:50 采纳率: 33.3%
浏览 1872

SpringMVC的sql语句问题

图片说明
这个插入语句有问题吗?急求
报下面这个错

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '' at line 3

The error may involve com.tms.util.mapper.DictMapper.insertModule-Inline

The error occurred while setting parameters

SQL: insert into WX_DICT_MODULE values

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '' at line 3

]
18:39:34.377 [http-bio-8080-exec-6] DEBUG o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Resolving exception from handler [public boolean com.tms.util.action.DictAction.saveModule(com.tms.util.bo.ModuleBo)]: org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '' at line 3

The error may involve com.tms.util.mapper.DictMapper.insertModule-Inline

The error occurred while setting parameters

SQL: insert into WX_DICT_MODULE values

  • 写回答

1条回答

  • lzj0327 2016-06-16 11:08
    关注
     看看传过来的参数有没有问题
    
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 LiBeAs的带隙等于0.997eV,计算阴离子的N和P
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 来真人,不要ai!matlab有关常微分方程的问题求解决,
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误
  • ¥199 rust编程架构设计的方案 有偿
  • ¥15 回答4f系统的像差计算