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 ......
ÔÚÒ»¸ö´óÐÍÏîÄ¿ÖÐÍùÍùÓжà¸öservlet¹ýÂËÆ÷£¬µ«ÊÇÕâЩservlet¹ýÂËÆ÷µÄÖ´ÐÐ˳ÐòÊÇÔõÑùµÄÄØ£¿ ÏîÄ¿ÖйØÓÚSSH2ÖÐOpenSessionInViewFilterµÄѧϰÑо¿£¬²âÊÔFilterµÄÏȺó˳Ðò£¡£¡
Çë¿´Ò»ÏÂÀý×Ó£º
´´½¨Á½¸ö¼òµ¥µÄservletÎļþ
package filter;
import java.io.IOException;
import javax.servlet.Filt ......
Èç¹ûÔÚÒ»¸öÏîÄ¿ÖÐ µÄjspÖмÓÈëÒÔÉÏ´úÂë ÄÇôÊä³öµÄ½á¹û »áÊÇÊ²Ã´ÄØ£¿
½á¹û£º/ÏîÄ¿Ãû
ºÇºÇ ×Ô¼ºÔÀ´ÒÔΪֻ Êǵõ½ÏîÄ¿Ãû »òÕßÖ»Êǵõ½\"/\"¿´ÁË ÕæÊDz»ÊÔ²»ÖªµÀºÇºÇ
»¹ÓÐ ½ñÌìÔÚ×öÏîÄ¿µÄʱºòÎÞÒâÖз¢ÏÖµÄ
»¹ÓС°/¡± ´ú±íµÄÊÇwebÏîÄ¿µÄ¸ùĿ¼ Èç¹ûÔÚ¸ùĿ¼Ï½¨ÁËÎļþ¼Ð Ö±½Ó д³Éhref=\"p ......
Ê×ÏÈ˵˵ΪʲôҪ¾²Ì¬»¯¡£
¶ÔÓÚÏÖÔÚµÄWeb ApplicationÀ´Ëµ£¬¶¯Ì¬Ò³ÃæÊÇÕ¼Óоø¶Ô¸ßµÄµØÎ»µÄ£¬ÕýÒòΪÓÐÁ˶¯Ì¬»¯£¬²ÅÓÐÁËÏÖÔÚWebµÄ·á¸»¶à²Ê£¬µ«ÊÇÈçͬËùÓбðµÄÊÂʵһÑù£¬ºÃ´¦ÍùÍù¶¼ÊÇÓдú¼ÛµÄ¡£
ΪÁ˲úÉú³ö¶¯Ì¬µÄЧ¹û£¬Ã¿Ò»´Î¶ÔÒ³ÃæµÄÇëÇó¶¼»áÒªÇó·þÎñÆ÷¶ÔÒ³Ãæ½øÐбàÒë»òÕßÖ´ÐУ¬ÕâЩ²Ù×÷¶¼ºÜÏûºÄϵͳ×ÊÔ´¡£Èç¹ûÕâÆÚ¼ä»¹ÓÐ ......
JSPµÄ×¢ÊÍ
<%--........--%>
JSPÖ¸ÁîºÍJSP¶¯×÷£¨±ê×¼µÄJSP±êÇ©£©
JSPÖ¸ÁîµÄÓï·¨
<%@... ....%>
<%@include file="...."%> °üº¬Ö¸Á°üº¬Ö¸Áî»á½«Òª°üº¬µÄÎļþ´úÂëÔÑùÊä³öµ½±¾Ò³Ã棨ÔÚ·Òëʱ°Ñ°üº¬ÎļþµÄÄÚÈÝÒýÈë²¢ºÏ²¢£©£¬²»½øÐзÒ룬fileÊôÐÔÖÆ¶¨Òª°üº¬µÄÎļþµÄÃû×Ö£¨×¢ÒâÒª°üº¬µÄÎļþµÄ·¾¶£©£ ......