mybtis-plus

呱呱程序猿

已于 2022-04-22 14:40:45 修改

阅读量230

点赞数

文章标签： eclipse java tomcat jar maven

于 2022-04-21 19:24:20 首次发布

本文链接：https://blog.csdn.net/qq_24012865/article/details/124329470

版权

mybatis-plus模糊查询以及排序

 @Override
    public IPage<MaBdcXZ> getBdcdjzlcxdxListByCxbh(String bdcdyh, String qlrmc, String zl, String bdcqzh, IPage<MaBdcXZ> page) {
        QueryWrapper<MaBdcXZ> queryWrapper = new QueryWrapper<>();
        queryWrapper.like(StringUtils.isNotBlank(bdcdyh), "bdcdyh", bdcdyh);
        queryWrapper.like(zl != null, "zl", zl);
        queryWrapper.like(qlrmc != null, "qlrmc", qlrmc);
        queryWrapper.like(bdcqzh != null, "bdcqzh", bdcqzh);
        queryWrapper.orderByDesc("xzsj");
        return this.baseMapper.selectPage(page, queryWrapper);
    }
2.

    @Override
    public List<MaDyaq> getAllMaDyaqByBdcdyh(String bdcdyh) {
        Assert.hasText(bdcdyh, "getAllMaDyaqByBdcdyh--bdcdyh不能为空");
        return this.baseMapper.selectList(Wrappers.lambdaQuery(MaDyaq.class).eq(MaDyaq::getBdcdyh, bdcdyh).ne(MaDyaq::getQszt, "3").orderByAsc(MaDyaq::getYwh));
    }