select o_customer,o_price from orders having o_price >=avg(o_price)
select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders)
ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐÇø±ð¡£
o_ id o_date o_price o_customer
1 2008-12-29 1000 bush
2 2008-11-23 1600 car ......
<a href="result.jsp?page=<%=intPage+1%>&searchKey=<%=key%>">ÏÂÒ»Ò³</a>
µ±µã»÷ÏÂÒ»Ò³Ö®ºó£º
תµ½£º
key=new String(request.getParameter("searchKey").getBytes("ISO-8859-1"),"UTF-8");
µÃµ½µÄkeyÊÇÂÒÂë
Ææ¹ÖµÄÊÇÈç¹ûkeyÖµÊÇÒ»¸ö´ÊÓҲ¾ ......
ÎÒÓиöliuyan.jsp½çÃ棬ÀïÃæincludeÒ»¸öadd.jspÌí¼ÓÁôÑÔÐÅÏ¢½çÃ棬µ«Ã¿´Îµã»÷Ìá½»Êý¾Ýµ½Êý¾Ý¿âÁËÈ´²»Ö±½ÓÏÔʾÔÚÉÏÃ棬ÒòΪֻˢÐÂÁËadd.jspÕâ¸ö½çÃ棬ËùÒÔÎÒÏëÎÊÏÂÎÒADD.jspÌá½»ÍêÔõôȥˢÐĸ¸½çÃæÕû¸ö´°Ì壬ÓÐÉÏÃæºÃ°ì·¨Â𣿷ÖËæÉÙ£¬µ«ÐĺܳÏ
ÓÃframe¡£Ìá½»Íê³ÉºóparentË¢Ò»ÏÂ
......
ÎÒÏëʵÏÖÒ»¸ö×¢²áÌøת¹¦ÄÜ£¬¿É×ÜÊdzöÏÖÒì³££º³ÌÐòҲûʲôÎÊÌâ°¡£¿Ôõô»ØÊ¡£¡£¡£¡£¡£¡££¨Êý¾Ý¿âÒѾÁ¬½ÓÉÏÁË£©
////////////////////////////////////////////////////////////////////////////////////////////
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.se ......
ÎÒÏÖÔÚµÄÏîÄ¿£¬²»ÄÜÓÃstruts¿ò¼Ü£¬ËùÒÔ´«Í¼Æ¬µÄʱºò£¬formÀï¼ÓÁËenctype="multipart/form-data"£¬request¾ÍÈ¡²»µ½ÆäËû²ÎÊýµÄÖµÁË¡£ÎÒÍøÉϲéÁËÏÂ×ÊÁÏ£¬ËµÊǼÓÉÏ
SmartUpload su = new SmartUpload();//н¨Ò»¸öSmartUpload¶ÔÏó
su.getRequest().getParameter('produce');È¡µ¥¸ö²ÎÊýµ¥¸öÖµ
µ«ÊÇ£¬ ......
2010-5-25 11:09:57 org.apache.catalina.core.StandardWrapperValve invoke
ÑÏÖØ: Servlet.service() for servlet jsp threw exception
java.lang.InstantiationException: bean user not found within scope
at org.apache.jsp.manage.index_jsp._jspService(index_jsp.java:59)
at org.apache.jasper.runtime.Http ......