spring boot与mybatis的整合

1,向spring boot项目的pom.xml文件中添加依赖

<!--整合mybatis所需的依赖包-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.0</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

2,在application.yml文件中配置数据源及扫描包

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/你的数据库名?serverTimezone=UTC
    type: com.alibaba.druid.pool.DruidDataSource
    username: root
    password: admin
    driver-class-name: com.mysql.jdbc.Driver
#springboot整合mybatis,配置扫描接口
mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.你的公司名.你的项目名

3,创建实体类

 

4,创建dao接口

 

 

5,在resources/mapper目录下创建mybatis mapper映射文件UserDao.xml

 

6,创建Service接口及其实现类

 

 

 

 

 7,创建controller类

 

8,修改主启动类,增加扫描dao接口