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

朴灿烈づ我的快乐病毒、 2022-04-03 08:00 164阅读 0赞

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

### 项目依赖 ###

<parent>
            <groupId>org.springframework.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.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper-spring-boot-starter</artifactId>
                <version>1.2.4</version>
            </dependency>
    
            
            <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.springframework.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.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.boot.context.properties.EnableConfigurationProperties;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.core.io.ClassPathResource;
    import org.springframework.core.io.Resource;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.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(basePackages = {"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/*.xml"));
            Resource configLocation = new ClassPathResource("conf/mybatis-config.xml");
            sqlSessionFactoryBean.setConfigLocation(configLocation);
            return sqlSessionFactoryBean.getObject();
        }
    
    }

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

[https_github.com_yuyufeng1994_mydemo_tree_master_jdbc_mybatis-springboot]: https://github.com/yuyufeng1994/mydemo/tree/master/jdbc/mybatis-springboot