spring boot 集成mybatis

1.引入依赖

<!-- 集成mybatis start -->

<dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

<version>1.3.2</version>

</dependency>

 

<!-- mysql 链接驱动 start -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.38</version>

</dependency>

<!-- mysql 链接驱动 end -->

 

<!-- 添加连接池druid支持 start -->

<dependency>

<groupId>com.alibaba</groupId>

<artifactId>druid</artifactId>

<version>1.0.16</version>

</dependency>

<!-- 添加连接池druid支持 end -->

 

<!-- 分页插件pagehelper支持 start -->

<dependency>

<groupId>com.github.pagehelper</groupId>

<artifactId>pagehelper</artifactId>

<version>5.0.0</version>

</dependency>

<!-- 分页插件pagehelper支持 end -->

<!-- 集成mybatis end -->

 

2.写入application.properties配置文件

##使用druid数据源

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

spring.datasource.filters=stat

spring.datasource.maxActive=20

spring.datasource.initialSize=1

spring.datasource.maxWait=60000

spring.datasource.minIdle=1

spring.datasource.timeBetweenEvictionRunsMillis=60000

spring.datasource.minEvictableIdleTimeMillis=300000

spring.datasource.validationQuery=select 'x'

spring.datasource.testWhileIdle=true

spring.datasource.testOnBorrow=false

spring.datasource.testOnReturn=false

spring.datasource.poolPreparedStatements=true

spring.datasource.maxOpenPreparedStatements=20

##数据库驱动

spring.datasource.driverClassName=com.mysql.jdbc.Driver

spring.datasource.url=jdbc:mysql://localhost:3306/db

spring.datasource.username=root

spring.datasource.password=123456

 

##Mybatis配置

##注意：一定要对应mapper映射xml文件的所在路径

mybatis.mapper-locations=classpath:mappers/*.xml

##注意：对应实体类的路径

mybatis.type-aliases-package=com.pojo

##此处配置mybatis的配置文件

mybatis.config-location = classpath:mybatis-config.xml

 

编写mybatis-config.xml mybatis配置文件文件

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<settings>

<!-- 驼峰命名 -->

<setting name="mapUnderscoreToCamelCase" value="true"/>

<!-- 使用log4j打印日志 -->

<setting name="logImpl" value="LOG4J"/>

</settings>

<!-- pagehelper插件 -->

<plugins>

<plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>

</plugins>

</configuration>

 

3.编写代码Mapper配置文件,接口 service接口,实现类 controller等...

需要有一点注意 在启动入口需要加入@MapperScan注解 扫描Mapper接口

 

 

@EnableAutoConfiguration

@ComponentScan(basePackages = "com")

//将项目中对应的mapper类的路径加进来就可以了

@MapperScan("com.mapper")

public class App {

public static void main(String [] args) {

SpringApplication.run(App.class,args) ;

}

}