SSM整合 - 多条件分页查询

多条件分页查询 - PageHelper

---

---

1. Maven配置插件

<!-- 分页插件 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>${pagehelper.version}</version>
</dependency>

2. 准备数据库信息

3. 准备实体类

• Drug.java

public class Drug {
   
    private Integer dr_id;

    private String dr_url;

    private Long dr_inPrice;

    private Long dr_outPrice;

    private String dr_name;

    private String dr_type;

    private String dr_simpleDesc;

    private String dr_expiration;

    private String dr_detaDesc;

    private String dr_factory;

    private String dr_direction;

    private String dr_remark;

    private Integer dr_number;

    private Integer dr_state;

    @Override
    public String toString() {
   
        return "Drug{" +
                "dr_id=" + dr_id +
                ", dr_url='" + dr_url + '\'' +
                ", dr_inPrice=" + dr_inPrice +
                ", dr_outPrice=" + dr_outPrice +
                ", dr_name='" + dr_name + '\'' +
                ", dr_type='" + dr_type + '\'' +
                ", dr_simpleDesc='" + dr_simpleDesc + '\'' +
                ", dr_expiration='" + dr_expiration + '\'' +
                ", dr_detaDesc='" + dr_detaDesc + '\'' +
                ", dr_factory='" + dr_factory + '\'' +
                ", dr_direction='" + dr_direction + '\'' +
                ", dr_remark='" + dr_remark + '\'' +
                ", dr_number=" + dr_number +
                ", dr_state=" + dr_state +
                '}';
    }

    // ------------- 此处省略Get / Set方法 -------------

4. 封装结果类

• ResultVo.java

/**
 * 返回结果的统一封装
 *
 * @author murphy
 * @since 2021/7/27 4:45 下午
 */
public class ResultVo<T> {
   
    /**
     * 返回的是分页对象
     */
    private PageInfo<T> pageInfo;

    /**
     * 返回的是集合
     */
    private List<T> list;

    /**
     * 返回的是单个对象
     */
    private T obj;

    /**
     * 表示返回的状态码
     */
    private Integer code = 200;

    /**
     * 表示可以展示给用户的信息
     */
    private String msg = "OK";

    public ResultVo() {
   
    }

    public ResultVo(PageInfo<T> pageInfo) {
   
        this.pageInfo = pageInfo;
    }

    public ResultVo(List<T> list) {
   
        this.list = list;
    }

    public ResultVo(T obj) {
   
        this.obj = obj;
    }

    public ResultVo(Integer code, String msg) {
   
        this.code = code;
        this.msg = msg;
    }
  
    // ------------- 此处省略Get / Set方法 -------------

5. 封装查询类

• 注意：这里封装的信息是查找的关键词或者编号

/**
 * 封装的查询类 - 药品管理
 *
 * @author murphy
 * @since 2021/8/8 2:19 下午
 */
public class QueryDrugVo {
   
    private Integer dr_id;
    private String dr_name;
    private String dr_type;

    // ------------- 此处省略Get / Set方法 -------------

6. 在 DrugMapper.java / DrugMapper.xml 文件中编写SQL语句

• DrugMapper.java - 方法接口

/**
 * 动态SQL
 * @param vo
 * @return
 */
List<Drug> queryByVo(QueryDrugVo vo);

• DrugMapper.xml - 方法实现

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.murphy.mapper.DrugMapper">
    <resultMap id="BaseResultMap" type="com.murphy.pojo.Drug">
        <id column="dr_id" jdbcType="INTEGER" property="dr_id"/>
        <result column="dr_url" jdbcType="VARCHAR" property="dr_url"/>
        <result column="dr_inPrice" jdbcType="DECIMAL" property="dr_inPrice"/>
        <result column="dr_outPrice" jdbcType="DECIMAL" property="dr_outPrice"/>
        <result column="dr_name" jdbcType="VARCHAR" property="dr_name"/>
        <result column="dr_type" jdbcType="VARCHAR" property="dr_type"/>
        <result column="dr_simpleDesc" jdbcType="VARCHAR" property="dr_simpleDesc"/>
        <result column="dr_expiration" jdbcType="VARCHAR" property="dr_expiration"/>
        <result column="dr_detaDesc" jdbcType="VARCHAR" property="dr_detaDesc"/>
        <result column="dr_factory" jdbcType="VARCHAR"