c3p0使用記錄

為了使c3p0方便維護,需要在src目錄下創建 c3p0-config.xml

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

<c3p0-config>
  <default-config>
    <property name="user">root</property>
    <property name="password">root</property>
    <property name="jdbcUrl">jdbc:mysql://127.0.0.1:3306/day20</property>
    <property name="driverClass">com.mysql.jdbc.Driver</property>
  </default-config>
</c3p0-config>

使用c3p0

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JdbcUtils {
private static ComboPooledDataSource ds;
static {
    ds = new ComboPooledDataSource();
}

public static DataSource getDataSource(){
    return ds;
}
}