springboot使用pageHelper，多条件模糊分页查询，Map传多个参数

第一步：导包

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.13</version>
</dependency>

第二步：mapper层

List<User> getAll(Map<String,Object> map);

第三步：mapper.xml文件

<select id="getAll" resultType="user" parameterType="map">
    select *
    from library.user
    <where>
        <if test="username!=null and username !=''">
            and username like concat('%',#{username},'%')
        </if>
        <if test="password!=null and password !=''">
            and password like concat('%',#{password},'%')
        </if>
    </where>
</select>

第四步：controller层

@GetMapping("/getAll")
 public HashMap<String, Object> getAll(@RequestParam Integer pageNum,@RequestParam Integer pageSize
        ,@RequestParam String username
        ,@RequestParam String password){
    //查询分页后的所有数据
    HashMap<String, Object> hashMap = new HashMap<>();
    hashMap.put("username",username);
    hashMap.put("password",password);
    PageHelper.startPage(pageNum,pageSize);
    List<User> list = userService.getAll(hashMap);
    PageInfo<User> PageInfo = new PageInfo<>(list);
    HashMap<String, Object> map = new HashMap<>();
    map.put("data",PageInfo.getList());
    map.put("total",PageInfo.getTotal());//获得总条数
    return map;
 }

前端是用vue-element框架