Springboot集成mybatis通用Mapper

我不是女神ヾ 2023-06-30 01:53 31阅读 0赞

#### 文件结构如下 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw_size_16_color_FFFFFF_t_70]

#### 导入的依赖 ####

<dependencies>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
    
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>2.1.5</version>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
                <exclusions>
                    <exclusion>
                        <groupId>org.junit.vintage</groupId>
                        <artifactId>junit-vintage-engine</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
        </dependencies>

#### 配置 ####

spring:
      datasource:
        username: root
        password: root
        url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
        driver-class-name: com.mysql.cj.jdbc.Driver
    mybatis:
      type-aliases-package: com.duofan.mybatis.persistence.beans
      mapper-locations: classpath:/mybatis/*.xml

#### StudentMapper ####

package com.duofan.mybatis.persistence.mapper;
    
    import com.duofan.mybatis.persistence.beans.Student;
    import org.springframework.stereotype.Repository;
    import tk.mybatis.mapper.common.Mapper;
    
    import java.util.List;
    
    /** * @author duofan 2441051071@qq.com */
    @Repository
    public interface StudentMapper extends Mapper<Student> { 
        /** * 获取所有学生 * @return */
        List<Student> getAllStudent();
    }

#### StudentMapper.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.duofan.mybatis.persistence.mapper.StudentMapper">
        <resultMap id="rm" type="com.duofan.mybatis.persistence.beans.Student">
            <result property="id" jdbcType="BIGINT" column="id"/>
            <result property="name" jdbcType="VARCHAR" column="name"/>
            <result property="sex" jdbcType="VARCHAR" column="sex"/>
            <result property="age" jdbcType="BIGINT" column="age"/>
        </resultMap>
    
        <select id="getAllStudent" resultType="com.duofan.mybatis.persistence.beans.Student">
            SELECT * FROM STUDENT
        </select>
    
    </mapper>

#### 测试代码 ####

package com.duofan.mybatis;
    
    import com.duofan.mybatis.persistence.beans.Student;
    import com.duofan.mybatis.persistence.mapper.StudentMapper;
    import org.junit.jupiter.api.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import tk.mybatis.spring.annotation.MapperScan;
    
    import java.util.List;
    
    @SpringBootTest
    // MapperScan 必须是tk.mybaits 下的mapperscan
    @MapperScan("com.duofan.mybatis.persistence.mapper")
    class MybatisApplicationTests { 
    
        @Autowired
        private StudentMapper studentMapper;
        @Test
        void contextLoads() { 
            System.out.println("Mapper 查询");
            List<Student> students = studentMapper.selectAll();
            students.forEach(student -> System.out.println(student));
    
            System.out.println("mybatis xml查询");
            List<Student> allStudent = studentMapper.getAllStudent();
            allStudent.forEach(student -> System.out.println(student));
        }
    
    }

#### 输出结果 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200113235538315.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200114000011796.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU4MDk3Nw==,size_16,color_FFFFFF,t_70