SpringBoot集成Mybatis（包括Mybatis-Plus）和日志

一、使用Mybatis

1.添加依赖

   <!--Mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version> <!-- 选择与Java 8兼容的版本 -->
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.32</version> <!-- 请根据需要调整版本号 -->
        </dependency>
        <!--注解相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

2.添加配置

spring:
  datasource:
    url: jdbc:mysql://192.168.101.128:3306/test1?useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: abcdef
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  # 配置mapper.xml文件位置
  mapper-locations: classpath:mapper/*.xml
  # 开启自动驼峰映射
  configuration:
    map-underscore-to-camel-case: true

3.然后就能使用了

例如：

实体类

package com.example.springbootdemo3.model;

import org.springframework.data.annotation.Id;

import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Table;
import java.time.LocalDateTime;

/**
 * description
 *
 * @author PC 2025/03/02 19:26
 */
@Table(name = "user_test")
public class UserTest {

    @Id // JPA annotation for marking the primary key
    @GeneratedValue(strategy = GenerationType.IDENTITY) // Auto increment strategy
    private Integer id;

    @Column(name = "name", length = 255)
    private String name;

    @Column(name = "age")
    private Integer age;

    @Column(name = "create_date")
    private LocalDateTime createDate;

    @Column(name = "update")
    private LocalDateTime lastUpdate;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public LocalDateTime getCreateDate() {
        return createDate;
    }

    public void setCreateDate(LocalDateTime createDate) {
        this.createDate = createDate;
    }

    public LocalDateTime getLastUpdate() {
        return lastUpdate;
    }

    public void setLastUpdate(LocalDateTime lastUpdate) {
        this.lastUpdate = lastUpdate;
    }
}

java接口

package com.example.springbootdemo3.mapper;

import com.example.springbootdemo3.model.UserTest;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * description
 *
 * @author PC 2025/03/02 20:52
 */
@Mapper
public interface UserTestMapper {

    List<UserTest> selectAllUsers();
}

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.example.springbootdemo3.mapper.UserTestMapper">

    <!-- 查询所有用户 -->
    <select id="selectAllUsers" resultType="com.example.springbootdemo3.model.UserTest">
        SELECT id, `name`, age, create_date, last_update
        FROM user_test
    </select>
</mapper>

测试

package com.example.springbootdemo3.controller;

import com.example.springbootdemo3.mapper.UserTestMapper;
import com.example.springbootdemo3.model.UserTest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * description
 *
 * @author PC 2025/03/02 20:54
 */
@RestController
@RequestMapping("/date-test")
public class DateDourceController {

    @Autowired
    private UserTestMapper userTestMapper;

    @GetMapping("/get-all")
    public List<UserTest> getAll() {
        return userTestMapper.selectAllUsers();
    }

}

二、使用Mybatis-Plus(和上面二选一即可)

1.添加依赖

 <!--Mybatis Plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3</version> <!-- 请根据需要选择最新版本 -->
        </dependency>
        <!-- MySQL连接器 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.32</version> <!-- 请根据需要调整版本号 -->
        </dependency>
        <!--注解相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

2.添加配置

spring:
  datasource:
    url: jdbc:mysql://192.168.101.128:3306/test1?useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: abcdef
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis-plus:
  # 配置mapper.xml文件位置
  mapper-locations: classpath:mapper/*.xml
  # 开启自动驼峰映射
  configuration:
    # 配置驼峰命名
    map-underscore-to-camel-case: true

3.然后就可以用了

package com.example.springbootdemo3.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.example.springbootdemo3.mapper.UserTestMapper;
import com.example.springbootdemo3.model.UserTest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * description
 *
 * @author PC 2025/03/02 20:54
 */
@RestController
@RequestMapping("/date-test")
public class DateDourceController {

    @Autowired
    private UserTestMapper userTestMapper;

    @GetMapping("/getByName")
    public List<UserTest> getList(String name) {
        QueryWrapper<UserTest> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name", name);
        return userTestMapper.selectList(queryWrapper);
    }
}

三、日志（包含Mybatis-plus日志）

1.加依赖

<!-- SLF4J API -->
<dependency>
	<groupId>org.slf4j</groupId>
	<artifactId>slf4j-api</artifactId>
 </dependency>
<!-- Logback Classic -->
<dependency>
	<groupId>ch.qos.logback</groupId>
	<artifactId>logback-classic</artifactId>
</dependency>

2.加配置（搞定）

mybatis-plus:
  configuration:
    # 配置日志实现类
    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
logging:
  level:
    com.example.springbootdemo3: INFO
    com.baomidou.mybatisplus: DEBUG
    com.zaxxer.hikari: INFO
    com.example.springbootdemo3.mapper: DEBUG