C3P0链接数据库

1. package com.test.jdbc.util;  
2.   
3. import java.sql.Connection;  
4. import java.sql.PreparedStatement;  
5. import java.sql.ResultSet;  
6. import java.sql.SQLException;  
7. import javax.sql.DataSource;  
8. import com.mchange.v2.c3p0.ComboPooledDataSource;  
9. public final class JdbcUtil {  
10.     private static ComboPooledDataSource dataSource;  
11.     static {  
12.         ds = new ComboPooledDataSource();  
13.     }  
14.     // 取得链接  
15.     public static Connection getMySqlConnection() throws Exception {  
16.         return ds.getConnection();  
17.     }  
18.   }

c3p0-config.xml

jar文件：c3p0-0.9.2.jar

[html]  view plain  copy

1. <?xml version="1.0" encoding="UTF-8"?>  
2. <c3p0-config>  
3.     <default-config>  
4.         <property name="driverClass">com.mysql.jdbc.Driver</property>  
5.         <property name="user">root</property>  
6.         <property name="password">root</property>
7.         <property name="jdbcUrl">
8.              <![CDATA[ jdbc:mysql://localhost:3306/wedding?useUnicode=true&characterEncoding=UTF8&useSSL=false&allowPublicKeyRetrieval=true  ]]
9.          </property>
10. 
     
11.     </default-config>  
12. </c3p0-config>