尚硅谷之JDBC

<?xml version="1.0" encoding="UTF-8"?>

<c3p0-config>

<named-config name="helloc3p0">

<!-- 指定连接数据源的基本属性 -->

<property name="user">root</property>

<property name="password">root</property>

<property name="driverClass">com.mysql.jdbc.Driver</property>

<property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>

<!-- 若数据库中连接数不足时, 一次向数据库服务器申请多少个连接 -->

<property name="acquireIncrement">5</property>

<!-- 初始化数据库连接池时连接的数量 -->

<property name="initialPoolSize">5</property>

<!-- 数据库连接池中的最小的数据库连接数 -->

<property name="minPoolSize">5</property>

<!-- 数据库连接池中的最大的数据库连接数 -->

<property name="maxPoolSize">10</property>

</named-config>

</c3p0-config>

package com.jdbc.datasource;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class TestC3P02 {

public static void main(String[] args)throws Exception {

DataSource dataSource = new ComboPooledDataSource("helloc3p0");  

System.out.println(dataSource.getConnection());

}

}

package com.atguigu.utils;

import java.sql.Connection;

import java.sql.SQLException;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3p0Utils {

//创建数据源，用的是c3p0-config.xml文件中<default-config>

private static ComboPooledDataSource dataSource = new ComboPooledDataSource();

//获取数据源对象

public static ComboPooledDataSource getDataSource() {

return dataSource;

}

//获取连接

public static Connection getConnection() throws SQLException{

return dataSource.getConnection();

}

}