36.自己写的一个开源连接池功能_连接池开源-优快云博客

本文链接：https://blog.youkuaiyun.com/xujainxing/article/details/12259073

本文介绍了一个简单的数据库连接池实现方案，使用Java语言并通过LinkedList管理连接。该连接池能够初始化一定数量的连接，并支持获取和释放连接操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class ConnectionPool {
	private LinkedList<Connection> pool;
	private static String url = "jdbc:mysql://w.rdc.sae.sina.com.cn:3307/app_imu2b";
	private static String saeAccessKey = null;
	private static String saeSecretKey = null;
	private static int maxCount = 200;
	private static int currentCount = 50; // 因为初始的就是50个
	public ConnectionPool() {
		pool = new LinkedList<Connection>();
		saeAccessKey = SaeUserInfo.getAccessKey();
		saeSecretKey = SaeUserInfo.getSecretKey();
		for (int i = 0; i < 50; i++) {
			try {
				Connection conn;
				conn = DriverManager.getConnection(url, saeAccessKey,
						saeSecretKey);
				pool.addLast(conn);
			} catch (SQLException e) {
				throw new InitializeErrorException(e.getMessage());
			}

		}

	}
	public Connection getConnection() {
		synchronized (ConnectionPool.class) {
			Connection conn = null;
			if (pool.size() > 0)
				return pool.removeFirst();
			else if (currentCount < maxCount) {
				try {
					conn = DriverManager.getConnection(url, saeAccessKey,
							saeSecretKey);
					currentCount++;
					pool.addLast(conn);
				} catch (SQLException e) {

				}
				return pool.removeFirst();
			} else {
				throw new ExceptionInInitializerError("SQL连接已经是最大值");
			}

		}

	}
	public void free(Connection conn) {
		pool.addFirst(conn);
	}
}