四种连接数据库的方式(DataSource,DriverManager,c3p0,DBCP)

四种连接数据库的方法（DriverManager、Dat aSource子类、DBCP、c3p0）

2010-04-07 20:58:40| 分类：JAVA基础|字号订阅

一、环境

1、数据库驱动jar文件

2、DBCP方法

Commons-dbcp.jar：连接池的实现

Commons-pool.jar：连接池实现的依赖库

资源文件

3、c3p0方法：

c3p0-0.9.1.2.jar

配置文件：c3p0-config.xml

二、连接操作

1.DriverManager方法;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBConnection {

private static String driverClass = "com.mysql.jdbc.Driver";

private static String url = "jdbc:mysql://localhost:3306/test";

private static String username = "root";

private static String password = "123456";

private static Connection conn = null;

static{

try {

//注册驱动

// 不要把conn = DriverManager.getConnection(url, username, password);

//放在这里。防止所有用户都用一个Connection

Class.forName(driverClass);

} catch (Exception e) {

throw new RuntimeException(e);

}

}

public static Connection getConnection() throws SQLException{

conn = DriverManager.getConnection(url, username, password);

return conn;

}

}

2.使用DataSource子类方法;

资源文件DBConnection.properties

driverClass = com.mysql.jdbc.Driver

url = jdbc:mysql://localhost:3306/test

username = root

password = 123456

模拟数据连接池DataSourcePool.java

package https://www.360docs.net/doc/d22984365.html,ngzi.jdbc.DataSource;

import java.io.InputStream;

import java.io.PrintWriter;

import https://www.360docs.net/doc/d22984365.html,ng.reflect.InvocationHandler;

import https://www.360docs.net/doc/d22984365.html,ng.reflect.Method;

import https://www.360docs.net/doc/d22984365.html,ng.reflect.Proxy;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.LinkedList;

import java.util.Properties;

import javax.sql.DataSource;

import javax.sql.DataSource;

public class DataSourcePool implements DataSource {

private static String url = null;

private static String username = null;

private static String password = null;

private static int size = 10;

private static LinkedList list = new

LinkedList();

static{

try {

InputStream in = DataSourcePool.class.getClassLoader()

.getResourceAsStream("cn/langzi/jdbc/DataSource/DBConnectio n.properties");

Properties prop = new Properties();

prop.load(in);

Class.forName(prop.getProperty("driverClass"));

url = prop.getProperty("url");

username = prop.getProperty("username");

password = prop.getProperty("password");

} catch (Exception e) {

throw new ExceptionInInitializerError(e);

}

}

private static DataSourcePool pool = new DataSourcePool();

//创建对象就初始化size个数据库连接

private DataSourcePool(){

for(int i=0;i

try {

Connection conn = DriverManager.getConnection(url, username, password);

System.out.println(conn);

list.add(conn);

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static DataSourcePool getInstance(){

return pool;

}

@Override

public Connection getConnection() throws SQLException {

if(list.size()>0){

//取到连接，即从list中弹出一个Connection 连接

final Connection conn = list.pop();

//动态代理，返回一个代理对象

return (Connection)

Proxy.newProxyInstance(DataSourcePool.class.getClassLoade(), conn.getClass().getInterfaces(), new InvocationHandler(){

public Object invoke(Object proxy, Method method, Object[] args)

throws Throwable {

//如果Connection调用的是close方法就将连接返回给数据连接池

if(method.getName().equals("close")){

list.push(conn);

return null;

}

return method.invoke(conn, args);

}

});

}

//连接用完

throw new RuntimeException("对不起，服务器繁忙！！！"); }

@Override

public Connection getConnection(String username, String password)throws SQLException {

// TODO Auto-generated method stub

return null;

}

@Override

public PrintWriter getLogWriter() throws SQLException { // TODO Auto-generated method stub

return null;

}

@Override

public int getLoginTimeout() throws SQLException {

// TODO Auto-generated method stub

return 0;

}

@Override

public void setLogWriter(PrintWriter out) throws SQLException { // TODO Auto-generated method stub

}

@Override

public void setLoginTimeout(int seconds) throws SQLException {

// TODO Auto-generated method stub

}

@Override

public boolean isWrapperFor(Class iface) throws SQLException { // TODO Auto-generated method stub

return false;

}

@Override

public T unwrap(Class iface) throws SQLException {

// TODO Auto-generated method stub

return null;

}

}

package https://www.360docs.net/doc/d22984365.html,ngzi.jdbc.DataSource;

import java.sql.Connection;

import java.sql.SQLException;

public class DBConnection {

public static Connection getConnection() throws SQLException{

Connection conn =

DataSourcePool.getInstance().getConnection();

return conn;

}

}

DBCP方法：

资源文件：dbcpconfig.properties

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/test

username=root

password=123456

initialSize=10

maxActive=50

maxIdle=20

minIdle=5

maxWait=60000

连接数据库：

package https://www.360docs.net/doc/d22984365.html,ngzi.jdbc.DBCP;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.Properties;

import javax.sql.DataSource;

import https://www.360docs.net/doc/d22984365.html,mons.dbcp.BasicDataSourceFactory;

public class DBConnection {

private static DataSource dataSource = null;

static {

try {

//获取资源文件

InputStream in =

DBConnection.class.getClassLoader().getResourceAsStream("cn/langzi/jd bc/DBCP/dbcpconfig.properties");

Properties properties = new Properties();

//加载资源文件

properties.load(in);

//建立数据工厂

BasicDataSourceFactory dataSourceFactory = new BasicDataSourceFactory();

dataSource = dataSourceFactory.createDataSource(properties);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static Connection getConnection() throws SQLException{

return dataSource.getConnection();

}

}

c3p0方法：

配置文件：c3p0-config.xml

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test root

123456

5

10

10

20

0

5

1

1

1

5

50

连接数据库：

package https://www.360docs.net/doc/d22984365.html,ngzi.jdbc.c3p0;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.sql.DataSource;

import https://www.360docs.net/doc/d22984365.html,boPooledDataSource;

public class DbConnection {

private static DataSource dataSource;

static{

dataSource = new ComboPooledDataSource("userApp");

}

public static Connection getConnectioon() throws SQLException{ return dataSource.getConnection();

}

}