一、引入依赖

<!-- Spring-Mybatis -->

<dependency>

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

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

    <version>1.3.0</version>

 </dependency>

<!-- MySQL -->

<dependency>

    <groupId>mysql</groupId>

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

</dependency>

<dependency>

        <groupId>org.springframework.boot</groupId>

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

</dependency>

<!-- data source -->

<dependency>

    <groupId>com.alibaba</groupId>

    <artifactId>druid</artifactId>

    <version>1.1.6</version>

</dependency>

二、配置application.properties 

## 数据库配置

## 数据源

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

## 数据库连接

spring.datasource.url=jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=utf8

## 数据库用户名

spring.datasource.username=root

## 数据库连接密码

spring.datasource.password=123456

## 数据库连接驱动

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

## 配置监控统计拦截filters

spring.datasource.filters = stat

## 连接池最大使用连接数

spring.datasource.maxActive = 20

## 初始化连接大小

spring.datasource.initialSize = 3

## 获取连接最大等待时间

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

三、配置DruidConfig

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.support.http.StatViewServlet;

import com.alibaba.druid.support.http.WebStatFilter;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.boot.web.servlet.FilterRegistrationBean;

import org.springframework.boot.web.servlet.ServletRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.Primary;

import java.sql.SQLException;

/**

* Created by panxiang on 2017-06-25.

*/

@Configuration

public class DruidConfig {

    @Value("${spring.datasource.url}")

    private String dbUrl;

    @Value("${spring.datasource.username}")

    private String username;

    @Value("${spring.datasource.password}")

    private String password;

    @Value("${spring.datasource.driverClassName}")

    private String driverClassName;

    @Value("${spring.datasource.initialSize}")

    private int initialSize;

    @Value("${spring.datasource.minIdle}")

    private int minIdle;

    @Value("${spring.datasource.maxActive}")

    private int maxActive;

    @Value("${spring.datasource.maxWait}")

    private int maxWait;

    @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")

    private int timeBetweenEvictionRunsMillis;

    @Value("${spring.datasource.minEvictableIdleTimeMillis}")

    private int minEvictableIdleTimeMillis;

    @Value("${spring.datasource.validationQuery}")

    private String validationQuery;

    @Value("${spring.datasource.testWhileIdle}")

    private boolean testWhileIdle;

    @Value("${spring.datasource.testOnBorrow}")

    private boolean testOnBorrow;

    @Value("${spring.datasource.testOnReturn}")

    private boolean testOnReturn;

    @Value("${spring.datasource.poolPreparedStatements}")

    private boolean poolPreparedStatements;

    @Value("${spring.datasource.filters}")

    private String filters;

    @Bean

    public ServletRegistrationBean druidServlet() {

        ServletRegistrationBean reg = new ServletRegistrationBean();

        reg.setServlet(new StatViewServlet());

        reg.addUrlMappings("/druid/*");

        reg.addInitParameter("loginUsername", "admin");

        reg.addInitParameter("loginPassword", "123456");

        return reg;

    }

    @Bean

    public FilterRegistrationBean filterRegistrationBean() {

        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();

        filterRegistrationBean.setFilter(new WebStatFilter());

        filterRegistrationBean.addUrlPatterns("/*");

        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        filterRegistrationBean.addInitParameter("profileEnable", "true");

        filterRegistrationBean.addInitParameter("principalCookieName", "USER_COOKIE");

        filterRegistrationBean.addInitParameter("principalSessionName", "USER_SESSION");

        return filterRegistrationBean;

    }

    @Bean

    @Primary

    public DruidDataSource druidDataSource() {

        DruidDataSource datasource = new DruidDataSource();

        datasource.setUrl(this.dbUrl);

        datasource.setUsername(username);

        datasource.setPassword(password);

        datasource.setDriverClassName(driverClassName);

        datasource.setInitialSize(initialSize);

        datasource.setMinIdle(minIdle);

        datasource.setMaxActive(maxActive);

        datasource.setMaxWait(maxWait);

        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);

        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);

        datasource.setValidationQuery(validationQuery);

        datasource.setTestWhileIdle(testWhileIdle);

        datasource.setTestOnBorrow(testOnBorrow);

        datasource.setTestOnReturn(testOnReturn);

        datasource.setPoolPreparedStatements(poolPreparedStatements);

        try {

            datasource.setFilters(filters);

        } catch (SQLException e) {

        }

        return datasource;

    }

}

四、配置SessionFactory

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.SqlSessionFactoryBean;

import org.mybatis.spring.SqlSessionTemplate;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import org.springframework.transaction.PlatformTransactionManager;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import org.springframework.transaction.annotation.TransactionManagementConfigurer;

/**

* Created by panxiang on 2017-06-25.

*/

@Configuration

@EnableTransactionManagement

@MapperScan(basePackages = SessionFactoryConfig.PACKAGE)

public class SessionFactoryConfig implements TransactionManagementConfigurer {

    /**

    * mybatis 配置路径

    */

//  static final String MYBATIS_CONFIG = "mybatis-config.xml";

    static final String PACKAGE = "com.tool.springBoot.dao";

    static final String MAPPER_LOCATION = "classpath:mapper/*.xml";

    static final String TYPEALIAS_PACKAGE = "com.tool.springBoot.vo";

    @Autowired

    private DataSource dataSource;

    /**

    * 创建sqlSessionFactoryBean 实例

    * 并且设置configtion 如驼峰命名.等等

    * 设置mapper 映射路径

    * 设置datasource数据源

    *

    * @return

    * @throws Exception

    */

    @Bean(name = "sqlSessionFactory")

    public SqlSessionFactoryBean createSqlSessionFactoryBean() throws Exception {

        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();

        /** 设置mybatis configuration 扫描路径 */

//        sqlSessionFactoryBean.setConfigLocation(new ClassPathResource(MYBATIS_CONFIG));

        /** 设置datasource */

        sqlSessionFactoryBean.setDataSource(dataSource);

        /** 设置typeAlias 包扫描路径 */

        sqlSessionFactoryBean.setTypeAliasesPackage(TYPEALIAS_PACKAGE);

        /**设置map映射文件路径*/

        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()

                .getResources(SessionFactoryConfig.MAPPER_LOCATION));

        return sqlSessionFactoryBean;

    }

    @Bean

    public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {

        return new SqlSessionTemplate(sqlSessionFactory);

    }

    @Bean

    @Override

    public PlatformTransactionManager annotationDrivenTransactionManager() {

        return new DataSourceTransactionManager(dataSource);

    }

}

五、配置 mapper 的xml文件

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

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="com.tool.springBoot.dao.TestDao">

    <select id="findAll" resultType = "com.tool.springBoot.vo.StudentVO">

        select * from student;

    </select>

</mapper>

六、controller

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import com.tool.springBoot.service.TestService;

@Controller

public class TestController {

@Autowired

private TestService  testService;

@RequestMapping("/hello")

    public String index() {

        testService.testMybatis();

        return "hello";

    }

}

七、service

import com.tool.springBoot.vo.User;

public interface TestService {

        public String testMybatis();

}

@Component

public class TestServiceImpl implements TestService{

        @Autowired

        private TestDao  testDao;

    @Override

    public void testMybatis() {

        testDao.findAll();

    }

}

八、dao

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.tool.springBoot.vo.StudentVO;

@Mapper

public interface TestDao {

        public List<StudentVO> findAll();

}