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

//localhost:3306/test

username = root

password = 123456

模拟数据连接池

package

urce;

import

tream;

import

riter;

import

tionHandler;

import

import

import

tion;

import

Manager;

import

eption;

import

List;

import

ties;

import

urce;

import

urce;

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(

< br>cn/langzi/jdbc/DataSource/DBConnectio

ties

Properties prop =

new

Properties();

(in);

e(perty(

driverClass

url = perty(

url

username = perty(

username

password = perty(

password

}

catch

(Exception e) {

throw

new

ExceptionInInitializerError(e);

}

}

private

static

DataSourcePool pool =

new

DataSourcePool();

//

创建对象就初始化

size

个数据库连接< /p>

private

DataSourcePool(){

for< /p>

(

int

i=0;i

try

{

Connection conn = nection(url, username,

password);

n(conn);

(conn);

}

catch

(SQLException e) {

tackTrace();

}

}