Com.mysql.exceptions_Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException最全解决

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 'LIMIT 0,10' at line 21

### The error may exist in cn/edu/sdju/yyh/dao/LinkmanDao.xml

### The error may involve cn.edu.sdju.yyh.dao.LinkmanDao.selectLinkmanList-Inline

### The error occurred while setting parameters

### SQL: SELECT lkm_id, lkm_name, lkm_cust_id, lkm_gender, lkm_phone, lkm_mobile, lkm_email, lkm_qq, lkm_position, lkm_memo FROM linkman l /*多条件查询*/ WHERE /*所属客户*/ LIMIT ?,?

### 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 'LIMIT 0,10' at line 21

; 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 'LIMIT 0,10' at line 21

用ssm框架做毕设——————————————上面是我的报错

这个报错困扰了我整整一天半，难受啊马飞~

下面是我的mapper.xml:

lkm_name like "%"#{lkm_name}"%"

and lkm_gender = #{lkm_gender}

/*所属客户*/

and lkm_cust_id = #{lkm_cust_id}

resultType="linkman">

SELECT

lkm_id,

lkm_name,

lkm_cust_id,

lkm_gender,

lkm_phone,

lkm_mobile,

lkm_email,

lkm_qq,

lkm_position,

lkm_memo

FROM

linkman l

/*多条件查询*/

LIMIT #{start_index},#{rows}

我知道你肯定不耐烦了，哈哈~~~

这个错误，大部分人肯定是字段用了mysql的关键字导致的。

而我的问题就有丶秀了，因为爱写注释的好习惯，但我把注释写到了标签里面去了，还是/*   */这种形式(用的ctrl+shift+/快捷键)

这会导致什么结果呢：无论你中的条件是否成立，mybatis都会给你拼接一个where

只要去掉注释就OK了，或者改用注释。