mybatis-plus自定义分页案例

最新推荐文章于 2025-03-13 18:47:56 发布

夏木炎

最新推荐文章于 2025-03-13 18:47:56 发布

阅读量210

点赞数

文章标签： mybatis java 开发语言

本文链接：https://blog.youkuaiyun.com/xm393392625/article/details/130066242

版权

一、案例代码：

1）、mapper

public interface CalPatientSettlementMapper extends BaseMapper<CalPatientSettlementDo> {

    /**
     * 分页查询在院患者带模拟统计结果信息
     * @param page 分页
     * @param queryWrapper 入参
     * @return List
     */
    @Select("SELECT i.*,c.* FROM `col_inpatient` i LEFT JOIN `cal_patient_settlement` c ON i.ordinal_no=c.ordinal_no ${ew.customSqlSegment}")
    List<InpatientWithCalPatientSettlementDto> findInpatientWithCalPatientSettlement(
            Page<InpatientWithCalPatientSettlementDto> page,
            @Param(Constants.WRAPPER) Wrapper<InpatientWithCalPatientSettlementDto> queryWrapper);
}

2）、service

@Service
public class CalPatientSettlementService {

    @Autowired
    CalPatientSettlementMapper calPatientSettlementMapper;


    public Page<InpatientWithCalPatientSettlementDto> findInpatientWithCalPatientSettlement(
            CalPatientSettlementWithPage calPatientSettlementWithPage){
        Page<InpatientWithCalPatientSettlementDto> page=new Page<>(calPatientSettlementWithPage.getPageNo(),calPatientSettlementWithPage.getPageSize());
        QueryWrapper<InpatientWithCalPatientSettlementDto> wrapper = new QueryWrapper<>();
        if(StringUtils.isNotBlank(calPatientSettlementWithPage.getPatientName())){
            wrapper.like("patient_name",calPatientSettlementWithPage.getPatientName());
        }
        return page.setRecords(calPatientSettlementMapper.findInpatientWithCalPatientSettlement(page,wrapper));
    }


}

二、测试