Springboot整合c3p0和mybatis

1.新建springboot项目

 2.打开项目列表，找到pom.xml文件，导入mybatis,c3p0,mysql依赖文件

粘贴以下内容至dependencies标签内

    mysql
    mysql-connector-java


    org.mybatis
    mybatis
    3.4.1


    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    2.1.2


    com.mchange
    c3p0
    0.9.5


    org.mybatis
    mybatis
    3.4.1


    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    2.1.2


    com.mchange
    c3p0
    0.9.5


    org.projectlombok
    lombok

3.在src/main/resources目录下建立application-c3p0.propertis文件内容如下

spring.datasource.c3p0.driverClass=com.mysql.cj.jdbc.Driver
spring.datasource.c3p0.jdbcUrl=jdbc:mysql://localhost:3306/数据库名?serverTimezone=Asia/Shanghai&useSSL=false&zeroDateTimeBehavior=convertToNull&useLegacyDatetimeCode=false
spring.datasource.c3p0.user=用户名
spring.datasource.c3p0.password=密码

spring.datasource.c3p0.initialPoolSize=5
spring.datasource.c3p0.minPoolSize=5
spring.datasource.c3p0.maxPoolSize=10
spring.datasource.c3p0.acquireIncrement=5

4.在src/main/resources目录下建立mybatis-config.xml文件内容如下

5.在application.propertis文件中添加

spring.profiles.active=c3p0
mybatis.mapperLocations=classpath:mappers*.xml
    
    true


    src/main/resources
    
        ***.properties
    
    true

8.建立你的实体类包，mapper类的包，例如下

 这里切记，mapper包里面的**.xml和**接口的**要一致，否则会org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)