mybatis-plus下分页查询

最新推荐文章于 2024-08-12 15:45:48 发布

史山搬运工

最新推荐文章于 2024-08-12 15:45:48 发布

阅读量66

点赞数

文章标签： mybatis java spring spring boot Powered by 金山文档

本文链接：https://blog.csdn.net/m0_73282829/article/details/129699606

版权

一.插入依赖

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<scope>runtime</scope>

</dependency>

<groupId>com.baomidou</groupId>

<artifactId>mybatis-plus-boot-starter</artifactId>

</dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

</dependency>

二.mapper配置文件

<?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.zb.mapper.WorkordersMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.zb.entity.WorkordersModel">
        <id column="id" property="id"/>
        <result column="projectId" property="projectId"/>
        <result column="executor" property="executor"/>
        <result column="desciption" property="desciption"/>
        <result column="orderLevel" property="orderLevel"/>
        <result column="createDate" property="createDate"/>
        <association property="projectteams" javaType="com.zb.entity.ProjectteamsModel">
            <result column="id" property="id"></result>
            <result column="projectName" property="projectName"></result>
        </association>
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
            id, projectId, executor, desciption, orderLevel, createDate
        </sql>
    <select id="page" resultMap="BaseResultMap">
        SELECT w.* FROM demo.workorders w
        inner join projectteams p on w.projectId=p.id
            ${ew.customSqlSegment}
</select>
</mapper>

二表联查

column内是列名

property内是实体类中属性名

${ew.customSqlSegment}固定格式

三.dao层mapper类中接口抽象方法

List<实体类名>page(Page<实体类名> page,

@Param(Constants.WRAPPER) Wrapper wrapper);

@Param(Constants.WRAPPER) Wrapper wrapper为${ew.customSqlSegment}占位

四.service层实现类

package com.zb.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zb.entity.WorkordersModel;
import com.zb.mapper.WorkordersMapper;
import com.zb.service.WorkordersService;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @ClassName WorkordersServiceImpl
 * @Description 服务接口实现
 * @Author zj
 * @Date 2023/03/21 17:09
 **/
@Service
        public class WorkordersServiceImpl extends ServiceImpl<WorkordersMapper, WorkordersModel> implements WorkordersService {

    @Override
    public Page<WorkordersModel> page(Integer index, Integer size) {
        Page<WorkordersModel> page=new Page<>(index,size);
        QueryWrapper<WorkordersModel> queryWrapper=new QueryWrapper<>();
        List<WorkordersModel> page1 = baseMapper.page(page, queryWrapper);
        page.setRecords(page1);
        return page;
    }
}

如果要进行条件查询可以使用QueryWrapper下的方法如模糊查询精准查询等

queryWrapper.like("列名",查询词)模糊查询

queryWrapper.eq("列名",查询词)

 if (!StringUtils.isEmpty(name)) {
            queryWrapper.like("nick_name", name);
        }
 if (dept != null && dept > 0) {
            queryWrapper.eq("dept_id", dept);
        }

五controller控制器层需要将查询的分页数据重新封装dto

package com.zb.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zb.config.PageUtil;
import com.zb.dto.ProjectteamsDto;
import com.zb.dto.WorkordersDto;
import com.zb.entity.WorkordersModel;
import com.zb.service.WorkordersService;

import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.stream.Collectors;

/**
 * @ClassName WorkordersController
 * @Description 控制器
 * @Author zj
 * @Date 2023/03/21 17:09
 **/
@RestController
@RequestMapping("/workorders-model")
public class WorkordersController {

    @Autowired
    public WorkordersService workordersModelService;

    @GetMapping("/page")
    public PageUtil<WorkordersDto> page(@RequestParam(value = "index", required = true, defaultValue = "1") Integer index,
                                        @RequestParam(value = "size", required = true, defaultValue = "2") Integer size) {
        PageUtil<WorkordersDto> pageUtil = new PageUtil<>();
        Page<WorkordersModel> page = workordersModelService.page(index, size);
        List<WorkordersDto> wmPage = page.getRecords().stream().map(WM -> {
                 //创建实体的对应dto实体引用
            WorkordersDto workordersDto = new WorkordersDto();
            ProjectteamsDto projectteamsDto = new ProjectteamsDto();
               //将多表联查的内容设置进对应实体类    
            projectteamsDto.setId(WM.getProjectteams().getId());
            projectteamsDto.setProjectName(WM.getProjectteams().getProjectName());
            workordersDto.setProjectteamsDto(projectteamsDto);

            //复制赋值dto实体类
            BeanUtils.copyProperties(WM, workordersDto);
            return workordersDto;
        }).collect(Collectors.toList());
        //将数据封装进准备好的分页工具类中
        pageUtil.setData(wmPage);
        pageUtil.setIndex(index);
        pageUtil.setSize(size);
        pageUtil.setCount(Long.valueOf(page.getTotal()).intValue());

        return pageUtil;
    }
}

封装分页数据的工具类可自行看需求创建