springboot整合mybatis

1.依赖

 <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.3.0</version>
        </dependency>
 <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2.配置文件application.properties

spring.datasource.url=jdbc:mysql:///brand?characterEncoding=utf8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456

3.接口类上加@Mapper

@Mapper
public interface BrandMapper {

还有另外一种解决方案：

在boot项目启动类上加@MapperScan注解

@MapperScan("com.c55.vue.mapper")
public class VueApp {

4.指定sql映射文件的位置

方案一：把sql映射文件跟mapper接口类放在一起

这样会出现一个问题：如果我们不做任何处理的话，会导致编译后的target里面sql映射文件丢失

解决方案：在pom文件中加以下配置

<build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
</build>

方案二：在类路径下新建一个文件夹用于存sql映射文件

mybatis.mapper-locations=classpath:mapper/*.xml