c3p0连接mysql数据库

导入mysql数据jar包 mysql-connector-java-5.1.49.jar 导入c3p0相关jar c3p0-0.9.2.1.jar mchange-commons-java-0.2.3.4.jar 导入配置文件 c3p0-config.xml 或者 c3p0.properties import java.sql.Connection; import java.sql.PreparedStatement; import org.junit.Test; import com.mchange.v2.c3p0.ComboPooledDataSource; public class C3P0_Demo { //创建连接池 private ComboPooledDataSource dataSource = new ComboPooledDataSource(); @Test public void deleteUser() throws Exception { //从连接池中获取连接 Connection con = dataSource.getConnection(); String sql ="delete from user where id =?"; //获取可执行对象 PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, 1); //执行 int row = ps.executeUpdate(); if(row>0) { System.out.println("删除成功"); }else { System.out.println("删除失败"); } //关闭资源 ps.close(); } }

c3p0-config.xml

<?xml version="1.0" encoding="UTF-8"?> <c3p0-config> <default-config> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql:///school</property> <property name="user">root</property> <property name="password">root</property> <property name="initialPoolSize">10</property> <property name="maxIdleTime">30</property> <property name="maxPoolSize">20</property> <property name="minPoolSize">5</property> <property name="maxStatements">200</property> </default-config> </c3p0-config>

c3p0.properties

#c3p0 c3p0.driverClass=com.mysql.jdbc.Driver c3p0.jdbcUrl=jdbc:mysql://localhost:3306/test0820?useUnicode=true&characterEncoding=utf-8 c3p0.user=root c3p0.password=root c3p0.acquireIncrement=3 c3p0.idleConnectionTestPeriod=60 c3p0.initialPoolSize=10 c3p0.maxIdleTime=60 c3p0.maxPoolSize=150 c3p0.maxStatements=100 c3p0.minPoolSize=5