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>=
Ïà¹ØÎĵµ£º
±¾ÀýÊDzÉÓÃJSP + Ajax + Îı¾À´ÑÝʾ¶àÑ¡¡¢È«Ñ¡£¬Ìí¼Ó¡¢É¾³ý¡¢¸üÐÂcheckbox¶àÑ¡¿òµÄЧ¹û£»³ä·ÖÕ¹ÏÖÁËÀûÓÃJavaScript¿ØÖÆHTML DOMÒÔ¼°ÀûÓÃXML http ´«µÝÊý¾Ý£¬ÀûÓÃJSP²Ù×÷Îı¾µÄЧ¹û¡£
¡¡¡¡1.JavaScript ÓÃÀ´¿ØÖÆÒ³ÃæÄÚÈݵÄÏÖʵÓëÔöɾЧ¹û£»
¡¡¡¡2.JSP×÷Ϊºǫ́£¬¶ÔÎı¾½øÐжÁÈ¡¡¢Ð´Èë¡¢¸üеȲÙ×÷£»
¡¡¡¡3.Îı¾¸ñʽÊÇÓÃÀ´´ ......
<SCRIPT LANGUAGE="javascript">
//Ö¸¶¨Ò³ÃæÇøÓòÄÚÈݵ¼ÈëWord
function AllAreaWord() {
var oWD = new ActiveXObject("Word.Application");
var oDC = ......
<html:html>
<HEAD>
<tiles:insert attribute="header" />
</HEAD>
<body>
<tiles:insert attribute="top" />
<table width="100%" height="400" border="0" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td width="178" ......
<%@page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="org.springframework.context.ApplicationContext"%>
<%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
<%@page import="ccp.suddenattack.service.news.*"%>
......