多条件分页查询

条件类

package com.atguigu.springboot.vo;


import lombok.Data;

@Data
public class CompanyCondition {
    private Integer id;
    /**
     * 单位名称
     */
    private String companyName;
    /**
     * 社会信用代码
     */
    private String socialCode;

    /**
     * 审核状态（0未审核，1审核中，2审核通过，3审核拒绝）
     */
    private Integer isPublish;

    /**
     * 注册资金（两个文本框数据区间查询）
     * 最低注册资金
     */
    private Double registeredCapitalLow;

    /**
     * 最高注册资金
     */
    private Double registeredCapitalHigh;

    /**
     * 企业类型
     */
    private String character;

    /**
     * 联系人
     */
    private String contacts;

    /**
     * 联系电话
     */
    private String contactPhone;

}

controller层

 @ApiOperation(value = "根据组合条件查询企业信息", notes = "根据组合条件查询企业信息")
    @PostMapping("/list/condition/{page}/{size}")
    public ResponseBean getAdminInfoByCondition(@PathVariable("page") Integer page,
                                                @PathVariable("size") Integer size,
                                                @RequestBody CompanyCondition companyCondition) {
            Page<Company> companyPage = companyService.selectZuHe(new Page<>(page, size), companyCondition);
            return new ResponseBean(true,companyPage,ResponseEnums.SUCCESS_OPTION);
    }

service层

public interface CompanyService extends IService<Company> {

    Page<Company> selectZuHe(Page<Company> page, CompanyCondition companyCondition);

}

impl层

@Service
public class CompanyServiceImpl extends ServiceImpl<CompanyMapper, Company> implements CompanyService {

    @Override
    public Page<Company> selectZuHe(Page<Company> page, CompanyCondition companyCondition) {
        return page.setRecords(this.baseMapper.selectZuHe(page, companyCondition));
    }
}

mapper层

package com.atguigu.springboot.mapper;

import com.atguigu.springboot.entities.Company;
import com.atguigu.springboot.vo.CompanyCondition;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.baomidou.mybatisplus.plugins.Page;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author gaobin
 * @since 2022-10-31
 */
public interface CompanyMapper extends BaseMapper<Company> {

    @Select("<script>" +
            "select * from company" +
            " where  1=1 and isPublish != 0" +
            " <if test='companyName != null and companyName.trim() != &quot;&quot;'>" +
            " AND companyName LIKE '%'+#{companyName}+'%'" +
            " </if>" +
            " <if test='socialCode != null and socialCode.trim() != &quot;&quot;'>" +
            " AND socialCode LIKE '%'+#{socialCode}+'%'" +
            " </if>"+
            " <if test='id != null '>" +
            " AND id=#{id} " +
            " </if>" +
            " <if test='isPublish != null '>" +
            " AND isPublish=#{isPublish} " +
            " </if>" +

            " <if test='registeredCapitalLow != null'>" +
            " AND registeredCapital &gt;=#{registeredCapitalLow}" +
            " </if>"+

            " <if test='registeredCapitalHigh != null'>" +
            " AND registeredCapital &lt;=#{registeredCapitalHigh}" +
            " </if>"+

            " <if test='character != null'>" +
            " AND character=#{character}" +
            " </if>"+


            " <if test='contacts != null and contacts.trim() != &quot;&quot;'>" +
            " AND contacts LIKE '%'+#{contacts}+'%'" +
            " </if>"+

            " <if test='contactPhone != null and contactPhone.trim() != &quot;&quot;'>" +
            " AND contactPhone =#{contactPhone}+'%'" +
            " </if>"+

            " ORDER BY" +
            " addTime DESC" +
            "</script>")
    List<Company> selectZuHe(Page<Company> page, CompanyCondition companyCondition);

}