JSPÎÄÕÂÄÚÈÝ·ÖÒ³£¨JSP + JDBC£©
±í½á¹¹£º
CREATE TABLE `article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
JSPÒ³Ãæ£º
<%@ page language="java" import="java.sql.*,java.io.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
int size = 4096; //ÿһҳÏÔʾµÄ×Ö·ûÊý
int currentPage = 0; //µ±Ç°Ò³£¬³õʼ»¯Îª0
boolean hasNext = false; //ÊÇ·ñÓÐÏÂÒ»Ò³
String p = request.getParameter("p");
if(p != null && !"".equals(p))
currentPage = Integer.parseInt(p);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>Article Paging Demo</title>
<meta http-equiv="pragma" content="no-cache">
<meta h
Ïà¹ØÎĵµ£º
¼òµ¥½éÉÜJSPÊý¾Ý¿â²Ù×÷µÄ3¸öС¼¼ÇÉ£ºÊý¾ÝÅÅÐò£¬Ö÷/´Ó±í´¦Àí£¬ÊÂÎñ´¦Àí¡£
1¡¡Êý¾ÝÅÅÐò
ÔÚÊý¾Ý¿â¼¼ÊõÖУ¬¿ÉÒÔʹÓÃORDER×Ó¾ä¶Ô²éѯ½á¹û½øÐÐÅÅÐò
[ ORDER BY { order_by_exdivssion[ ASC | DESC]} [ ¸…n ] ]
ÆäÖУ¬order_by_exdivssionÓÃÀ´Ö¸¶¨ÒªÅÅÐòµÄÁУ»ASCÖ¸¶¨°´µÝÔö˳ÐòÅÅÁУ»DESCÖ¸¶¨°´µÝ¼õ˳ÐòÅÅÐò ......
http://www.egzcn.com/article/webbc/JSP/2006-03-22/2003.html À´Ô´
ÕªÒª£ºËäÈ»session»úÖÆÔÚwebÓ¦ÓóÌÐòÖб»²ÉÓÃÒѾºÜ³¤Ê±¼äÁË£¬µ«ÊÇÈÔÈ»ÓкܶàÈ˲»Çå³þsession»úÖÆµÄ±¾ÖÊ£¬ÒÔÖÁ²»ÄÜÕýÈ·µÄÓ¦ÓÃÕâÒ»¼¼Êõ¡£±¾ÎĽ«ÏêϸÌÖÂÛsessionµÄ¹¤×÷»úÖÆ²¢ÇÒ¶ÔÔÚJava web applicationÖÐÓ¦ÓÃsession»úÖÆÊ±³£¼ûµÄÎÊÌâ×÷ ......
1.RequestDispatcher.forward()
ÊÇÔÚ·þÎñÆ÷¶ËÆð×÷ÓÃ,µ±Ê¹ÓÃforward()ʱ,Servlet engine´«µÝHTTPÇëÇó´Óµ±Ç°µÄServlet or JSPµ½ÁíÍâÒ»¸öServlet,JSP »òÆÕͨHTMLÎļþ,Ò²¼´ÄãµÄformÌá½»ÖÁa.jsp,ÔÚa.jspÓõ½ÁËforward()ÖØ¶¨ÏòÖÁb.jsp,´ËʱformÌá½»µÄËùÓÐÐÅÏ¢ÔÚb.jsp¶¼¿ÉÒÔ»ñµÃ,²ÎÊý×Ô¶¯´«µÝ.
µ«forward()ÎÞ·¨Öض ......
JSP2.0Öеıí´ïʽÓïÑÔ(EL±í´ïʽ)
ELÓï·¨
ELµÄÓï·¨ºÜ¼òµ¥£¬Ëû×î´óµÄÌØµã¾ÍÊÇʹÓÃÉϺܷ½±ã
Àý£º
${sessionScope.user.sex}
ËùÓÐEL¶¼ÊÇÒÔ ${ ΪÆðʼ¡¢ÒÔ} Ϊ½áβµÄ¡£
ÉÏÊöEL·¶ÀýµÄÒâ˼ÊÇ£º´ÓSessionÈ¡µÃÓû§µÄÐÔ±ð¡£Èç¹ûʹÓÃ֮ǰJSP´úÂëµÄд·¨ÈçÏ£º
<%
User user = (User)session.getAttribute("user");
& ......