First create the C3P0 data source class
PackageCom.example.demo.config;ImportJavax.sql.DataSource;ImportOrg.mybatis.spring.SqlSessionFactoryBean;ImportOrg.springframework.beans.factory.annotation.Qualifier;ImportOrg.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;Importorg.springframework.boot.context.properties.ConfigurationProperties;ImportOrg.springframework.context.annotation.Bean;Importorg.springframework.context.annotation.Configuration;Importorg.springframework.context.annotation.Primary; @Configuration Public classc3p0datasourceconfig {@Bean (name= "DataSource") @Qualifier (value= "DataSource")//qualifier descriptors can be injected in addition to names, but finer-grained control over how to select candidates@Primary//distinguish the primary data source with @primary@ConfigurationProperties (prefix= "c3p0")//attribute value in the specified configuration file with prefix c3p0 PublicDataSource DataSource () {returnDatasourcebuilder.create (). Type (Com.mchange.v2.c3p0.ComboPooledDataSource.class). build ();//Create a data source } /*** Return to Sqlsessionfactory*/@Bean PublicSqlsessionfactorybean Sqlsessionfactorybean () {Sqlsessionfactorybean sqlsessionfactory=NewSqlsessionfactorybean (); Sqlsessionfactory.setdatasource (DataSource ()); returnsqlsessionfactory; }}
Then configure Application.properties
C3p0.jdbcurl=jdbc:mysql:///testcrm?characterencoding=utf8c3p0.user=Rootc3p0.password =123c3p0.driverclass=com.mysql.jdbc.driver
Integration of Springboot and C3P0