queryPageList

最新推荐文章于 2025-04-25 19:16:38 发布

lifelalala

最新推荐文章于 2025-04-25 19:16:38 发布

阅读量342

点赞数 3

分类专栏：后端文章标签： java

本文链接：https://blog.csdn.net/qq_46423858/article/details/147420221

版权

后端专栏收录该内容

17 篇文章

订阅专栏

Controller

@GetMapping(value = "/list")
	public Result<?> queryPageList(ReconsiderPerson reconsiderPerson,
								   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								   HttpServletRequest req) {
		// 构建分页对象
		Page<ReconsiderPerson> page = new Page<>(pageNo, pageSize);

		// 调用Service层
		IPage<ReconsiderPerson> pageList = reconsiderPersonService.queryPageList(page, reconsiderPerson, req.getParameterMap());

		return Result.OK(pageList);
	}

Service

IPage<ReconsiderPerson> queryPageList(Page<ReconsiderPerson> page, ReconsiderPerson reconsiderPerson, Map<String, String[]> parameterMap);

ServiceImpl

    @Autowired
    private ReconsiderPersonMapper reconsiderPersonMapper;

    @Override
    public IPage<ReconsiderPerson> queryPageList(Page<ReconsiderPerson> page, ReconsiderPerson reconsiderPerson, Map<String, String[]> parameterMap) {
        return reconsiderPersonMapper.queryPageList(page, reconsiderPerson);
    }

Mapper

IPage<ReconsiderPerson> queryPageList(@Param("page") Page<ReconsiderPerson> page, @Param("entity") ReconsiderPerson reconsiderPerson);

Mapper.xml

<select id="queryPageList" resultType="org.whye.modules.xzfy.reconsiderPerson.entity.ReconsiderPerson">
        SELECT
        A.user_name as userName,
        from sys_user A
        left join reconsider_person B on A.id = B.user_id
        left join sys_depart C on A.org_code = C.org_code
        <where>
            <if test="entity.userName != null and entity.userName != ''">
                AND A.user_name LIKE CONCAT('%', #{entity.userName}, '%')
            </if>
        </where>
    </select>