´«ÖDz¥¿ÍjavaÅàѵ java»ù´¡Ö®Pool
×òÌìÓиöÅóÓÑÎÊÎÒ£¬Ñ§µÃ»á²»,°³ËµÑ§µÄ»á£¡
ºóÀ´ËûÓÖÎÊÎÒ£¬ËûÈç¹ûѧµÄ»°£¬Ñ§µÄ»áѧ²»»á£¬°³ËµÖ»Òª²»±¿µ°£¬°ÑÐÄ˼·ÅÔÚjavaÉÏ£¬¾ÍÒ»¶¨Ñ§µÄ»á£¡
ʱ¼äÒ»Ö±¹ýµÄ¶¼ºÜ¿ì£¬Ã¿¸öÈËÄܰÑÎÕµÄÒ²Ö»ÓнñÌ죬ËùÒÔ¼´Ê¹À§ÄÑÔٶֻ࣬ÓдËʱ´Ë¿Ì×Ô¼ºÔÚ²»Í£µÄŬÁ¦¡£
ÄÄÅÂÏñÎÏÅ£Ò»ÑùµÄǰ½ø£¬Ò²Ò»¶¨Óгɹ¦µÄÒ»Ì죬¾ÍÅÂ×Ô¼º·ÅÆú£¬ÅÂ×Ô¼ºÃ»ÓÐÐÅÐÄ£¡£¡
Á¬½Ó³Ø£º
Á¬½Ó³ØÖÐÄÜ´æ·Å¶à¸öÁ¬½Ó
¿Í»§¶ËʹÓõÃʱºò£¬Ö±½Ó´ÓÁ¬½Ó³Ø»ñÈ¡Á¬½Ó
µ±¿Í»§¶ËʹÓÃÍêÁ¬½Óʱ£¬ÔÚ°ÑÁ¬½Ó·Å»Øµ½Á¬½Ó³ØÖÐ
ʹÓÃÁ¬½Ó³ØÒª×¢Òâ
*ÒªÓÐÒ»¸ö³õʼ»¯Á¬½ÓÊý£¨Í¬Ê±ÔÚÏß5000ÈË,²»¿ÉÄÜÔÚ³ØÖдæ·Å5000¸öÁ¬½Ó£©
*×îС¿ÕÏÐÊý£¬±£´æÁ¬½Ó³ØÖУ¬´æÔÚ¿ÕÏÐÁ¬½Ó£¬·ÅÖúé·åµ½À´£¬ÒýÆðµÃÐÔÄÜ¿ªÏú£¨ÄÇôµ±³ØÖеÃÁ¬½ÓÓÃÍ꣬
ÓÐеÿͻ§¶ËÀ´·ÃÎÊ£»¾Í±ØÐë´´½¨ÐµÃÁ¬½Ó£¬ËùÒÔ¿ÉÒÔÔÚ³ØÖÐÉèÖÃ×îС¿ÕÏÐÊý£©
*×î´óÁ¬½ÓÊý£¨µ±Á¬½ÓÊý´ïµ½Êý¾Ý¿âµÃÉÏÏÞ£¬¾Í²»ÔÊÐí¼ÌÐø´´½¨ÐµÃÁ¬½Ó£©
*×î´óµÈ´ýʱ¼ä£¨Á¬½ÓÊý´ïµ½ÉÏÏÞ£¬Èç¹ûÓÐеÃÁ¬½Ó£¬Ôò±ØÐëµÈ´ýÆäËûÁ¬½ÓÊÍ·Å£¬Èô³¬¹ýµÈ´ýʱ¼ä£¬·þÎñÆ÷Å׳öÒì³££©
*×î´ó¿ÕÏÐÊý£¨µ±ºé·åÍËȥʱ£¬·ÀÖ¹Á¬½Ó³ØÖеÃÁ¬½ÓÊý¹ý¶à£©
javax.sql.DataSource ½Ó¿Ú ÓÉÇý¶¯³§ÉÌʵÏÖ£¬Í¨³£±»³ÆÎªÊý¾ÝÔ´£¬Ëü°üº¬Á¬½Ó³ØºÍÁ¬½Ó³Ø¹ÜÀí
Á½¸ö²¿·Ö£¬
*DBCPÊý¾Ý¿âÁ¬½Ó³Ø Abache²úÆ·
±ØÐëµ¼Èëcommon-pool.jar
common-jdbc.jar
*C3P0Êý¾Ý¿âÁ¬½Ó³Ø£¨www.mchange.com£©
´´½¨Á¬½Ó³Ø£¨DBCP£©£º
µÚÒ»ÖÖ£º
BasicDateSource implements javax.sql.DateSource
*´ú±íÊý¾ÝÔ´£¬Ò²¾ÍÊÇÁ¬½Ó³Ø
BasicDateSource bds=new BasicDateSource();
bds.setUsername();
bds.setPassword();
bds.setUrl();
//ÉèÖóõʼ»¯²ÎÊý
bds.setInitialSize(4);
//ÉèÖÃ×î´óÁ¬½ÓÊý
bds.setMaxActive(10);
//ÉèÖÃ×î´ó¿ÕÏÐÊý
bds.setMaxIdle(5);
//ÉèÖÃ×îС¿ÕÏÐÊý
bds.setMinIdle(3);
//ÉèÖÃ×î´óµÈ´ýʱ¼ä
bds.setMaxWait(5000);
//»ñÈ¡Á¬½Ó
Connection conn=bds.getConnection();
µÚ¶þÖÖ£º
Properties properties=new Properties();
properties.setProperty("username","root");
properties.setProperty("password","root");
Ïà¹ØÎĵµ£º
ListµÄÓ÷¨
List°üÀ¨List½Ó¿ÚÒÔ¼°List½Ó¿ÚµÄËùÓÐʵÏÖÀà¡£ÒòΪList½Ó¿ÚʵÏÖÁËCollection½Ó¿Ú£¬ËùÒÔList½Ó¿ÚÓµÓÐCollection½Ó¿ÚÌṩµÄËùÓг£Ó÷½·¨£¬ÓÖÒòΪListÊÇÁбíÀàÐÍ£¬ËùÒÔList½Ó¿Ú»¹ÌṩÁËһЩÊʺÏÓÚ×ÔÉíµÄ³£Ó÷½·¨£¬Èç±í1Ëùʾ¡£
±í1 List½Ó¿Ú¶¨ÒåµÄ³£Ó÷½·¨¼°¹¦ÄÜ
´Ó±í1¿ÉÒÔ¿´³ö£¬List½Ó¿ÚÌṩµÄÊʺÏÓÚ×ÔÉíµÄ ......
ÐÞ¸ÄJavaÎļþ²»ÓÃÖØÆôTomcat·þÎñµÄ·½·¨
ÔÚʹÓÃEclipse+Tomcat¿ª·¢JavaÏîÄ¿µÄʱºò³£³£»áÅöµ½ÕâÑùµÄÇé¿ö£¬ÒÑÐÞ¸ÄJavaÎļþTomcat¾Í»á×Ô¶¯ÖØÆô£¬½ÓÏÂÀ´¾ÍÊÇÂþ³¤µÄµÈ´ý·þÎñÖØÆôÍê±Ï¡£ÄÇÆäʵ´ó¶àÊýµÄJavaÎļþÐÞ¸ÄÊÇûÓбØÒªÖØÆô·þÎñµÄ£¬Ö»ÓÐÒ»Ð©ÌØ¶¨µÄJavaÎļþ£¬±ÈÈç˵ֻÓÐÖØÆô·þÎñµÄʱºò²Å»áµ÷Ó ......
JavaµÄ¶ÑÊÇÒ»¸öÔËÐÐʱÊý¾ÝÇø,ÀàµÄ(¶ÔÏó´ÓÖзÖÅä¿Õ¼ä¡£ÕâЩ¶ÔÏóͨ¹ýnew¡¢newarray¡¢anewarrayºÍmultianewarrayµÈ Ö¸ÁÁ¢£¬ËüÃDz»ÐèÒª³ÌÐò´úÂëÀ´ÏÔʽµÄÊÍ·Å¡£¶ÑÊÇÓÉÀ¬»ø»ØÊÕÀ´¸ºÔðµÄ£¬¶ÑµÄÓÅÊÆÊÇ¿ÉÒÔ¶¯Ì¬µØ·ÖÅäÄÚ´æ´óС£¬Éú´æÆÚÒ²²»±ØÊÂÏȸæËß±àÒëÆ÷£¬ÒòΪËüÊÇÔÚÔËÐÐʱ ¶¯Ì¬·ÖÅäÄÚ´æµÄ£¬JavaµÄÀ¬»øÊÕ¼¯Æ÷»á×Ô¶¯ÊÕ×ßÕâЩ²»ÔÙ ......
1.¼ÆËãijһÔ·ݵÄ×î´óÌìÊý
Calendar time=Calendar.getInstance();
time.clear();
time.set(Calendar.YEAR,year); //year Ϊ int
time.set(Calendar.MONTH,i-1);//×¢Òâ,Calendar¶ÔÏóĬÈÏÒ»ÔÂΪ0
int day=time.getActualMaximum(Calendar.DAY_OF_MON ......