MyBatis配置C3P0连接池

最新推荐文章于 2022-04-19 10:02:22 发布

mercies

最新推荐文章于 2022-04-19 10:02:22 发布

阅读量121

点赞数

分类专栏： MyBatis

本文链接：https://blog.csdn.net/mercies/article/details/110845836

版权

MyBatis 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

创建C3P0DataSourceFactory类

package com.mybatis.datasource;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;

/**
 * C3P0与MyBatis兼容使用的数据源共创类
 */
public class C3P0DataSourceFactory extends UnpooledDataSourceFactory {
    public C3P0DataSourceFactory(){
        this.dataSource = new ComboPooledDataSource();
    }
}

mybatis-config.xml进行配置

<dataSource type="com.mybatis.datasource.C3P0DataSourceFactory">
                <property name="driverClass" value="com.mysql.jdbc.Driver"/>
                <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/king?sueUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="user" value="root"/>
                <property name="password" value="root"/>
                <property name="initialPoolSize" value="5"/>
                <property name="maxPoolSize" value="20"/>
                <property name="minPoolSize" value="5"/>
            </dataSource>