2020-10-15 12:03:02.909 ERROR 28056 --- [nio-8000-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is 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 20' at line 6
### The error may exist in file [G:\Git\xf\service-xf\target\classes\com\lm\anga\platform\anslip\dao\xml\AnSlip.map.xml]
### The error may involve com.lm.anga.platform.anslip.dao.mapper.AnSlipMapper.getLastData-Inline
### The error occurred while setting parameters
### SQL: SELECT id_,station_id_,collect_time_,an_slip_ FROM dt_an_slip_data WHERE station_id_=? order by collect_time_ desc limit 1 LIM
PageHelperi分页与limit1冲突的解决办法
最新推荐文章于 2024-07-29 12:01:34 发布
本文介绍了在使用Mybatis的PageHelper插件时遇到的与limit分页冲突问题,分析了问题原因,并提供了解决方案,即确保特定代码放置在方法的合适位置。
摘要由CSDN通过智能技术生成