3.SpringBoot集成SpringMVC和MyBatis

第一步

1创建SpringBoot项目

2，填写相关信息

3，选择框架

4：完成项目的创建

第二步，mybatis配置

1.我们使用druid数据库连接池，在pom文件中加入如下依赖

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

2.把springboot配置文件改成yml后缀如下

3.在application.yml中配置如下信息，注意数据库的名称和密码是否正确

server:
  port: 8081
  servlet:
    context-path: /jw
    
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/pms?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: root
  druid:
    initialSize: 10
    minIdle: 5
    maxActive: 20
    maxWait: 10
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 30000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxPoolPreparedStatementPerConnectionSize: 20
    filters: stat,wall,log4j
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000


mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    #开启下划线转驼峰
    mapUnderscoreToCamelCase: true

4.在SpringBoot启动类上加注解扫描mapper接口

@MapperScan("com.bajin.mapper")

5.到此Mybatis配置完成，我跳过业务层，直接在表现层调用持久化层测试一下

6.运行成功