Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JSP·ÖÒ³¼¼ÊõʵÏÖ

title: JSP·ÖÒ³¼¼ÊõʵÏÖ
summary:ʹÓù¤¾ßÀàʵÏÖͨÓ÷ÖÒ³´¦Àí
author: evan_zhao
email: evan_zhao@hotmail.com
¡¡¡¡Ä¿Ç°±È½Ï¹ã·ºÊ¹ÓõķÖÒ³·½Ê½Êǽ«²éѯ½á¹û»º´æÔÚHttpSession»òÓÐ״̬beanÖУ¬·­Ò³µÄʱºò´Ó»º´æÖÐÈ¡³öÒ»Ò³Êý¾ÝÏÔʾ¡£ÕâÖÖ·½·¨ÓÐÁ½¸öÖ÷ÒªµÄȱµã£ºÒ»ÊÇÓû§¿ÉÄÜ¿´µ½µÄÊǹýÆÚÊý¾Ý£»¶þÊÇÈç¹ûÊý¾ÝÁ¿·Ç³£´óʱµÚÒ»´Î²éѯ±éÀú½á¹û¼¯»áºÄ·ÑºÜ³¤Ê±¼ä£¬²¢ÇÒ»º´æµÄÊý¾ÝÒ²»áÕ¼ÓôóÁ¿Äڴ棬ЧÂÊÃ÷ÏÔϽµ¡£
¡¡¡¡ÆäËü³£¼ûµÄ·½·¨»¹ÓÐÿ´Î·­Ò³¶¼²éѯһ´ÎÊý¾Ý¿â£¬´ÓResultSetÖÐֻȡ³öÒ»Ò³Êý¾Ý£¨Ê¹ÓÃrs.last();rs.getRow()»ñµÃ×ܼÆÂ¼ÌõÊý£¬Ê¹ÓÃrs.absolute()¶¨Î»µ½±¾Ò³Æðʼ¼Ç¼£©¡£ÕâÖÖ·½Ê½ÔÚijЩÊý¾Ý¿â(Èçoracle)µÄJDBCʵÏÖÖв¶àÒ²ÊÇÐèÒª±éÀúËùÓмǼ£¬ÊµÑéÖ¤Ã÷ÔڼǼÊýºÜ´óʱËٶȷdz£Âý¡£
¡¡¡¡ÖÁÓÚ»º´æ½á¹û¼¯ResultSetµÄ·½·¨ÔòÍêÈ«ÊÇÒ»ÖÖ´íÎóµÄ×ö·¨¡£ÒòΪResultSetÔÚStatement»òConnection¹Ø±ÕʱҲ»á±»¹Ø±Õ£¬Èç¹ûҪʹResultSetÓÐÐ§ÊÆ±Ø³¤Ê±¼äÕ¼ÓÃÊý¾Ý¿âÁ¬½Ó¡£
¡¡¡¡Òò´Ë±È½ÏºÃµÄ·ÖÒ³×ö·¨Ó¦¸ÃÊÇÿ´Î·­Ò³µÄʱºòÖ»´ÓÊý¾Ý¿âÀï¼ìË÷Ò³Ãæ´óСµÄ¿éÇøµÄÊý¾Ý¡£ÕâÑùËäȻÿ´Î·­Ò³¶¼ÐèÒª²éѯÊý¾Ý¿â£¬µ«²éѯ³öµÄ¼Ç¼ÊýºÜÉÙ£¬ÍøÂç´«ÊäÊý¾ÝÁ¿²»´ó£¬Èç¹ûʹÓÃÁ¬½Ó³Ø¸ü¿ÉÒÔÂÔ¹ý×îºÄʱµÄ½¨Á¢Êý¾Ý¿âÁ¬½Ó¹ý³Ì¡£¶øÔÚÊý¾Ý¿â¶ËÓи÷ÖÖ³ÉÊìµÄÓÅ»¯¼¼ÊõÓÃÓÚÌá¸ß²éѯËÙ¶È£¬±ÈÔÚÓ¦Ó÷þÎñÆ÷²ã×ö»º´æÓÐЧ¶à ÁË¡£
¡¡¡¡ÔÚoracleÊý¾Ý¿âÖвéѯ½á¹ûµÄÐкÅʹÓÃαÁÐROWNUM±íʾ£¨´Ó1¿ªÊ¼£©¡£ÀýÈç select * from employee where rownum<10 ·µ»ØÇ°10Ìõ¼Ç¼¡£µ«ÒòΪrownumÊÇÔÚ²éѯ֮ºóÅÅÐò֮ǰ¸³ÖµµÄ£¬ËùÒÔ²éѯemployee°´birthdayÅÅÐòµÄµÚ100µ½120Ìõ¼Ç¼Ӧ¸ÃÕâôд£º
[pre]        select * from (
            select my_table.*, rownum as my_rownum from (
                select name, birthday from employee order by birthday
            ) my_table where rownum <120
        ) where my_rownum>=


Ïà¹ØÎĵµ£º

½«jspÒ³ÃæÖÐtableµ¼³öµ½doc

<SCRIPT LANGUAGE="javascript">
       //Ö¸¶¨Ò³ÃæÇøÓòÄÚÈݵ¼ÈëWord
       function AllAreaWord() {
       var oWD = new ActiveXObject("Word.Application");
       var oDC = ......

×鯴jsp·½·¨4

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE tiles-definitions PUBLIC
  "-//Apache Software Foundation//DTD Tiles Configuration//EN"
  "http://jakarta.apache.org/struts/dtds/tiles-config.dtd">
<tiles-definitions>
 <definition name="tscs.templet" path="/pa ......

¹ØÓÚjspÖеÄcookieС³ÌÐò

<body>
 <%
   Cookie[] cookies = request.getCookies() ;
   Cookie cookie = null ;
   if(cookies!=null){
     cookie = cookies[0] ;
     out.print("ÉϴηÃÎʵÄipÊÇ£º " + request.getRemoteAddr() +"<br>") ;&n ......

jspµ¯³öд°¿Ú´úÂë

¸÷ÀàÍøÒ³µ¯´°´úÂë±àд
¡¡
¾­³£ÉÏÍøµÄÅóÓÑ¿ÉÄܻᵽ¹ýÕâÑùÒ»Ð©ÍøÕ¾£¬Ò»½øÈëÊ×Ò³Á¢¿Ì»áµ¯³öÒ»¸ö´°¿Ú£¬»òÕß°´Ò»¸öÁ¬½Ó»ò°´Å¥µ¯³ö£¬Í¨³£ÔÚÕâ¸ö´°¿ÚÀï»áÏÔʾһЩעÒâÊÂÏî¡¢°æÈ¨ÐÅÏ¢¡¢¾¯
¸æ¡¢»¶Ó­¹â¹ËÖ®ÀàµÄ»°»òÕß×÷ÕßÏëÒªÌØ±ðÌáʾµÄÐÅÏ¢¡£ÆäÊµÖÆ×÷ÕâÑùµÄÒ³ÃæÐ§¹û·Ç³£µÄÈÝÒ×£¬Ö»ÒªÍù¸ÃÒ³ÃæµÄHTMLÀï¼ÓÈ뼸¶ÎJavascript´úÂë¼´¿ÉÊ ......

ÔÚJSPÒ³ÃæÖÐÓÃselectÏÂÀ­ÁбíÀ´ÏÔʾListÁбíµÄ·½Ê½

Ò» ¡¢ ÓÃstruts2±êÇ©µÄ<s:selectÀ´ÏÔʾ
<s:select cssStyle="width: 84%" list="#application.officeList" headerKey="" headerValue="--ÇëÑ¡Ôñ--" listKey="#this.value" listValue="#this.key+'.'+#this.value" name="entity.officeName" value="entity.officeName"/>
ÆäÖÐ
1¡¢listÊǽÓÊÕjavaÀà»òÕßÔÚÆô¶¯Ê± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ