十一月 19, 2018 2:35:42 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [springMVC] in context with path [/mrl] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.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,20' at line 2
### The error may exist in file [E:\project\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\mrl\WEB-INF\classes\com\core\mappers\ProductMapper.xml]
### The error may involve com.core.dao.IProductDao.findProducts-Inline
### The error occurred while setting parameters
### SQL: select * from mrl_product WHERE companyName like ?, limit ?,?
### Cause: com.mysql.jdbc.exceptions.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,20' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.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,20' at line 2] with root cause
com.mysql.jdbc.exceptions.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 '
最终的解决问题的方法是将companyName后面的逗号删除。