关联分页查询

最新推荐文章于 2023-07-03 17:29:23 发布

技术老鸟

最新推荐文章于 2023-07-03 17:29:23 发布

阅读量205

点赞数

文章标签： mybatis java 数据库

本文链接：https://blog.csdn.net/qq_42981242/article/details/126290236

版权

先写个Vo实体类

package com.xiaoq.galaxy.entity.vo;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

@Data
public class AdminUserVo {

    //主键id
    @TableId(value = "id", type = IdType.AUTO)
    private int id;

    //用户名
    @ApiModelProperty("用户名")
    private String username;
    //密码
    @ApiModelProperty("密码")
    private String password;
    //邮箱
    @ApiModelProperty("邮箱")
    private String email;
    //创建时间
    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private Date createTime;
    //修改时间
    @ApiModelProperty("修改时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;
    //权限类型
    @ApiModelProperty("权限类型")
    private int roleId;

    //角色名称
    @ApiModelProperty("角色名称")
    private String roleName;
}

需要写SQL语句

package com.xiaoq.galaxy.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.xiaoq.galaxy.entity.vo.AdminUserVo;
import org.apache.ibatis.annotations.Select;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

public interface AdminUserVoDao extends BaseMapper<AdminUserVo> {

    @Select("select a.*,p.role_name from admin_user a,permission p where a.role_id=p.id")
    IPage<AdminUserVo> AdminUserVoList(Page<AdminUserVo> adminUserVoPage);
    
}

导包需要一样

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

    @ApiOperation("用户分页查询")
    @GetMapping(value = "/selectPage") 
    public Result<IPage<AdminUserVo>> selectPages(
            @RequestParam(value = "pageNum", required = false, defaultValue = "1") Integer pageNum,
            @RequestParam(value = "pageSize", required = false, defaultValue = "10") Integer pageSize) {
        return Result.succeed(adminUserVoDao.AdminUserVoList(new Page<>(pageNum, pageSize)));
    }