【SpringBoot】4--集成mybaits

---

---

Spring Boot集成Mybatis

（1）准备数据库创建user表

create database springboot_test;

create table person(
	id  int primary key auto_increment,
	name varchar(20),
	age int
)

（2）通过SpirngBoot的初始化生成器勾选MyBatis和MySQL依赖。

查看pom.xml是否集成依赖

<dependencies>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</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>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

    <repositories>
        <repository>
            <id>spring-milestones</id>
            <name>Spring Milestones</name>
            <url>https://repo.spring.io/milestone</url>
        </repository>
        <repository>
            <id>spring-snapshots</id>
            <name>Spring Snapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <snapshots>
                <enabled>true</enabled>
            </snapshots>
        </repository>
    </repositories>
    <pluginRepositories>
        <pluginRepository>
            <id>spring-milestones</id>
            <name>Spring Milestones</name>
            <url>https://repo.spring.io/milestone</url>
        </pluginRepository>
        <pluginRepository>
            <id>spring-snapshots</id>
            <name>Spring Snapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <snapshots>
                <enabled>true</enabled>
            </snapshots>
        </pluginRepository>
    </pluginRepositories>

测试

（1）创建Person类

public class Person {
    private int id;
    private String name;
    private int age;
}

（2）配置mybatis（application.yml）

src\main\resources\application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/springboot_test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
mybatis:
  type-aliases-package: com.smp.demo04mybatiss.domain
  mapper-locations: classpath:com.smp.demo04mybatiss.dao/*.xml
  #使用注解在启动类上面配置 @MapperScan("com.smp.demo04mybatis.dao")//存放接口
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # mybatis日志

（3）在Application启动类上添加@MapperScan注解扫描dao

@SpringBootApplication
@MapperScan("com.smp.demo04mybatiss.dao")//扫描接口
public class Demo04mybatissApplication {

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

}

（4）集成mybatis

PersonDao.java
src\main\java\com\smp\demo04mybatiss\dao

public interface PersonDao {
    List<PersonDao> findAllPerson();
}

PersonDao.xml
src\main\resources\com\smp\demo04mybatiss\dao

<?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" >
<!--namespace: 需要映射的Dao接口类型-->
<mapper namespace="com.smp.demo04mybatiss.dao.PersonDao">
    <!--List<PersonDao> findAllPerson();-->
    <select id="findAllPerson" resultType="person">
        select * from person
    </select>

</mapper>

（5）测试Demo04mybatissApplicationTests

@SpringBootTest
class Demo04mybatissApplicationTests {

    @Autowired
    PersonDao dao;

    @Test
    void test01() {
        System.out.println(dao.findAllPerson());
    }
}