java 连接池代码_需要代码在java中创建连接池

需要在java中创建连接池的代码？

我们如何确保连接池不返回已经在使用的同一对象？

如果客户端在从连接池中取出连接后关闭连接，会发生什么？

更新1：

我想在Simple Java术语中创建它，并希望了解它在多线程环境中的工作原理。我的意思是哪些方法将被同步，哪些不是。此类也将是一个公共类？如果是，那么任何人都可以访问此类并重新初始化连接池？

更新2：

我有一些代码如下。但我不知道如何“关闭来自池的连接将其返回到池，它不会物理关闭连接。

也是我不明白这个“因为如果一个连接已经从池中借用，还没有返回，它不是”可用“，不能重新分配到池的另一个客户端。

import java.util.*;

import java.sql.*;

class ConnectionPoolManager

{

String databaseUrl = "jdbc:mysql://localhost:3306/myDatabase";

String userName = "userName";

String password = "userPass";

Vector connectionPool = new Vector();

public ConnectionPoolManager()

{

initialize();

}

public ConnectionPoolManager(

//String databaseName,

String databaseUrl,

String userName,

String password

)

{

this.databaseUrl = databaseUrl;

this.userName = userName;

this.password = password;

initialize();

}

private void initialize()

{

//Here we can initialize all the information that we need

initializeConnectionPool();

}

private void initializeConnectionPool()

{

while(!checkIfConnectionPoolIsFull())

{

System.out.println("Connection Pool is NOT full. Proceeding with adding new connections");

//Adding new connection instance until the pool is full

connectionPool.addElement(createNewConnectionForPool());

}

System.out.println("Connection Pool is full.");

}

private synchronized boolean checkIfConnectionPoolIsFull()

{

final int MAX_POOL_SIZE = 5;

//Check if the pool size

if(connectionPool.size() < 5)

{

return false;

}

return true;

}

//Creating a connection

private Connection createNewConnectionForPool()

{

Connection connection = null;

try

{

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection(databaseUrl, userName, password);

System.out.println("Connection: "+connection);

}

catch(SQLException sqle)

{

System.err.println("SQLException: "+sqle);

return null;

}

catch(ClassNotFoundException cnfe)

{

System.err.println("ClassNotFoundException: "+cnfe);

return null;

}

return connection;

}

public synchronized Connection getConnectionFromPool()

{

Connection connection = null;

//Check if there is a connection available. There are times when all the connections in the pool may be used up

if(connectionPool.size() > 0)

{

connection = (Connection) connectionPool.firstElement();

connectionPool.removeElementAt(0);

}

//Giving away the connection from the connection pool

return connection;

}

public synchronized void returnConnectionToPool(Connection connection)

{

//Adding the connection from the client back to the connection pool

connectionPool.addElement(connection);

}

public static void main(String args[])

{

ConnectionPoolManager ConnectionPoolManager = new ConnectionPoolManager();

}

}