简单的数据库连接池练习

来源：互联网发布：photoshop有没有mac版编辑：程序博客网时间：2024/04/30 14:03

JDBC.conf配置文件：

driverClassname=com.mysql.jdbc.Driverdb_url=jdbc:mysql://localhost:3306/everdbusername=rootpwd=rootpoolsize=10

连接池实现：

import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;import java.util.Vector;public class ConnectionPool {private Vector<Connection> pool;private String url;private String username;private String password;private String driverClassName;private int poolSize = 2;private static ConnectionPool instance = null;private ConnectionPool(){init();}private void init() {pool = new Vector<Connection>(poolSize);readConfig();addConnection();}private void addConnection() {Connection conn = null;for (int i = 0; i <= poolSize; i++){try {Class.forName(driverClassName);conn = DriverManager.getConnection(url, username, password);pool.add(conn);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}private void readConfig() {try {Properties ps = new Properties();String Path = System.getProperty("user.dir") + "\\WebContent\\conf\\JDBC.conf";FileInputStream fs = new FileInputStream(Path);ps.load(fs);fs.close();this.url = ps.getProperty("db_url");this.username = ps.getProperty("username");this.password = ps.getProperty("pwd");this.driverClassName = ps.getProperty("driverClassname");this.poolSize = Integer.parseInt(ps.getProperty("poolsize"));} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();System.err.println("Get Config Data Error!");}}//获得实例，给外部类进行获取连接池public static ConnectionPool getInstance(){if (instance == null){instance = new ConnectionPool();}return instance;}public synchronized Connection getConnection(){if (pool.size() > 0 ){Connection conn = pool.get(0);pool.remove(conn);return conn;}else{return null;}}public synchronized void release(Connection conn){pool.add(conn);}public synchronized void closePool(){for (int i=0; i<pool.size();i++){try {((Connection)pool.get(i)).close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}pool.remove(i);}}}

0 0