´«Ö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");
Ïà¹ØÎĵµ£º
ÔÚjava³ÌÐòÖÐ,ΪÁËʵÏÖͬ±¾µØÏµÍ³µÄÓ²¼þ¶Ë¿Ú(RS-232±ê×¼´®¿Ú/IEEE1284±ê×¼²¢¿Ú)ͨѶ,ĿǰÓÐÁ½¸ö·½·¨,µÚÒ»¸ö¾ÍÊÇÒÔǰ˵¹ýµÄ,ʹÓÃJNI¼¼Êõ×Ô¼ºÐ´Ò»¸öÓëjava³ÌÐòÏà¹ØµÄdll/soÎļþ,Õâ¸öÎļþ¿ÉÒÔÖ±½ÓºÍ±¾µØÏµÍ³Í¨ÐÅ,´Ó¶ø¹ÜÀí±¾µØ»úÆ÷µÄ¶Ë¿Ú,²»¹ýʹÓÃjava³ÌÐò¶À×ÔʵÏÖÒ»¸ö±È½ÏÍêÉÆµÄ¶Ë¿Ú¹ÜÀí½â¾ö·½°¸¶Ô¸öÈ˶øÑÔÊÇÒ»¸ö»¨·Ñ¾Þ´óÇÒ²»Ê ......
package com.hongsoft.test;
import java.io.*;
//¶¨ÖƵÄÀà×°ÈëÆ÷
public class TestCompile extends ClassLoader
{
String _compiler;
String _classpath;
public static void main(String[] args)
{
new TestCompile();
}
public TestCompile()
{
super(ClassLoader.getSystemClassLoader());
//ĬÈϱàÒëÆ ......
µÚ1Õ strutsÓëjava webÓ¦Óüò½é
1.1 java webÓ¦ÓøÅÊö
1.2 web×é¼þµÄÈýÖÖ¹ØÁª¹ØÏµ
1.3 muv¸ÅÊö
1.4 struts¸ÅÊö
1.4.1 strutsʵÏÖmvcµÄ»úÖÆ
ÔÚstruts¿ò¼ÜÖУ¬Ä£ÐÍÓÉʵÏÖÒµÎñÂß¼µÄjavabean»òejb×é¼þ¹¹³É£¬¿ØÖÆÆ÷ÓÉ
ActionServletºÍActionÀàʵÏÖ£¬ÊÓͼÓÉÒ»×éjspÎļþ¹¹³É¡£
1.ÊÓͼ
ÊÓͼ¾ÍÊÇjspÎļþ¡£ÔÚÕâЩjspÎļþ ......
Äã¾õµÃ×Ô¼ºÊÇÒ»¸öJavaר¼ÒÂð£¿ÊÇ·ñ¿Ï¶¨×Ô¼ºÒÑ¾È«ÃæÕÆÎÕÁËJavaµÄÒì³£´¦Àí»úÖÆ£¿ÔÚÏÂÃæÕâ¶Î´úÂëÖУ¬ÄãÄܹ»Ñ¸ËÙÕÒ³öÒì³£´¦ÀíµÄÁù¸öÎÊÌâÂð£¿
OutputStreamWriter out = ...
java.sql.Connection conn = ...
try { // ¢É
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery(
"selec ......
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 ......