SpringBoot结合Mybatis

2020-02-18 0条评论 589次阅读 0人点赞

jar包引入

<dependency>  
    <groupId>org.springframework.bootgroupId>  
    <artifactId>spring-boot-starter-thymeleafartifactId>  
dependency> 
    
<dependency>  
    <groupId>mysqlgroupId>  
    <artifactId>mysql-connector-javaartifactId>  
dependency>  
    
<dependency>  
    <groupId>org.mybatis.spring.bootgroupId>  
    <artifactId>mybatis-spring-boot-starterartifactId>  
    <version>1.3.0version>  
dependency>

配置application.properties

如果是properties文件，配置如下

#Mybatis配置
spring.datasource.url=jdbc:mysql://localhost:3306/demo?characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&failOverReadOnly=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.type-aliases-package=com.example.demo1.entity,com.example.demo2.entity
mybatis.mapperLocations=classpath:mappers/*.xml

配置application.yml

如果是yml文件，配置如下

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/javaelec?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

mybatis:
  mapper-locations: classpath:com/javaelec/*/mapper/*Mapper.xml
  type-aliases-package: com.example.demo1.entity,com.example.demo2.entity

扫描Mapper接口

方法一：在启动类上加@MapperScan

@MapperScan("com.javaelec")
@SpringBootApplication
public class WxApplication {

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

方法二：在mapper接口文件上加@Mapper注解

Invalid bound statement (not found)

启动后依然报错，发现编译后的文件不包括xml，需要在pom.xml中添加

    <build>
        <resources>
            <resource>
                <directory>src/main/javadirectory>
                <includes>
                    <include>**/*.xmlinclude>
                includes>
            resource>
            <resource>
                <directory>src/main/resourcesdirectory>
                <includes>
                    <include>**/*include>
                includes>
            resource>
        resources>
    build>