注册

求助!使用sharding分片同时mybatisPlus的分页查询报错问题

我伈依舊 2025/12/02 196 0

【DM版本】: V8
【操作系统】:win10
【问题描述】*:springboot ,mybatis 框架, 在使用shading分片同时分页查询的时候查询报错 ```nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax

【代码如下】:
if (StringUtils.isNotBlank(attendanceMonth)){
smzAttendance.setAttendanceMonth(attendanceMonth);
}else{
smzAttendance.setAttendanceMonth(DateUtils.formatDate(new Date(),"yyyy-MM"));
}

QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(smzAttendance, req.getParameterMap());

Page page = new Page(pageNo, pageSize);

queryWrapper.orderByDesc("create_time");

IPage pageList = smzAttendanceService.pageSensitive(page, queryWrapper);

查询语句是苞米豆自带的,请问如何不手动重写查询方法,实现分页查询呢?

回答 0
暂无回答
扫一扫
联系客服