JavaÊý¾Ý¿âÁ¬½Ó³ØÀàÔ´Âë
À´×Ô:http://www.cnblogs.com/shiyangxt/archive/2008/07/30/1256813.html
»·¾³£ºMyEclipse
Êý¾Ý¿â£ºmysql
Ê×ÏÈн¨JavaÏîÄ¿£¬È»ºóн¨Á½¸öÀ࣬һ¸öÊý¾Ý¿âÁ¬½Ó³ØÀ࣬һ¸ö²âÊÔÀà¡£
·Ö±ðÃüÃûConnectionPool£¬ConnectionPoolTest¡£
È»ºóн¨Ò»¸öÅäÖÃÎļþ£¬ÃüÃû£ºdbpool.properties¡£
дÈë´úÂ룺
ConnectionPool.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);
readConfig();
addConnection();
}
/** *//**
* ·µ»ØÁ¬½Óµ½Á¬½Ó³ØÖÐ
*/
public synchronized void release(Conn
Ïà¹ØÎĵµ£º
×î½üÔÚÓÃÈóǬÔÚ×öһЩwebÏîÄ¿µÄ±¨±í£¬ÆäÖÐÓÐÒ»¸öÅúÁ¿´òÓ¡µÄ±¨±í¡£ÐèÒª°Ñ²ÎÊý´«µ½±¨±íÀµ±°ÑÖÐÎÄ´«µ½ÀïÃæÊ±×ÜʱÂÒÂ룬²ÉÓÃÁ˸÷ÖÖתÂ뷽ʽ£¬Ò²Ã»×ª¹ýÀ´£¬ÔÎ.........
Ϊʲô»áÓÐÕâô¶àµÄ±àÂ룬ºÃÍ·ÌÛѽ... ......
=====================================
ǰÑÔ
ÔÚ̫ԾÀúÁËÒ»ÄêµÄÍ´¿à¿ª·¢Ö®ºó£¬ÏîÄ¿ÒѾÈÕÇ÷Îȶ¨£¬½ÓÏÂÀ´µÄ¹¤×÷¾ÍÊÇÄÃÏÖÓеĴúÂëµ½ÆäËûµÄÊ¡ÊнøÐÐʵʩ¡¢È»ºó×öһЩ±¾µØ»¯¿ª·¢¡£ÈÕ×ÓÏà¶ÔÇáËÉÁËÐí¶à£¬ÓÚÊÇ¿ÉÒÔ³é³öʱ¼äÀ´ÎÂϰһÏ»ù´¡µÄ¼¼Êõ֪ʶ£¬¸ø×Ô¼ºÁÐÁËÒ»¸ö¸´Ï°Ìá¸Ù£¬ÕâÒ²ÊÇÒ»¸öjava³ÌÐòÔ±ËùÓ¦¸ÃÕÆÎÕµÄ֪ʶÂöÂç¡£
=== ......
JDBC¶ÁÈ¡Êý¾Ý¿âÔªÊý¾Ý,Éú³ÉJAVAʵÌåÀà
package com.nffish.util;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import com.nffish.c ......
1.Java ¼¯ºÏ¿ò¼Üͼ
¡¡¡¡-¼¯ºÏ½Ó¿Ú£º6¸ö½Ó¿Ú£¨¶ÌÐéÏß±íʾ£©£¬±íʾ²»Í¬¼¯ºÏÀàÐÍ£¬ÊǼ¯ºÏ¿ò¼ÜµÄ»ù´¡¡£
¡¡¡¡-³éÏóÀࣺ5¸ö³éÏóÀࣨ³¤ÐéÏß±íʾ£©£¬¶Ô¼¯ºÏ½Ó¿ÚµÄ²¿·ÖʵÏÖ¡£¿ÉÀ©Õ¹Îª×Ô¶¨Ò弯ºÏÀà¡£
¡¡¡¡-ʵÏÖÀࣺ8¸öʵÏÖÀࣨʵÏß±íʾ£©£¬¶Ô½Ó¿ÚµÄ¾ßÌåʵÏÖ¡£
¡¡¡¡2.JavaÈÝÆ÷Àà½éÉÜ
¡¡¡¡¢Ù JavaÈÝÆ÷Àà¶¼¿ÉÒÔ×Ô¶¯µØµ÷Õû×Ô¼ºµÄ³ß´ ......
Java/JSPÖÐÎÄÂÒÂëÎÊÌâ½â¾öÐĵÃ
×Ô´Ó½Ó´¥JavaºÍJSPÒÔÀ´£¬¾Í²»¶ÏÓëJavaµÄÖÐÎÄÂÒÂëÎÊÌâ´ò½»µÀ£¬ÏÖÔÚÖÕÓڵõ½Á˳¹µ×µÄ½â¾ö£¬ÏÖ½«ÎÒÃǵĽâ¾öÐĵÃÓë´ó¼Ò¹²Ïí¡£
Ò»¡¢JavaÖÐÎÄÎÊÌâµÄÓÉÀ´
JavaµÄÄں˺ÍclassÎļþÊÇ»ùÓÚunicodeµÄ£¬ÕâʹJava³ÌÐò¾ßÓÐÁ¼ºÃµÄ¿çƽ̨ÐÔ£¬µ«Ò²´øÀ´ÁËһЩÖÐÎÄÂÒÂëÎÊÌâµÄÂé·³¡£ÔÒòÖ÷ÒªÓÐÁ½·½Ã棬JavaºÍJS ......