springboot整合myBatis踩的坑

springboot整合myBatis踩的坑

最近想做一个spring boot整合mybatis的demo，遇到这么一个坑爹的问题，排查了小半天，结果就是因为一个空格。哎~~蛋疼得很。看代码吧。

以下是正确的代码：

<select id="findByNameAndPassword" resultType="int">
    select COUNT(*) FROM users WHERE username = #{username} AND password = #{password}
</select>

那么错误的代码来了：

<select id="findByNameAndPassword" resultType="int">
    select COUNT (*) FROM users WHERE username = #{username} AND password = #{password}
</select>
`

报错信息：

### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select COUNT (*) FROM users WHERE username = ? AND password = ?
### Cause: java.sql.SQLSyntaxErrorException: 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 '*) FROM users WHERE username = 'lY' AND password = 'lyp'' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 '*) FROM users WHERE username = 'lY' AND password = 'lyp'' at line 1] with root cause

个人总结：啥原因我现在也不是很清楚，上网找了资料看的似懂非懂。只能说下次注意吧。你问我怎么找到的这个错误？？？将控制台上的sql语句复制到navicat上运行，也出错。于是就在navicat中修改了一下sql语句。运行成功之后逐字对照。看了N遍，卧槽~~这特么多个空格！！！脑壳痛。