springboot整合mybatis-plus手动配置

1、添加依赖

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

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

        <!--mybatisplus融合-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
            <exclusions>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-autoconfigure</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-starter-jdbc</artifactId>
                </exclusion>
            </exclusions>
        </dependency>            

2、添加代码开发

package com.goldcard.lifecycle.dao.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

/**
 * db数据源配置
 *
 * @author xiaozhilei
 */

@Configuration
@MapperScan(basePackages = "com.dao.mapper", sqlSessionFactoryRef = "dbSqlSessionFactory")
@Slf4j
public class DataSourceConfig {

    @Value("${spring.datasource.db.url}")
    private String dbUrl;

    @Value("${spring.datasource.db.password}")
    private String password;

    @Value("${spring.datasource.db.username}")
    private String username;



    /**
     * 包名
     */
    private static final  String TypeAliasesPackage = "com.dao.domain";

    /**
     * mapper扫面包路径
     */
    private static  final String MapperLocations = "classpath*:mapper/*.xml";

    @Primary
    @Bean("dbDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.db")
    public DataSource getDbDataSource() {
        log.info("数据库环境配置地址.{}",dbUrl);
        log.info("数据库环境配置用户名.{}",username);
        log.info("数据库环境配置密码.{}",password);
        return new DruidDataSource();
        //return DataSourceBuilder.create().build();
    }

    @Primary
    @Bean("dbSqlSessionFactory")
    public SqlSessionFactory dbSqlSessionFactory(@Qualifier("dbDataSource") DataSource dataSource) throws Exception {
        //SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setTypeAliasesPackage(TypeAliasesPackage);
        bean.setConfigLocation(new PathMatchingResourcePatternResolver().getResource("classpath:/config/mybatis-config.xml"));
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MapperLocations));
        return bean.getObject();
    }



    @Primary
    @Bean("dbSqlSessionTemplate")
    public SqlSessionTemplate dbSqlSessionTemplate(@Qualifier("dbSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

3 添加相关依赖

在：resources目录下，创建：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" />
    </settings>
</configuration>