1.导入依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
            <version>5.1.47</version>
        </dependency>
        
         <!--使用阿里巴巴的druid数据源，有利于监控sql的执行情况-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <!--通用mapper-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.2</version>
        </dependency>

2.配置properties

server.port=8082

#Mybatis配置
spring.datasource.url=jdbc:mysql://192.168.0.111:3307/d_lvxk?characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&failOverReadOnly=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis.type-aliases-package=com.example.demo.xk.mapper

#log
logging.level.com.example.demo.xk.mapper=debug

3.Mapper配置

package com.example.demo.xk.mapper;

import com.example.demo.xk.entity.User;

import tk.mybatis.mapper.common.Mapper;

@org.apache.ibatis.annotations.Mapper
public interface UserMapper extends Mapper<User>{

}

4.Service配置

package com.example.demo.xk.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.demo.xk.entity.User;
import com.example.demo.xk.mapper.UserMapper;

@Service
public class UserService {
    
    @Autowired
    private UserMapper userMapper;

    public List<User> testSelectList() {
        return this.userMapper.selectAll();
    }

    public Object testSelectOne() {
        User userQueryCondition = new User();
        userQueryCondition.setAge(5);
        return this.userMapper.selectOne(userQueryCondition);
    }
}

5.Entity配置

package com.example.demo.xk.entity;

import javax.persistence.Table;

@Table(name = "t_user")
public class User {
    
    private String id;
    
    private String name;
    
    private Integer age;

    public String getId() {
        return id;
    }

    public void setId(String 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;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
    }
    
    

}

6.测试

package com.example.demo.xk.service;

import static org.junit.jupiter.api.Assertions.*;

import java.util.List;
import java.util.UUID;

import org.junit.Assert;
import org.junit.jupiter.api.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.example.demo.SpringbootMapperApplication;
import com.example.demo.xk.entity.User;
import com.example.demo.xk.mapper.UserMapper;
import com.example.demo.xk.util.IdUtil;

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = SpringbootMapperApplication.class)
class TestDemo {
    @Autowired
    private UserMapper userMapper;

    @Test
    void testTestSelectList() {
        List<User> usersList =userMapper.selectAll();
        for (User user : usersList) {
            System.out.println(user);
        }   
    }

    @Test
    void testInsert() {
        User user = new User();
        String id = IdUtil.getUUID();
        user.setId(id);
        user.setAge(18);
        user.setName("测试tina2");
        Assert.assertEquals(1,this.userMapper.insert(user));
        System.out.println("id:"+id);
    }

}

ok