【Spring Boot】Sping Boot与Mybatis的集成例子

这里我直接把Spring Boot集成了TKMyBatis，在实际项目使用使用非常方便，不需要写常用的增删改查接口。

项目依赖

<parent>
        <groupId>org.spring work.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.1.RELEASE</version>
    </parent>
    
    <modelVersion>4.0.0</modelVersion>

    <artifactId>mybatis-springboot</artifactId>

    <dependencies>

        <dependency>
            <groupId>org.spring work.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.spring work.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>

        <!-- Test -->
        <dependency>
            <groupId>org.spring work.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>

        <!--mapper-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>1.2.4</version>
        </dependency>

        <!--pagehelper-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.6</version>
        </dependency>

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

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.spring work.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

config的配置

package top.yuyufeng.demo.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.spring work.beans.factory.annotation.Autowired;
import org.spring work.beans.factory.annotation.Qualifier;
import org.spring work.boot.context.properties.EnableConfigurationProperties;
import org.spring work.context.annotation.Bean;
import org.spring work.context.annotation.Configuration;
import org.spring work.core.io.ClassPathResource;
import org.spring work.core.io.Resource;
import org.spring work.core.io.support.PathMatchingResourcePatternResolver;
import org.spring work.jdbc.datasource.DataSourceTransactionManager;
import org.spring work.transaction.PlatformTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
import top.yuyufeng.demo.config.properties.DruidProperties;

import javax.sql.DataSource;

/**
 * @author yuyufeng
 */
@Configuration
@EnableConfigurationProperties(DruidProperties.class)
@MapperScan( Packages = {\"top.yuyufeng.demo.mapper\"})
public class MybatisConfig {

    @Autowired
   private DruidProperties druidProperties;

    @Bean
    public DruidDataSource dataSource() {
        DruidDataSource dataSource = new DruidDataSource();
        druidProperties.config(dataSource);
        return dataSource;
    }

    @Bean
    public PlatformTransactionManager txManager(DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = \"sqlSessionFactory\")
    public SqlSessionFactory sqlSessionFactory(@Qualifier(\"dataSource\") DataSource dataSource)
            throws Exception {
        final SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources(\"mappers/*. \"));
        Resource configLocation = new ClassPathResource(\"conf/mybatis-config. \");
        sqlSessionFactoryBean.setConfigLocation(configLocation);
        return sqlSessionFactoryBean.get ();
    }

}

因为项目代码较多，这里直接给出项目地址了：
https://github.com/yuyufeng1994/mydemo/tree/master/jdbc/mybatis-springboot