dbcp、c3p0、druid连接池的简单配置

最新推荐文章于 2020-09-09 13:06:12 发布

Kyle Stamos

最新推荐文章于 2020-09-09 13:06:12 发布

阅读量314

点赞数

分类专栏：连接池文章标签：连接池

连接池专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
        </dependency>

        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
        </dependency>

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

 <bean class="org.apache.commons.dbcp2.BasicDataSource" id="basicDataSource">
        <property name="url" value="jdbc:mysql://172.28.128.5:3306/spring_day03"/>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="username" value="ttsc"/>
        <property name="password" value="redhat"/>
        <property name="connectionProperties" value="useUnicode=yes;characterEncoding=utf8"/>
    </bean>

    <bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="comboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="user" value="ttsc"/>
        <property name="password" value="redhat"/>
        <property name="jdbcUrl"
                  value="jdbc:mysql://172.28.128.5:3306/spring_day03?useUnicode=true&amp;characterEncoding=utf-8"/>
    </bean>

    <bean class="com.alibaba.druid.pool.DruidDataSource" id="druidDataSource" destroy-method="close">
        <property name="url" value="jdbc:mysql://172.28.128.5:3306/spring_day03"/>
        <property name="username" value="ttsc"/>
        <property name="password" value="redhat"/>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="connectionProperties" value="useUnicode=yes;characterEncoding=utf8"/>
    </bean>