JDBC+MySQLÁ¬½Ó³Ø

1.´´½¨Ò»¸öjava projectÏîÄ¿pooling
2.ΪÏîÄ¿Ìí¼ÓMySQLÁ¬½ÓÇý¶¯
3.ΪÏîÄ¿Ìí¼ÓÒ»¸öÅäÖÃÎļþdbpool.proprerties
Code
driverClassName=com.mysql.jdbc.Driver
username=root
password=
url=jdbc:mysql://localhost:3306/work
poolSize=10
 
4.·Ö±ð´´½¨Ò»¸öÁ¬½ÓÀàConnectionPool.javaºÍÒ»¸ö²âÊÔÀàConnectionPoolTest.java(´úÂë)
 
Code
package webbook.util;
import java.io.FileInputStream;
import java.sql.Connection;
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 = 1;
    private static ConnectionPool instance = null;
    /**
     * Ë½ÓеĹ¹Ôì·½·¨£¬½ûÖ¹Íⲿ´´½¨±¾ÀàµÄ¶ÔÏó£¬ÒªÏë»ñµÃ±¾ÀàµÄ¶ÔÏó£¬Í¨¹ý<code>getIstance</code>·½·¨¡£
     * Ê¹ÓÃÁËÉè¼ÆģʽÖеĵ¥×Óģʽ¡£
     */
    private ConnectionPool() {
        init();
    }
    /**
     * Á¬½Ó³Ø³õʼ»¯·½·¨£¬¶ÁÈ¡ÊôÐÔÎļþµÄÄÚÈÝ ½¨Á¢Á¬½Ó³ØÖеijõʼÁ¬½Ó
     */
    private void init() {
        pool = new Vector<Connection>(poolSize);
    &nb