// Connect to Bean
ConnectionBean.java
Package com.pool;
Import java.io.serializable; import java.sql. *;
Public class connectBean implements java.io.serializable {private connection vconnection = null; private boolean buseestate = false;
public ConnectionBean () {} public ConnectionBean (Connection connection) {if (connection = null!) {vConnection = connection;}} public Connection getConnection () {return vConnection;} public void setConnection (Connection connection) {vConnection = connection;} public void setUseState (boolean bUseState) {this.bUseState = bUseState;} public boolean getUseState () {return bUseState;} public void close () {try {vConnection.close ();} catch (SQLException sqlException) {System.err. PRINTLN (Sqlexception.getMessage ());}}}
//connection pool
PoolBean.java
Package com.pool;
Import java.io.serializable; import java.sql. *; import java.util. *; import com.pool.connectionBean
public class PoolBean implements java.io.Serializable {private String strDriver = null; private String strURL = null; private int iSize = 0; private String strUserName = ""; private String strPassword = ""; private ConnectionBean vConnectionBean = null; private Vector VPOOL = NULL;
public PoolBean () {} public void setDriver (String strDriver) {if (strDriver = null!) {this.strDriver = strDriver;}} public String getDriver () {return strDriver;} public void setURL (String strURL) {if ( Strurl! = null) {this.strurl = StrURL;}} public string getURL () {Return Strull;} public void setsize (int isize) {if (isize> 1) {this.isize = isize;}} public int Getsize () {return iSize;} public String getUserName () {return strUserName;} public void setUserName (String strUserName) {if (strUserName = null!) {this.strUserName = strUserName;}} public void setPassword (String strPassword) {if (strPassword = null!) {this.strPassword = strPassword;}} public String getPassword () {return strPassword;} public void setConnectionBean (ConnectionBean vConnectionBean) {if (vConnectionBean = null!) {this.vConnectionBean = vConnectionBean;}} public ConnectionBean getConnectionBean () throws exception {connection vconnection = getConnection (); ConnectionBean vconnectio nBean = new ConnectionBean (vConnection); vConnectionBean.setUseState (true); return vConnectionBean;} private Connection createConnection () throws Exception {Connection vConnection = null; vConnection = DriverManager.getConnection (strURL, strUserName, strPassword); return vConnection;} public Synchronized void initializePool () throws exception {if (strodr == null) {throw new exception ("No driver name!");} if (strurl == null) {throw new exception ("No URL!") } If (isize <1) {throw new exception ("Connection pool size is less than 1!");} Try {class.forname (striver); for (int IINDEX = 0; IIndex ) {Connection vConnection = createConnection (); if (vConnection = null) {ConnectionBean vConnectionBean = new ConnectionBean (vConnection);! AddConnection (vConnectionBean);}}} catch (Exception eException) {System.err.println (eException.getMessage ( )); throw new Exception (eException.getMessage ());}} private void addConnection (ConnectionBean vConnectionBean) {if (vPool == null) {vPool = new Vector (iSize);} vPool.addElement (vConnectionBean);} public synchronized void releaseConnection (Connection vConnection) {for (int iIndex = 0; iIndex iIndex
