java 对象池 实现_java设计模式之实现对象池模式示例分享

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class JDBCConnectionPool extends ObjectPool {

private String url, usr, pwd;

public JDBCConnectionPool(String driver, String url, String usr, String pwd) {

super();

// 加载对应的数据库驱动

try {

Class.forName(driver).newInstance();

}

catch(Exception e) {

e.printStackTrace();

}

this.url = url;

this.usr = usr;

this.pwd = pwd;

}

@Override

protected Connection create() {

try {

return DriverManager.getConnection(url, usr, pwd);

}

catch(SQLException e) {

e.printStackTrace();

}

return null;

}

@Override

public boolean validate(Connection o) {

try {

return o.isClosed();

}

catch(SQLException e) {

e.printStackTrace();

}

return false;

}

@Override

public void expire(Connection o) {

try {

o.close();

}

catch(SQLException e) {

e.printStackTrace();

}

finally {

o = null;

}

}

public static void main(String[] args) {

JDBCConnectionPool dbConnPool = new JDBCConnectionPool("com.mysql.jdbc.Driver", "jdbc:mysql://127.0.0.1:3306/test", "root", "123");

// 获取数据库连接对象

Connection conn = dbConnPool.checkOut();

// 使用数据库连接对象

// ...

// 释放数据库连接对象

dbConnPool.checkIn(conn);

}

}