Springboot 整合mybatis

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

SpringBoot默认的数据源: Hikari

Mysql8: url一定需要添加时区

#数据源
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3307/user01?serverTimezone=Asia/Shanghai
    username: root
    password: root

导入依赖: 先导入starter,没有starter才导入直接依赖

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

mybatis跟spring整合:

1. DataSource的bean

2. SqlSessionFactoryBean

3. MapperScanner 参数: basePackage

#mybatis参数
mybatis:
  mapper-locations: classpath*:mapper/*Mapper.xml
  type-aliases-package: com.fs.pojo

没有扫描mapper接口

• 给Mapper接口添加一个注解 @Mapper

 

 

idea的问题

解决方案: idea只识别spring的注解, 人为给UserMapper添加@Repository

 在配置类, 使用@MapperScan(包) 扫描指定包下的所有的mapper接口

 打印sql, 设置日志输出级别: debug:

#设置日志输出级别
logging:
  level:
    com.fs: debug