jsp dbcpÓÅ»¯ÌáÎÊ£¬ÔÚÏߵȡ£
СµÜдÁËÒ»¸öJSPµÄϵͳ£¬´òËã50¸öÈËʹÓá£Í¬Ê±ÔÚÏßʹÓõÄÔ¤¼ÆÔÚ5-10¸öÈË¡£
ÓÃtomcat5.5µÄDBCP×öÊý¾ÝÁ¬½Ó¡£
²âÊÔµÄʱºò£¬×Ô¼ºÒ»Ì¨»úÆ÷ÔÚ²»¶ÏÁ¬½Óºó£¬»áÏÔʾ£¬idl²»¹»Ö®ÀàµÄ¡£Ò»°ãÕâÑùµÄÁ´½Ó³Ø¸ÃÈçºÎÅäÖá£Ð»Ð»
һ̨»úÆ÷¾Í±¨´íµÄ»°£¬¹À¼ÆÊÇ´úÂëÀïÃæÊý¾Ý¿âÁ¬½ÓûÓÐÊÍ·Å¡£
ÎÒ»ñÈ¡µÄconÈç¹ûcloseµÄ»°£¬¾Í»á˵ÎÒcon have closed£¬Ã¿´ÎÎÒÖ»°Ñrs£¬ptmt¸ø¹ØÁË
¶¥ÏÂ
ÏȹØrs£¬ÔÙ¹Øptmt£¬×îºó¹Øcon¡£ÁíÍ⣬ÊDz»ÊÇÄãÊͷŵķ½·¨ÓÐÎÊÌâÄØ£¿²Î¿¼Ò»Ï£º
commons-dbcpµÄʹÓÃ
ÓÉÓÚûÓÐÒ»¸öweb»·¾³£¬ËùÒÔÎÒÃÇÐèÒª×Ô¼ºÊµÏÖÒ»¸öÊý¾Ý¿âÁ¬½Ó³Ø£¬apacheÓÐÒ»¸öÏîÄ¿½Ð×öcommons DBCP£¬ÕâÊÇÒ»¸ö»ùÓÚapache×Ô¼ºµÄ¶ÔÏ󳨣¨apache commons pool£©ÊµÏÖµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬ÎÒÃÇ¿ÉÒÔÖ±½ÓÄÃÀ´Ê¹Óã¬apacheµÄÈí¼þδ±ØÊÇ×îºÃµÄ£¬µ«ÊǼ«´ó¿ÉÄܱÈÎÒÃÇ×Ô¼ºÐ´µÄÒªºÃ¡£
Commons DBCPÐèÒªÈý¸ö.jar£º
commons-collections-3.1.jar¡¢commons-dbcp-1.2.1.jar¡¢commons-pool-1.2.jar
ÕâÈý¸öÎļþ¶¼¿ÉÒÔÔÚapache – Jakarta – commonsÏîÄ¿ÏÂÏÂÔØ£¬¼ÓÈëµ½¹¤³ÌÖм´¿É¡£
¹¹ÔìÒ»¸öÊý¾Ý¿âÁ¬½Ó³ØµÄ´úÂëÈçÏ£º
import java.sql.*;
import com.gwnet.games.antiLord.util.*;
import org.apache.commons.dbcp.ConnectionFactory;
import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.DataSourceConnectionFactory;
pri
Ïà¹ØÎÊ´ð£º
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
jspÖÐinclude.incµÄ×÷ÓÃÊÇʲô£¿
include.incɶÒâ˼£¿Ã»Ìý˵¹ý
Java code:
<%include file="include.inc"%>¼ÓÔØÍøÕ¾Ä¿Â¼include.incÎļþÄÚÈÝ
°üº¬Ò»¸ö¾²Ì¬Ò³Ãæ°É···
& ......
Ò»¸öÃû³Æ,ÐèÒªÊäÈëµÄ£¬Ò»¸öÏÂÀ²Ëµ¥£¬Ñ¡ÔñµÄ£¬¸ù¾ÝÕâÁ½¸ö½øÐÐÄ£ºý²éѯ¡£ÔÚ·þÎñÆ÷¶ËÎÞÂÛÊäÈëÓë·ñ£¬¶¼Äܵóö²éѯ½á¹û¡£
µ«ÊÇ·ÃÎʵϰ£¬Ö»ÓÐÔÚÊäÈëÃû³ÆµÄʱºò£¬ÔÙÑ¡ÔñÏÂÀ²Ëµ¥²ÅÄܲéѯ£¬Èô²»ÊäÈëÃû³Æ£¬Ö»Ñ¡ÔñÏÂÀ²Ëµ ......
ÐÂÊÖ:
tomcat+struts 2.0
jsp Ò³ÃæÖ±½Ó¹ØÁªmodel
ÏÖÔÚÐèÒª¸ù¾Ýmodel(admin)ÀïÃæµÄÒ»¸öitem(id),ÅжÏjspÒ³Ãæ³öÏÖµÄÄÚÈÝ.
´ó¸ÅÁ÷³Ì:
...
<table>
<tr>
<td>
<s:if admin.id is null> ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......