SpringBoot整合MyBatis框架（学习笔记六）

MyBatis本是apache的一个开源项目iBatis，2010年这个项目由apache software foundation迁移到了google code，并且改名为MyBatis。2013年11月迁移到Github。

 

1.搭建SpringBoot项目工程

新建项目之后——》SQL——》选中MySql和MyBatis Framework

 

 2.引入mybatis起步依赖，添加mysql驱动

在pom.xml文件中引入依赖：

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

在src/main/java/resources文件下新建一个application.yml文件

 在该文件中我们先写入驱动的数据

#驱动的数据
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mydb
    username: root
    password: 123456

将一下sql语句运行在mysql数据库中用于做测试

/*
Navicat MySQL Data Transfer

Source Server         : aaa
Source Server Version : 80023
Source Host           : localhost:3306
Source Database       : mydb

Target Server Type    : MYSQL
Target Server Version : 80023
File Encoding         : 65001

Date: 2022-07-31 11:25:31
*/


-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin NOT NULL,
  `phone` varchar(20) COLLATE utf8_bin NOT NULL,
  `money` double NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1', '李三', '4657898451', '15500', '2022-04-05');
INSERT INTO `teacher` VALUES ('2', '往五', '494891956465', '56000', '2022-04-01');
INSERT INTO `teacher` VALUES ('4', '李明', '123456789', '456', '2000-04-16');
INSERT INTO `teacher` VALUES ('7', '打打怪', '492856', '168180', '1970-01-01');

用注解的方式访问mysql数据库

在src/mian/java/com.example.springbootmybatis2中新建一个包mapper,在包下新建一个TeacherMapper的接口文件

 在TeacherMapper接口文件中编写如下代码

package com.example.springbootmybatis2.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

@Mapper
public interface TeacherMapper {

    @Select("select * from teacher")
    List<Map<String,Object>> getTeacherList();
}

我们在test/java/com.example.springbootmybatis2包下找到test文件

编写如下代码进行测试

package com.example.springbootmybatis2;


import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;
import java.util.Map;

@SpringBootTest
class SpringBootMyBatis2ApplicationTests {


    @Autowired
    private TeacherMapper teacherMapper;

    @Test
    void contextLoads() {
        List<Map<String, Object>> teacherList = teacherMapper.getTeacherList();
        System.out.println(teacherList);
    }

再运行测试类，运行结果为：

[{date=2022-04-05, money=15500.0, phone=4657898451, name=李三, id=1}, {date=2022-04-01, money=56000.0, phone=494891956465, name=往五, id=2}, {date=2000-04-16, money=456.0, phone=123456789, name=李明, id=4}, {date=1970-01-01, money=168180.0, phone=492856, name=打打怪, id=7}]

 用配置文件的方式访问mysql数据库

 我们要在application.yml文件中，添加如下代码

mybatis:
  #映射包的路径
  type-aliases-package: com.example.springbootmybatis2.mapper
  #xml文件的路径
  mapper-locations: classpath:mapper/*Mapper.xml

在src/mian/java/com.example.springbootmybatis2中新建一个包mapper,在包下新建一个TeacherMapper2的接口文件

package com.example.springbootmybatis2.mapper;

import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface TeacherMapper2 {

    List<Map<String,Object>> getTeacherList2();
}

我们在test/java/com.example.springbootmybatis2包下找到test文件

编写如下代码进行测试

package com.example.springbootmybatis2;

import com.example.springbootmybatis2.mapper.TeacherMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;
import java.util.Map;

@SpringBootTest
class SpringBootMyBatis2ApplicationTests {

    @Autowired
    private TeacherMapper teacherMapper2;

    @Autowired
    private TeacherMapper teacherMapper;

    @Test
    void contextLoads() {
        List<Map<String, Object>> teacherList = teacherMapper.getTeacherList();
        System.out.println(teacherList);
    }

    @Test
    void getTeacherList(){
        List<Map<String, Object>> teacherList = teacherMapper2.getTeacherList();
        System.out.println(teacherList);
    }
}

 运行getTeacherList得到的结果为：

[{date=2022-04-05, money=15500.0, phone=4657898451, name=李三, id=1}, {date=2022-04-01, money=56000.0, phone=494891956465, name=往五, id=2}, {date=2000-04-16, money=456.0, phone=123456789, name=李明, id=4}, {date=1970-01-01, money=168180.0, phone=492856, name=打打怪, id=7}]