package com.huawei.db;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Vector;
public abstract class JdbcPool implements ConnectionPool,Runnable
{
protected String driver, url, username, password;
private int maxConnections;
private boolean waitIfBusy;
private Vector<Connection> availableConnections, busyConnections;
private boolean connectionPending = false;
public JdbcPool (
String driver, String url,
String username, String password,
int initialConnections,
int maxConnections,
boolean waitIfBusy) throws SQLException
{
this.driver = driver;
this.url = url;
this.username = username;
this.password = password;
this.maxConnections = maxConnections;
this.waitIfBusy = waitIfBusy;
if (initialConnections > maxConnections)
{
initialConnections = maxConnections;
}
availableConnections = new Vector<Connection>(initialConnections);
busyConnections = new Vector<Connection>();
for(int i=0; i<initialConnections; i++)
{
availableConnections.addElement(makeNewConnection());
}
}
/*
*明确地建立一连接。当ConnectionPool初始化时被在前台调用
*而当ConnectionPool在运行时,该函数在后台线程中被调用
*/
protected Connection makeNewConnection() throws SQLException
{
try
{
// Load database driver if not already loaded
DriverManager.registerDriver((Driver)Class.forName(driver).newInstance());
Connection connection =
DriverManager.getConnection(url, username, password);
return(connection);
}
catch(ClassNotFoundException cnfe)
{
// Simplify try/catch blocks of people using this by
// throwing only one exception type.
throw new SQLException("Can't find class for driver: " +
driver);
}
catch(Exception e)
{
throw new SQLException("some error getConnection="+e.toString());
}
}
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Vector;
public abstract class JdbcPool implements ConnectionPool,Runnable
{
protected String driver, url, username, password;
private int maxConnections;
private boolean waitIfBusy;
private Vector<Connection> availableConnections, busyConnections;
private boolean connectionPending = false;
public JdbcPool (
String driver, String url,
String username, String password,
int initialConnections,
int maxConnections,
boolean waitIfBusy) throws SQLException
{
this.driver = driver;
this.url = url;
this.username = username;
this.password = password;
this.maxConnections = maxConnections;
this.waitIfBusy = waitIfBusy;
if (initialConnections > maxConnections)
{
initialConnections = maxConnections;
}
availableConnections = new Vector<Connection>(initialConnections);
busyConnections = new Vector<Connection>();
for(int i=0; i<initialConnections; i++)
{
availableConnections.addElement(makeNewConnection());
}
}
/*
*明确地建立一连接。当ConnectionPool初始化时被在前台调用
*而当ConnectionPool在运行时,该函数在后台线程中被调用
*/
protected Connection makeNewConnection() throws SQLException
{
try
{
// Load database driver if not already loaded
DriverManager.registerDriver((Driver)Class.forName(driver).newInstance());
Connection connection =
DriverManager.getConnection(url, username, password);
return(connection);
}
catch(ClassNotFoundException cnfe)
{
// Simplify try/catch blocks of people using this by
// throwing only one exception type.
throw new SQLException("Can't find class for driver: " +
driver);
}
catch(Exception e)
{
throw new SQLException("some error getConnection="+e.toString());
}
}