proxoolÔÚjspÖеÄÓ¦ÓÃ
ÏÈÌù¸ö½éÉÜ
http://i.cn.yahoo.com/suzie0228/blog/p_41/
proxoolÊÇÒ»¸ö¿ªÔ´µÄÁ¬½Ó³Ø£¬ÐÔÄÜÓÅÒ죬×îºÃµÄÊÇ£º¼´Ê±¼à¿ØÁ¬½Ó³Ø×´Ì¬
ÏÂÃæ¼òµ¥ËµËµËüµÄʹÓ÷½·¨£º1¡¢Ê×ÏÈÏÂÔØproxool µØÖ·£ºhttp://proxool.sourceforge.net
2¡¢½âѹËõproxool-0.9.0RC3.zip£¬¿½±´libϵÄËùÓÐjar¿âÎļþµ½ÄãµÄ¹¤³ÌϵÄWEB-INF/libÏ£¬Í¬Ê±¼ÇµÃÒ²°ÑMysqlµÄjdbcÇý¶¯µ½web-info/lib
3¡¢ÔÚWEB-INFÏ£¨±ðÅÜ´íµØ·½£©½¨Á¢Îļþ£ºproxool.xml
proxool.xmlÕâ¸öÎļþÊÇÓÃÀ´ÉèÖñðÃûµÄ¡£
ÆäÖÐ<proxool>±êÇ©¾ÍÊDZðÃûµÄÉèÖöΡ£
aliasÊDZðÃû£»
driver-urlÊÇÇý¶¯µÄurl£¬¾ÍÊÇÁ¬½ÓµÄurl£»
driver-classÊÇÇý¶¯µÄÀ࣬¾ÍÊÇÊý¾Ý¿âÇý¶¯£»
driver-propertiesÊÇÇý¶¯µÄÊôÐÔ£¬¿ÉÒÔÉèÖõǽÊý¾Ý¿âµÄÓû§ÃûºÍÃÜÂë¡£maximum-connection-countÊÇ×î´óÁ¬½ÓÊý¡£
´úÂë
ÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<proxool>
<alias>DBPool</alias> <!--ÕâÀïÊÇÁ¬½Ó³ØµÄ±ðÃû-->
<driver-url>jdbc:mysql://localhost:3306/databaseName</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="12345"/>
</driver-properties>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
4¡¢ÔÚWEB-INF/web.xmlÖÐ<web-app>½ÚµãÀï¼ÓÈëÈçÏÂÄÚÈÝ£º
<servlet>
<servlet-name>proxoolServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
&
Ïà¹ØÎĵµ£º
Ê×ÏÈÊÇÌá½»Ò³Ãæ£ºÈý¸ö±íµ¥(form1,form2,form3)
<form name="form1" method="post" action="checklogin.jsp" class="niceform">
<input name="qx" type="hidden" value="3">
&nb ......
ÎÒÃÇÔÚдһ¸öjspÒ³Ãæ£¬ÒªÊ¹ÓÃstruts2±êÇ©£¬ÎÒÃÇÒªÊ×ÏÈÒªÔÚjspÒ³ÃæÍ·²¿·Å£º<%@ taglib prefix="s" uri="/struts-tags" %>£¬µ±È»Òª·Åstruts2µÄjar°üÁË¡£ÎÒÃÇ¿ÉÒÔË¢ÐÂһϴËÒ³Ãæ£¬±ÈÈç°ÑÕâ¸öÒ³Ãæ±£´æºóÔÙ´ò¿ª£¬Ä¿µÄÊÇÔÚдstruts2±êǩʱ£¬ÓÐstruts2±êÇ©×Ô¶¯Ìáʾ¹¦ÄÜ¡£
......
¸Õ¿ªÊ¼Ñ§jsp£¬×öµÄÒ»µãÌý¿Î±Ê¼Ç¡£
1.jspÈý´óÖ¸Áî
<%@ page ~~~~~~~~ %>
<%@ include file=""%>
<%@ taglib url="" prfix=""%>
2.if(username.equals(""))
out.println("ÐÕÃû²»ÄÜΪ¿Õ£¬Çë<a href=javascript:history.back()>·µ»Ø")£»
&&·ÀÖ¹Ö±½ÓÔÚä¯À ......
ÔÚjspÖУ¬Èç¹ûÔÚurlÖд«µÝÖÐÎÄʱ»á³öÏÖÂÒÂ룬ÔÚÍøÉϹØÓÚÕâÒ»ÎÊÌâµÄ½â¾ö·½·¨Î廨°ËÃÅ£¬µ«¶¼²»ÊǺÜ×àЧ£¡Æäʵ½â¾ö·½·¨·Ç³£¼òµ¥£º µÚÒ»²½£º±àÂ루ÒÔ´«µÝµÄ²ÎÊýΪstrΪÀý£© ÔÚ´«µÝÊý¾Ýǰ½«str½øÐбàÂëJava.net.URLEncoder.encode(str) µÚ¶þ²½£º½âÂë ÔÚ»ñÈ¡Êý¾Ý¶Ë½«µÃµ½µÄÊý¾Ý½øÐнâÂë new String£¨str.getBytes("ISO8859_1")£©
......
JSP²ÊÉ«ÑéÖ¤Âë
Éú³ÉÓÐ4¸öËæ»úÊý×ÖºÍÔÓÂÒ±³¾°µÄͼƬ£¬Êý×ֺͱ³¾°ÑÕÉ«»á¸Ä±ä£¬·þÎñÆ÷¶ËˢУ¨ÓÃhistory.go(-1)Ò²»á±ä£©
ÔÐͲο¼ALIBABA http://china.alibaba.com/member/showimage
²úÉúÑéÖ¤ÂëͼƬµÄÎļþ-----image.jsp
<%@ page contentType="image/jpeg" import="java.awt.*,java.awt.image.*,java.util.*,java ......