Spring boot 整合mybatis

步骤

1. 准备pom文件

      <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>
        </dependency>

2. 配置properties(mysql以及mybatis)

#mysql
spring.datasource.url=jdbc:mysql://localhost:3306/demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.username=root
spring.datasource.password=Hello12345
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#mybatis
mybatis.mapper-locations=classpath:mapper/*.xml

3. 在项目启动时候记得配置MapperScan

@SpringBootApplication(scanBasePackages = "com.mamba.aliware")
@MapperScan(basePackages = {"com.mamba.aliware.dal"})
public class ExampleApplication {
    public static void main(String[] args) {
        SpringApplication.run(ExampleApplication.class, args);
    }
}

mybatis 配置

系统同时需要知道Mybatis 的Mapper接口以及对于的XML文件进行映射。

xml路径配置

其中properties配置文件mybatis.mapper-locations=classpath:mapper/*.xml代表是扫描xml的路径

service接口配置

在接口定义@Mapper或者在启动类时候定义@MapperScan

@SpringBootApplication(scanBasePackages = "com.mamba.aliware")
@MapperScan(basePackages = {"com.mamba.aliware.dal"})
public classExampleApplication {
    public static void main(String[] args) {
        SpringApplication.run(ExampleApplication.class, args);
    }
}