SpringBoot整合Mybatis

SpringBoot整合Mybatis

1、添加依赖

1）Mybatis与SpringBoot整合依赖

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

2）数据库驱动依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

3）数据源依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.1</version>
</dependency>

需要使用jsp时需要添加视图解析器依赖

<dependency>
    <groupId>org.apache.tomcat.embed</groupId>
    <artifactId>tomcat-embed-jasper</artifactId>
    <scope>provided</scope>
</dependency>

2、Dao层需要注意

@Mapper
public interface IStudentDao {
    int insertStudent(Student student);
}

Dao层接口需要添加注解

@Mapper

3、SpringBoot配置文件需要注册映射文件、实体类、以及数据源

mybatis:
#  注册映射文件
  mapper-locations: classpath:com\lpx\springbootmybatis\dao\IStudentDao.xml
#  注册实体类
  type-aliases-package: com.lpx.springbootmybatis.commons.pojo.Student
#  配置数据源
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///student?serverTimezone=UTC
    username: root
    password: 3014