Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ʵÏÖÂÛ̳Ê÷ÐͽṹµÄ¾ßÌåËã·¨

ʵÏÖÂÛ̳Ê÷ÐͽṹµÄËã·¨ºÜ¶à£¬¾ßÌåÄã¿ÉÒÔÈ¥www.chinaasp.comµÄÈ«ÎÄËÑË÷Öвéѯ¡£ÎÒÏÖÔÚµÄJSPÂÛ̳²ÉÓõÄÒ²Êǵ±ÖеÄÒ»ÖÖ£º²»ÓõݹéʵÏÖÊ÷ÐͽṹµÄËã·¨£¬ÏÖÔÚÎÒ½«ÂÛ̳Ê÷ÐͽṹµÄ¾ßÌåËã·¨ºÍ´ó¼Ò½éÉÜһϣ¬ºÍ´ó¼ÒÒ»Æð½»Á÷¡£
¡¡¡¡1¡¢ÑÝʾ±íµÄ½á¹¹£º
¡¡¡¡¡¡±íÃû£ºmybbslist
¡¡¡¡¡¡×Ö¶Î ¡¡¡¡¡¡¡¡Êý¾ÝÀàÐÍ¡¡¡¡ËµÃ÷
¡¡¡¡¡¡BBSID ......

½éÉÜJSPÊý¾Ý¿â¸ß¼¶²Ù×÷

¼òµ¥½éÉÜJSPÊý¾Ý¿â²Ù×÷µÄ3¸öС¼¼ÇÉ£ºÊý¾ÝÅÅÐò£¬Ö÷/´Ó±í´¦Àí£¬ÊÂÎñ´¦Àí¡£
1¡¡Êý¾ÝÅÅÐò
ÔÚÊý¾Ý¿â¼¼ÊõÖУ¬¿ÉÒÔʹÓÃORDER×Ó¾ä¶Ô²éѯ½á¹û½øÐÐÅÅÐò
[ ORDER BY { order_by_exdivssion[ ASC | DESC]} [ ¸…n ] ]
ÆäÖУ¬order_by_exdivssionÓÃÀ´Ö¸¶¨ÒªÅÅÐòµÄÁУ»ASCÖ¸¶¨°´µÝÔö˳ÐòÅÅÁУ»DESCÖ¸¶¨°´µÝ¼õ˳ÐòÅÅÐò ......

ÔÚJSPÀïµ÷ÓÃspring¹ÜÀíµÄbeanÈ¡µÃÊý¾Ý


Ò»£º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 ......

ʹÓÃjsp¹ýÂËÆ÷µÄÍêÕûÀý×Ó

ÔÚ±¾ÆªÎÄÕÂÖн«Ê¹ÓùýÂËÆ÷½øÐбàÂëת»»¡¢µÇ½ÑéÖ¤¡¢·ÀÕ¾ÍâÌá½»µÄ¹ý³Ì£¬ÎªÁËÑÝʾ£¬ÎҰѱàÂëת»»·ÅÔÚÒ»¸öfilterÖУ¬µÇ½ÑéÖ¤ºÍ·ÀÕ¾ÍâÌá½»·ÅÔÚÁíÒ»¸öfilterÖУ¬Á½¸öfilter½øÐд®Áª¹¤×÷¡£
1¡¢ÎªÁËÑÝʾ£¬ÏÈÖÆ×÷ÕâÁ½¸öfilter
//Õâ¸öfilterÊÇΪÁË×ö±àÂëת»»£¬Ö»Òª·ÃÎÊ.jspÍøÒ³¶¼Òª¹¦¹ýÕâ¸öfilter
/**ÀàÃû£ºfilter.Encoding
*×÷ ......

jspѧϰ±Ê¼Ç2

JSPµÄ×¢ÊÍ
<%--........--%>
JSPÖ¸ÁîºÍJSP¶¯×÷£¨±ê×¼µÄJSP±êÇ©£©
JSPÖ¸ÁîµÄÓï·¨
<%@... ....%>
<%@include file="...."%> °üº¬Ö¸Á°üº¬Ö¸Áî»á½«Òª°üº¬µÄÎļþ´úÂëÔ­ÑùÊä³öµ½±¾Ò³Ã棨ÔÚ·­Òëʱ°Ñ°üº¬ÎļþµÄÄÚÈÝÒýÈë²¢ºÏ²¢£©£¬²»½øÐз­Ò룬fileÊôÐÔÖÆ¶¨Òª°üº¬µÄÎļþµÄÃû×Ö£¨×¢ÒâÒª°üº¬µÄÎļþµÄ·¾¶£©£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ