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>=
Ïà¹ØÎĵµ£º
<SCRIPT LANGUAGE="javascript">
//Ö¸¶¨Ò³ÃæÇøÓòÄÚÈݵ¼ÈëWord
function AllAreaWord() {
var oWD = new ActiveXObject("Word.Application");
var oDC = ......
<?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 ......
<body>
<%
Cookie[] cookies = request.getCookies() ;
Cookie cookie = null ;
if(cookies!=null){
cookie = cookies[0] ;
out.print("ÉϴηÃÎʵÄipÊÇ£º " + request.getRemoteAddr() +"<br>") ;&n ......
¸÷ÀàÍøÒ³µ¯´°´úÂë±àд
¡¡
¾³£ÉÏÍøµÄÅóÓÑ¿ÉÄܻᵽ¹ýÕâÑùÒ»Ð©ÍøÕ¾£¬Ò»½øÈëÊ×Ò³Á¢¿Ì»áµ¯³öÒ»¸ö´°¿Ú£¬»òÕß°´Ò»¸öÁ¬½Ó»ò°´Å¥µ¯³ö£¬Í¨³£ÔÚÕâ¸ö´°¿ÚÀï»áÏÔʾһЩעÒâÊÂÏî¡¢°æÈ¨ÐÅÏ¢¡¢¾¯
¸æ¡¢»¶Ó¹â¹ËÖ®ÀàµÄ»°»òÕß×÷ÕßÏëÒªÌØ±ðÌáʾµÄÐÅÏ¢¡£ÆäÊµÖÆ×÷ÕâÑùµÄÒ³ÃæÐ§¹û·Ç³£µÄÈÝÒ×£¬Ö»ÒªÍù¸ÃÒ³ÃæµÄHTMLÀï¼ÓÈ뼸¶ÎJavascript´úÂë¼´¿ÉÊ ......
Ò» ¡¢ ÓÃ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Àà»òÕßÔÚÆô¶¯Ê± ......