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
Ïà¹ØÎĵµ£º
ʵÏÖÂÛ̳Ê÷ÐͽṹµÄËã·¨ºÜ¶à£¬¾ßÌåÄã¿ÉÒÔÈ¥www.chinaasp.comµÄÈ«ÎÄËÑË÷Öвéѯ¡£ÎÒÏÖÔÚµÄJSPÂÛ̳²ÉÓõÄÒ²Êǵ±ÖеÄÒ»ÖÖ£º²»ÓõݹéʵÏÖÊ÷ÐͽṹµÄËã·¨£¬ÏÖÔÚÎÒ½«ÂÛ̳Ê÷ÐͽṹµÄ¾ßÌåËã·¨ºÍ´ó¼Ò½éÉÜһϣ¬ºÍ´ó¼ÒÒ»Æð½»Á÷¡£
¡¡¡¡1¡¢ÑÝʾ±íµÄ½á¹¹£º
¡¡¡¡¡¡±íÃû£ºmybbslist
¡¡¡¡¡¡×Ö¶Î ¡¡¡¡¡¡¡¡Êý¾ÝÀàÐÍ¡¡¡¡ËµÃ÷
¡¡¡¡¡¡BBSID ......
¼òµ¥½éÉÜJSPÊý¾Ý¿â²Ù×÷µÄ3¸öС¼¼ÇÉ£ºÊý¾ÝÅÅÐò£¬Ö÷/´Ó±í´¦Àí£¬ÊÂÎñ´¦Àí¡£
1¡¡Êý¾ÝÅÅÐò
ÔÚÊý¾Ý¿â¼¼ÊõÖУ¬¿ÉÒÔʹÓÃORDER×Ó¾ä¶Ô²éѯ½á¹û½øÐÐÅÅÐò
[ ORDER BY { order_by_exdivssion[ ASC | DESC]} [ ¸…n ] ]
ÆäÖУ¬order_by_exdivssionÓÃÀ´Ö¸¶¨ÒªÅÅÐòµÄÁУ»ASCÖ¸¶¨°´µÝÔö˳ÐòÅÅÁУ»DESCÖ¸¶¨°´µÝ¼õ˳ÐòÅÅÐò ......
Ò»£ºweb.xmlÅäÖÃ
<servlet>
<servlet-name>context</servlet-name>
<servlet-class>
org.springframework.web.context.ContextLoaderServlet
</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<context-param>
<param-name>cont ......
ÔÚ±¾ÆªÎÄÕÂÖн«Ê¹ÓùýÂËÆ÷½øÐбàÂëת»»¡¢µÇ½ÑéÖ¤¡¢·ÀÕ¾ÍâÌá½»µÄ¹ý³Ì£¬ÎªÁËÑÝʾ£¬ÎҰѱàÂëת»»·ÅÔÚÒ»¸öfilterÖУ¬µÇ½ÑéÖ¤ºÍ·ÀÕ¾ÍâÌá½»·ÅÔÚÁíÒ»¸öfilterÖУ¬Á½¸öfilter½øÐд®Áª¹¤×÷¡£
1¡¢ÎªÁËÑÝʾ£¬ÏÈÖÆ×÷ÕâÁ½¸öfilter
//Õâ¸öfilterÊÇΪÁË×ö±àÂëת»»£¬Ö»Òª·ÃÎÊ.jspÍøÒ³¶¼Òª¹¦¹ýÕâ¸öfilter
/**ÀàÃû£ºfilter.Encoding
*×÷ ......
JSPµÄ×¢ÊÍ
<%--........--%>
JSPÖ¸ÁîºÍJSP¶¯×÷£¨±ê×¼µÄJSP±êÇ©£©
JSPÖ¸ÁîµÄÓï·¨
<%@... ....%>
<%@include file="...."%> °üº¬Ö¸Á°üº¬Ö¸Áî»á½«Òª°üº¬µÄÎļþ´úÂëÔÑùÊä³öµ½±¾Ò³Ã棨ÔÚ·Òëʱ°Ñ°üº¬ÎļþµÄÄÚÈÝÒýÈë²¢ºÏ²¢£©£¬²»½øÐзÒ룬fileÊôÐÔÖÆ¶¨Òª°üº¬µÄÎļþµÄÃû×Ö£¨×¢ÒâÒª°üº¬µÄÎļþµÄ·¾¶£©£ ......