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 = ......
<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" ......
<?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 ......
<%@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.*"%>
......
Á¬Ðø¼¸Ìì°²×°ÅäÖúÍÁ¬½ÓMysqlÊý¾Ý¿â£¬½ñÌìÖÕÓڳɹ¦ÁË£¬»ØÏëÕ⼸Ìì£¬ÕæµÄÊÇÌðËá¿àÀ±¶¼ÓУ¬µ¥mysql¾Í֨װÁ˲»ÏÂ10´Î£¬¶øÔÚeclipseÉϱàдµÄÁ¬½ÓÊý¾Ý¿âµÄ³ÌÐò×ÜÊDZ¨´í£®ÎÒ¶¼ÒѾdownÁËoracal×¼±¸·ÅÆúmysqlÁË£¬²»¹ý£®£®£®¾ÍÏóµçÊÓ¾çÑݵÄÄÇÑù£¬×ª»ú×ÜÊÇÔÚÕâ¸öʱºò³öÏÖ£¬ÏÈÊÇ¿´µ½ÁËsaulzy¹ØÓÚmysql4.1.11°æ±¾µÄ°²×°½éÉÜ£¬½Ó×ÅÓÖÕ ......