DataSource ComboPooledDataSource

package utils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import javax.sql.DataSource;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DBUtil  {

	static Connection conn = null; // 数据库连接
	PreparedStatement pstmt = null; // 用于执行一条静态的 SQL 语句并获取它产生的结
	public static DataSource getDataSource() throws PropertyVetoException, SQLException
	{

		ComboPooledDataSource pool = new ComboPooledDataSource();
		
		pool.setUser("root");// 用户姓名
		pool.setPassword("root");// 用户密码
		pool.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/jsp_hunshabuy?useUnicode=true&characterEncoding=utf-8");// MySQL数据库连接url
		pool.setDriverClass("com.mysql.jdbc.Driver");

	
		return  pool;

	}
	public static Connection getConnection() throws SQLException {
		try {
			conn= getDataSource().getConnection();
		} catch (PropertyVetoException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
}