分页后的模糊查询

此处以项目中work模块为例 仅供参考

1.1 修改Dao层/Service

 将列表改为有参
List<Work> list(Work work);

修改ServiceImpl为有参构造

  @Override
    public List<Work> list(Work work) {
        return workDao.list(work);
    }

1.2 修改xml

  <!--查询列表-->
    <select id="list" parameterType="com.tledu.model.Work" resultMap="Work">

        select work.*, device.device_name,product_name
        from work
                 left join device on work.work_id = device.device_id
                 left join product on work.product_id = product.product_id
    <!--添加下方代码即为模糊查询语句 此处根据ID查询-->
        <where >
            <if test="workId != null and workId !=''">
                and work_id like concat('%',#{workId},'%')
            </if>
        </where>
    </select>

1.3 修改Crntroller

    @GetMapping("/list")
    public String wor(ModelMap modelMap,Integer pageNum, Integer pageSize,Work work) {
        PageHelper.startPage(pageNum,pageSize);
        <!--传入对象-->
        List<Work> worksList = workService.list(work);
        PageInfo<Work> pageInfo = PageInfo.of(worksList);
        modelMap.addAttribute("pageInfo",pageInfo);
        return "work/work-list";
    }

1.4 修改html/list页面

<div class="layui-inline layui-show-xs-block">
<!--由于实现了分页 所以务必加入分页信息  -->
    <input type="hidden" name="pageNum" th:value="1">
    <input type="hidden" name="pageSize" th:value="5">
    <!--将下方name修改为需要查询的Id即可-->
    <input type="text" name="WorkId" placeholder="请输入用户名" autocomplete="off"
                                   class="layui-input">
 </div>

至此可以在项目中根据Id实现模糊查询