List<JobPostings> list = jobPostingsMapper.selectPage(jobPostingsPage,wrapper);
时间: 2024-05-21 14:13:25 浏览: 15
这个问题属于技术问题,我可以回答。这是一个通过 Mybatis-plus 实现分页查询的代码。jobPostingsMapper是一个Mybatis-plus自动生成的mapper接口,selectPage方法是该接口提供的分页查询方法,传入了jobPostingsPage和wrapper两个参数。其中jobPostingsPage是一个Page对象,用于存储分页的相关信息,wrapper是一个LambdaQueryWrapper对象,用于封装查询条件。最终返回一个List类型的结果集。
相关问题
@Override public Page<SysUserPolicyEntity> selectInsured(GrpnameForm data, int current, int pageSize) { //查询 String employeeNo = data.getEmployeeNo(); String grpname = data.getGrpname(); List<SysUserPolicyEntity> lcgrpcontVoPage = lcgrpcontMapper.selectInsured(grpname); LambdaQueryWrapper<SysUserPolicyEntity> wrapper = new LambdaQueryWrapper<>(); wrapper.eq(ObjectUtils.isNotEmpty(employeeNo), SysUserPolicyEntity::getEmployeeNo, employeeNo); List<SysUserPolicyEntity> sysUserPolicyEntityList = sysUserPolicyMapper.selectList(wrapper); for (SysUserPolicyEntity record : lcgrpcontVoPage) { for (SysUserPolicyEntity policyEntity : sysUserPolicyEntityList) { if (record.getGrpcontno().equals(policyEntity.getGrpcontno())) { record.setSelectFlag(policyEntity.getSelectFlag()); } } } sysUserPolicyMapper.delete(wrapper); Page<SysUserPolicyEntity> objectPage = new Page<>(); objectPage.setRecords(lcgrpcontVoPage); objectPage.setCurrent(current); objectPage.setSize(pageSize); objectPage.setTotal(lcgrpcontVoPage.size()); return objectPage; }按照分页放入数据
可以使用PageHelper插件来实现分页,具体代码如下:
```
@Override
public Page<SysUserPolicyEntity> selectInsured(GrpnameForm data, int current, int pageSize) {
//查询
String employeeNo = data.getEmployeeNo();
String grpname = data.getGrpname();
List<SysUserPolicyEntity> lcgrpcontVoPage = lcgrpcontMapper.selectInsured(grpname);
LambdaQueryWrapper<SysUserPolicyEntity> wrapper = new LambdaQueryWrapper<>();
wrapper.eq(ObjectUtils.isNotEmpty(employeeNo), SysUserPolicyEntity::getEmployeeNo, employeeNo);
List<SysUserPolicyEntity> sysUserPolicyEntityList = sysUserPolicyMapper.selectList(wrapper);
for (SysUserPolicyEntity record : lcgrpcontVoPage) {
for (SysUserPolicyEntity policyEntity : sysUserPolicyEntityList) {
if (record.getGrpcontno().equals(policyEntity.getGrpcontno())) {
record.setSelectFlag(policyEntity.getSelectFlag());
}
}
}
sysUserPolicyMapper.delete(wrapper);
//使用PageHelper插件进行分页
PageHelper.startPage(current, pageSize);
List<SysUserPolicyEntity> list = new ArrayList<>(lcgrpcontVoPage);
PageInfo<SysUserPolicyEntity> pageInfo = new PageInfo<>(list);
return pageInfo;
}
```
其中,PageHelper.startPage(current, pageSize)表示开始分页,current表示当前页码,pageSize表示每页显示的数量。PageInfo<SysUserPolicyEntity> pageInfo = new PageInfo<>(list)表示将分页后的数据封装到PageInfo对象中。最后返回pageInfo即可。
//查看飞手的飞行任务 public Ipage<BisFlyerVO> getBisFlyerListAll() { List<BisFlyer> bisFlyerList = bisFlyerMapper.selectList(null); List<BisFlyerVO> bisFlyerVOList = new ArrayList<>(); for (BisFlyer bisFlyer : bisFlyerList) { BisFlyerVO bisFlyerVO = new BisFlyerVO(); BeanUtils.copyProperties(bisFlyer, bisFlyerVO); DatSite datSite = datSiteMapper.selectById(bisFlyer.getSiteId()); if (datSite != null) { bisFlyerVO.setStieName(datSite.getSiteName()); } QueryWrapper<BisTask> bisTaskQueryWrapper = new QueryWrapper<>(); bisTaskQueryWrapper.eq("flyer_id", bisFlyer.getId()).eq("task_status", 2); int taskCount = bisTaskMapper.selectCount(bisTaskQueryWrapper); bisFlyerVO.setTaskStatus(String.valueOf(taskCount)); QueryWrapper<BisTask> bisTaskQueryWrapper2 = new QueryWrapper<>(); bisTaskQueryWrapper2.eq("flyer_id", bisFlyer.getId()).eq("task_status", 8) .ge("create_time", LocalDate.now().withDayOfMonth(1)).le("create_time", LocalDate.now().withDayOfMonth(LocalDate.now().lengthOfMonth())); int flyNumber = bisTaskMapper.selectCount(bisTaskQueryWrapper2); bisFlyerVO.setThisMonthFlyNumber(flyNumber); bisFlyerVOList.add(bisFlyerVO); } return bisFlyerVOList; } 把这个方法加个分页,参数改成BisFlyerVO bisFlyerVO,BisFlyerVO继承了 分页VO类 @Data public class PageReqVO { @ApiModelProperty(value = "第几页") @TableField(exist = false) private int page=1; @ApiModelProperty(value = "分页数量") @TableField(exist = false) private int limit=10; }
好的,您的要求是在这个方法中加入分页功能,同时将方法返回类型改为IPage<BisFlyerVO>。可以按照以下步骤进行修改:
1. 在BisFlyerVO类中继承分页VO类PageReqVO:
```
@Data
public class BisFlyerVO extends PageReqVO {
// 其他属性
}
```
2. 在getBisFlyerListAll方法中使用Page对象进行分页,并将方法返回类型改为IPage<BisFlyerVO>:
```
public IPage<BisFlyerVO> getBisFlyerListAll(BisFlyerVO bisFlyerVO) {
Page<BisFlyer> bisFlyerPage = new Page<>(bisFlyerVO.getPage(), bisFlyerVO.getLimit());
bisFlyerMapper.selectPage(bisFlyerPage, null);
List<BisFlyer> bisFlyerList = bisFlyerPage.getRecords();
List<BisFlyerVO> bisFlyerVOList = new ArrayList<>();
for (BisFlyer bisFlyer : bisFlyerList) {
BisFlyerVO bisFlyerVO = new BisFlyerVO();
BeanUtils.copyProperties(bisFlyer, bisFlyerVO);
DatSite datSite = datSiteMapper.selectById(bisFlyer.getSiteId());
if (datSite != null) {
bisFlyerVO.setStieName(datSite.getSiteName());
}
QueryWrapper<BisTask> bisTaskQueryWrapper = new QueryWrapper<>();
bisTaskQueryWrapper.eq("flyer_id", bisFlyer.getId()).eq("task_status", 2);
int taskCount = bisTaskMapper.selectCount(bisTaskQueryWrapper);
bisFlyerVO.setTaskStatus(String.valueOf(taskCount));
QueryWrapper<BisTask> bisTaskQueryWrapper2 = new QueryWrapper<>();
bisTaskQueryWrapper2.eq("flyer_id", bisFlyer.getId()).eq("task_status", 8)
.ge("create_time", LocalDate.now().withDayOfMonth(1)).le("create_time", LocalDate.now().withDayOfMonth(LocalDate.now().lengthOfMonth()));
int flyNumber = bisTaskMapper.selectCount(bisTaskQueryWrapper2);
bisFlyerVO.setThisMonthFlyNumber(flyNumber);
bisFlyerVOList.add(bisFlyerVO);
}
return new PageImpl<>(bisFlyerVOList, bisFlyerPage, bisFlyerPage.getTotal());
}
```
3. 在调用getBisFlyerListAll方法时传入BisFlyerVO对象,其中的page和limit属性表示分页参数。
注意:如果您使用的是MyBatis Plus,可以直接在方法参数中添加Page对象,然后在查询中传入该Page对象即可完成分页操作。
相关推荐
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)