SpringBoot整合c3p0连接池+MyBatis

SpringBoot整合c3p0连接池+MyBatis

第一步:导入c3p0依赖和MyBatis依赖

 <dependency>
       <groupId>com.mchange</groupId>
       <artifactId>c3p0</artifactId>
       <version>0.9.5.5</version>
 </dependency>
 <dependency>
       <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>2.1.3</version>
</dependency>

第二步:在application.properties/application.yml配置文件中配置数据源信息

spring:
  datasource:
 	 #Oracle数据库
    jdbcUrl: jdbc:oracle:thin:@localhost(或者是数据库服务器的ip):1521:orcl
    user: xxxxxx
    password: ******
    driverClass: oracle.jdbc.driver.OracleDriver
    type: com.mchange.v2.c3p0.ComboPooledDataSource
    acquireIncrement: 11
    acquireRetryAttempts: 7
    

第三步:创建DataSourceConfig配置类配置dataSource

@Configuration
public class DataSourceConfig {
    @Bean
    @Primary//自动装配时当出现多个Bean候选者时，被注解为@Primary的Bean将作为首选者，否则将抛出异常
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource dataSource(){
        return DataSourceBuilder.create().type(ComboPooledDataSource.class).build();
    }
}

第四步:在启动类中添加MapperScan注解

@MapperScan("com.zl.mapper")
//扫描mapper接口与配置文件,如果配置文件和接口不在同一个包下,要在配置文件中配置xml路径

第五步:在配置文件中添加MyBatis配置

mybatis:
  #扫描mapper配置文件(当mapper文件与接口不在同一个包下时使用)
  mapper-locations: classpath:mapper/*Mapper.xml
  #打印mybatis日志
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl