关于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 #mybatis mybatis: type-aliases-package: com.kiktech.swarm2.common.model mapper-locations: classpath:mapper/*.xml config-location: classpath:mybatis-config.xml mapper: mappers: com.kiktech.swarm2.common.base.Mapper not-empty: false identity: MYSQL #pagehelper pagehelper: 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); } }
以上就已经配置完成了