corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

新手学习SSM框架利用分页插件实现分页的时候出现了一个问题

错误信息：

Exception in thread "main" 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 1' at line 1
### The error may exist in file [D:\IDEAStudy\Maven\SSM-SpringMVc\target\classes\Mapper\UserMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from ssm.user; LIMIT 1
### 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 1' at line 1
; 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 1' at line 1

主要还是看到：

 SQL: select * from ssm.user; LIMIT 1

然后就去查看了mapper对应的映射文件，果然在自己的查询所有用户的时候sql语句出现了分号结尾。

解决方案: 查询所有的时候去掉分号

运行结果: 查询出来了。敲代码还是要细心一点的