u014266400
Jstions
采纳率75%
2018-05-15 01:15 阅读 818
已采纳

网页报错显示应用程序异常

5

org.springframework.jdbc.BadSqlGrammarException:

Error querying 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 ''S NAME,

PRODUCT CLASS NAME,
GUARANTEE METHOD,
LOAN AMOUNT,
LOAN TE' at line 3

The error may exist in file [D:\tomcat\apache-tomcat-7.0.57\webapps\FHADMINM\WEB-INF\classes\mybatis1\information\InterestMapper.xml]

The error may involve InterestMapper.datalistPage-Inline

The error occurred while setting parameters

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 ''S NAME,

PRODUCT CLASS NAME,
GUARANTEE METHOD,
LOAN AMOUNT,
LOAN TE' at line 3
; bad SQL grammar []; nested exception is 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 ''S NAME,
PRODUCT CLASS NAME,
GUARANTEE METHOD,
LOAN AMOUNT,
LOAN TE' at line 3

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

8条回答 默认 最新

  • 已采纳
    xyt3198 xyt3198 2018-05-15 01:48

    PRODUCT CLASS NAME
    这里错了,应该写成:
    PRODUCT "CLASS NAME"
    用双引号包住

    点赞 评论 复制链接分享
  • weixin_42033836 Emotional_沐瑾 2018-05-15 01:19

    检查tomcat是否有问题。。

    点赞 评论 复制链接分享
  • qq418814 qq418814 2018-05-15 01:23

    mysql数据库版本是不是跟配置不匹配

    点赞 评论 复制链接分享
  • min7797 骑单车de小岳岳 2018-05-15 01:29

    可以检查看看你sql语法有没错误

    点赞 评论 复制链接分享
  • qq_27848369 hot2dog 2018-05-15 01:39

    很清楚了, mybatis1\information\InterestMapper.xml 文件报错,

    S NAME,
    PRODUCT CLASS NAME,
    GUARANTEE METHOD,
    LOAN AMOUNT,
    LOAN TE' at line 3

    PRODUCT CLASS NAME, 这个是不是 要取个别名? 好像不对,,, 多检查检查这个 文件 :InterestMapper.xml

    点赞 评论 复制链接分享
  • Jonny_qian Jonny_qian 2018-05-15 02:00

    Mapper文件是不是自动生成的那种,如果不是,还是仔细查看对比一下吧

    点赞 评论 复制链接分享
  • weixin_42176653 weixin_42176653 2018-05-15 03:39

    框架映射不到mapper

    点赞 评论 复制链接分享
  • weixin_41534620 小炸鸡 2018-05-16 09:00

    js(Java script)脚本可能没有被完全用到

    点赞 评论 复制链接分享

相关推荐