Spring Boot整合MyBatis-Plus详细步骤

Spring Boot 是一个基于 Spring Framework 的开源、轻量级、企业级 Java 开发框架，其核心目标是简化 Spring 应用的初始搭建和开发过程，让开发者能够快速创建独立运行、生产级的 Spring 应用。

MyBatis-Plus（简称 MP）是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。

springboot是目前最为流行的java开发框架，而MyBatis-Plus，又是对持久层框架mybatis的增强，两者的强强联合将极大的简化开发，提高开发效率，以下是完整的整合流程（基于Spring Boot 2.7.18和MyBatis-Plus 3.5.7）：

1.创建表t_user

创建表t_user

CREATE TABLE `t_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tel` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL UNIQUE,
   `email` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

插入数据

INSERT INTO `stock`.`t_user` ( `username`, `tel`, `email`, `create_time`) VALUES ('zhangsan', '15100000000', 'zhangsan@163.com', '2025-08-05 17:44:56');
INSERT INTO `stock`.`t_user` (`username`, `tel`, `email`, `create_time`) VALUES ('lisi', '17100000000', 'lisi@163.com', '2025-08-05 17:45:38');

2. 创建项目 & 添加依赖

<dependencies>
    <!-- Spring Boot Starter -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
        <version>2.7.18</version>
    </dependency>
    
    <!-- MyBatis-Plus Starter -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.5.7</version>
    </dependency>
    
    <!-- 数据库驱动 (以MySQL为例) -->
    <dependency>
      <groupId>com.mysql</groupId>
      <artifactId>mysql-connector-j</artifactId>
      <version>8.3.0</version>
    </dependency>
    
    <!-- Lombok -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.30</version>
    </dependency>
</dependencies>

3. 配置文件

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///database?useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: password

mybatis-plus:
  configuration:
    map-underscore-to-camel-case: true  # 自动驼峰转换
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  type-aliases-package: com.demo.entity # 为指定包下的类自动创建类型别名
  mapper-locations: classpath*:mapper/*.xml

4. 创建实体类

package com.demo.entity;

import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;

import java.time.LocalDateTime;

@Data
@TableName("t_user")
public class User {
    @TableId(type = IdType.AUTO)
    private Long id;

    private String username;

    private String tel;

    private String email;

    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

}

5. 创建Mapper接口

package com.demo.mapper;

import com.demo.entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper extends BaseMapper<User> {

    // 通过手机号查询用户
    User findByTel(String tel);
}

6. Mapper XML配置

<?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.demo.mapper.UserMapper">

    <select id="findByTel" resultType="user">
        select * from t_user where tel = #{tel}
    </select>

</mapper>

7. 服务层使用

package com.demo.service;

import com.demo.entity.User;
import com.baomidou.mybatisplus.extension.service.IService;

public interface UserService extends IService<User> {
    User findByTel(String tel);
}

实现类

package com.demo.service.impl;

import com.demo.entity.User;
import com.demo.mapper.UserMapper;
import com.demo.service.UserService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {

    @Resource
    private UserMapper userMapper;

    @Override
    public User findByTel(String tel) {
        return userMapper.findByTel(tel);
    }
}

8. 控制层使用

package com.demo.controller;

import com.demo.base.common.Result;
import com.demo.base.enums.SysMsgEnum;
import com.demo.entity.User;
import com.demo.service.UserService;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

@RestController
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @GetMapping("/findByTel")
    public Result findByTel(String tel){
        return Result.success(userService.findByTel(tel));
    }

    @PostMapping
    public Result add(@RequestBody User user){
        boolean save = userService.save(user);
        if (save){
            return Result.success(SysMsgEnum.ADD_SUCCESS);
        }
        return Result.success(SysMsgEnum.ADD_FAIL);
    }
}

9. 主启动类

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

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

10.启动并访问

查看控制台日志，有打印sql语句

11. 常用配置项

mybatis-plus:
  mapper-locations: classpath*:/mapper/*.xml  # XML路径
  type-aliases-package: com.demo.entity       # 实体类包路径
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 开启SQL日志

注意事项：

1. SQL日志：配置 mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl 查看执行SQL

2. ID生成策略：

   @TableId(type = IdType.AUTO)   // 数据库自增
   @TableId(type = IdType.ASSIGN_ID) // 默认雪花算法（分布式ID）
   
   

3. 字段自动填充：

@TableField(fill = FieldFill.INSERT)

为实现字段的自动填充，需要新增MetaObjectHandler的实现类

package com.demo.base.config;

import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;

@Component
public class MPMetaObjectHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        metaObject.setValue("createTime", LocalDateTime.now());
    }

    @Override
    public void updateFill(MetaObject metaObject) {

    }

}