spring boot 集成myBatis的session

package com.starfleet.common.config;

import java.util.Properties;

import javax.sql.DataSource;

import org.apache.ibatis.plugin.Interceptor;

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.context.annotation.ImportResource;

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

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

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import org.springframework.transaction.PlatformTransactionManager;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import org.springframework.transaction.annotation.TransactionManagementConfigurer;

import com.starfleet.common.database.DataPageHelper;

@Configuration

@ImportResource(locations = { "classpath:druid_aop.xml" })

@MapperScan(basePackages = { "com.starfleet.sys.mapper.galaxy", "com.starfleet.common.mapper" })

@EnableTransactionManagement

public class AppConfig implements TransactionManagementConfigurer {

    @Autowired

    private DataSource dataSource;

    //增加sqlSessionFactory

    @Bean(name = "sqlSessionFactory")

    public SqlSessionFactory sqlSessionFactoryBean() {

        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();

        bean.setDataSource(dataSource);

        //分页插件  

        DataPageHelper pageHelper = new DataPageHelper();  

        Properties props = new Properties();  

        props.setProperty("supportMethodsArguments", "true");  

        props.setProperty("returnPageInfo", "check");  

        props.setProperty("params", "count=countSql");  

        //props.setProperty("dialect", "com.starfleet.common.database.MySqlAuthDialect");

        props.setProperty("dialect", "mysql");

        pageHelper.setProperties(props);

        //添加插件  

        bean.setPlugins(new Interceptor[]{pageHelper});

        try {

            ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();  

            bean.setConfigLocation(resolver.getResource("classpath:mybatis-config.xml"));

            bean.setMapperLocations(resolver.getResources("classpath*:mapper/**/*Mapper.xml"));

            return bean.getObject();

        } catch (Exception e) {

            e.printStackTrace();

            throw new RuntimeException(e);

        }

    }

    @Override

    public PlatformTransactionManager annotationDrivenTransactionManager() {

        return new DataSourceTransactionManager(dataSource);

    }

    @Bean

    public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {

        return new SqlSessionTemplate(sqlSessionFactory);

    }

    

}