SpringBoot [ 3.集成 Mybatis-Plus]

SpringBoot [ 3.集成 Mybatis-Plus] - 目录

---

1.引入POM依赖

    <!-- Mybatis-Plus -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>${mybatis-plus.version}</version>
    </dependency>

    <!-- Druid数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>${druid.verion}</version>
    </dependency>

    <!-- Mysql驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

2.代码示例

我这里的代码示例，提供了mybatis的新增，删除(批量删除)，修改以及多种分页查询的方法

2.1.Entity

package com.mantou.boot.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.util.Date;
import com.baomidou.mybatisplus.annotation.TableId;
import java.io.Serializable;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.RequiredArgsConstructor;
import lombok.experimental.Accessors;

/**
 * 系统模块-用户表
 *  TODO @Accessors提供链式set方法
 *  TODO @RequiredArgsConstructor 提供静态的构造方法
 * @author mantou
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@RequiredArgsConstructor(staticName = "newSysUser")
public class SysUser extends Model<SysUser> {

    private static final long serialVersionUID = 1L;

    @TableId(value = "user_id", type = IdType.AUTO)
    private Long userId;

    private String userAccount;

    private String userPassword;

    private String userName;

    private Date userBirthday;

    private Integer userGender;

    private Date createdTime;

    private Long createdUser;

    private Date updatedTime;

    private Long updatedUser;

    @Override
    protected Serializable pkVal() {
        return this.userId;
    }

}

2.1.Mapper

package com.mantou.boot.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mantou.boot.dto.param.SysUserParamDTO;
import com.mantou.boot.entity.SysUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

/**
 * 系统模块-用户表 Mapper 接口
 *
 * @author mantou
 */
public interface SysUserMapper extends BaseMapper<SysUser> {

    /**
     * 分页查询( IPge + 原生Sql查询 )
     * @param page
     * @param sysUserParamDTO
     * @return
     */
    IPage<SysUser> pageUserByParam(Page page, @Param(value = "sysUserParamDTO") SysUserParamDTO sysUserParamDTO);

    /**
     * 分页查询( IPge + WrapperSql查询 )
     * @param page
     * @param queryWrapper
     * @return
     */
    IPage<SysUser> pageUserByWrapperSql(Page page, @Param(value = "ew") QueryWrapper<SysUser> queryWrapper);
}

2.2.Application

package com.mantou.boot;


import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * SpringBoot 启动类
 * @author mantou
 */
@SpringBootApplication
@MapperScan(basePackages = "com.mantou.boot.mapper")
public class ManTouBootApplication {

    public static void main(String[] args) {
        SpringApplication.run(ManTouBootApplication.class, args);
    }
}

2.3.Service

package com.mantou.boot.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.mantou.boot.dto.param.SysUserParamDTO;
import com.mantou.boot.entity.SysUser;

import java.util.List;

/**
 * 系统模块-用户表 服务类
 *
 * @author mantou
 */
public interface SysUserService extends IService<SysUser> {

    /**
     * 新增用户
     * @param sysUser
     * @return
     */
    boolean saveUser(SysUser sysUser);

    /**
     * 批量新增用户
     * @param sysUserList
     * @return
     */
    boolean saveUserBatch(List<SysUser> sysUserList);

    /**
     * 分页查询( IPge + QueryWrapper查询 )
     * @param page
     * @param sysUserParamDTO
     * @return
     */
    IPage<SysUser> pageUser(Page page, SysUserParamDTO sysUserParamDTO);

    /**
     * 分页查询( IPge + 自定义参数对象 )
     * @param page
     * @param sysUserParamDTO
     * @return
     */
    IPage<SysUser> pageUserByParam