关于springboot集成mybatis pageHelper druid 配置

关于pageHelper和druid 请自行谷歌,在spring boot的pom.xml加上相关依赖,全部都使用相关的stater方式来引用依赖

<dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <scope>runtime</scope></dependency><!--MyBatis 及 插件依赖--><dependency>    <groupId>org.mybatis.spring.boot</groupId>    <artifactId>mybatis-spring-boot-starter</artifactId>    <version>1.3.0</version></dependency><dependency>    <groupId>tk.mybatis</groupId>    <artifactId>mapper-spring-boot-starter</artifactId>    <version>1.1.3</version></dependency><dependency>    <groupId>com.github.pagehelper</groupId>    <artifactId>pagehelper-spring-boot-starter</artifactId>    <version>1.1.2</version></dependency><dependency>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-configuration-processor</artifactId>    <optional>true</optional></dependency><!--阿里 FastJson依赖--><dependency>    <groupId>com.alibaba</groupId>    <artifactId>fastjson</artifactId>    <version>1.2.22</version></dependency><!--阿里 Druid Spring Boot Starter依赖--><dependency>    <groupId>com.alibaba</groupId>    <artifactId>druid-spring-boot-starter</artifactId>    <version>1.1.2</version></dependency>

application.yml 相关配置

spring:  mvc:    throw-exception-if-no-handler-found: true  resources:    add-mappings: false  datasource:    url: jdbc:mysql://192.168.1.94:3306/swarm2    username: kiktech    password: kiktech    driver-class-name: com.mysql.jdbc.Driver    type: com.alibaba.druid.pool.DruidDataSource    druid:      filters: stat      maxActive: 20      initialSize: 1      maxWait: 60000      minIdle: 1      timeBetweenEvictionRunsMillis: 60000      minEvictableIdleTimeMillis: 300000      validationQuery: select 'x'      testWhileIdle: true      testOnBorrow: false      testOnReturn: false      poolPreparedStatements: true      maxOpenPreparedStatements: 20#mybatismybatis:  type-aliases-package: com.kiktech.swarm2.common.model  mapper-locations: classpath:mapper/*.xml  config-location: classpath:mybatis-config.xmlmapper:  mappers: com.kiktech.swarm2.common.base.Mapper  not-empty: false  identity: MYSQL#pagehelperpagehelper:  helperDialect: mysql  reasonable: true  supportMethodsArguments: true  params: count=countSql

还要在加上扫描相关mapper的配置@mapperScan

@SpringBootApplication@MapperScan(basePackages = "com.kiktech.swarm2.common.dao")public class Application {    public static void main(String[] args) {        SpringApplication.run(Application.class, args);    }}

以上就已经配置完成了