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

´¿JSP·ÖÒ³´úÂëÖ®Mysql

//ÔËÐÐͼ:
//Á¬½Ó×Ö·û´®
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName(driverName).newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
//ÿҳÏÔʾ¼Ç¼Êý
int PageSize = 8;
int StartRow = 0; //¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
int PageNo=0;//ÐèÒªÏÔʾµÄÒ³Êý
int CounterStart=0;//ÿҳҳÂëµÄ³õʼֵ
int CounterEnd=0;//ÏÔʾҳÂëµÄ×î´óÖµ
int RecordCount=0;//×ܼǼÊý;
int MaxPage=0;//×ÜÒ³Êý
int PrevStart=0;//ǰһҳ
int NextPage=0;//ÏÂÒ»Ò³
int LastRec=0;
int LastStartRecord=0;//×îºóÒ»Ò³¿ªÊ¼ÏÔʾ¼Ç¼µÄ±àºÅ
//»ñÈ¡ÐèÒªÏÔʾµÄÒ³Êý£¬ÓÉÓû§Ìá½»
if(request.getParameter("PageNo")==null){ //Èç¹ûΪ¿Õ£¬Ôò±íʾµÚ1Ò³
  if(StartRow == 0){
     PageNo = StartRow + 1; //É趨Ϊ1
  }
}else{
  PageNo = Integer.parseInt(request.getParameter("PageNo")); //»ñµÃÓû§Ìá½»µÄÒ³Êý
  StartRow = (PageNo - 1) * PageSize; //»ñµÃ¿ªÊ¼ÏÔʾµÄ¼Ç¼±àºÅ
}
//ÒòΪÏÔʾҳÂëµÄÊýÁ¿ÊǶ¯Ì¬±ä»¯µÄ£¬¼ÙÈç×ܹ²ÓÐÒ»°ÙÒ³£¬Ôò²»¿ÉÄÜͬʱÏÔʾ100¸öÁ´½Ó¡£¶øÊǸù¾Ýµ±Ç°µÄÒ³ÊýÏÔʾ
//Ò»¶¨ÊýÁ¿µÄÒ³ÃæÁ´½Ó
//ÉèÖÃÏÔʾҳÂëµÄ³õʼֵ!!
  if(PageNo % PageSize == 0){
   CounterStart = PageNo - (PageSize - 1);
  }else{
   CounterStart = PageNo - (PageNo % PageSize) + 1;
  }
CounterEnd = CounterStart + (PageSize - 1);
%>
<html>
<head>
<title>·ÖÒ³ÏÔʾ¼Ç¼</title>
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<%
//»ñÈ¡×ܼǼÊý
ResultSet rs = statement.executeQuery("select count(*) from items" );
rs.next();
RecordCount = rs.getInt(1);
rs = statement.executeQuery("SELECT image_url,author,price,item_id from items ORDER BY item_id DESC LIMIT "
       +StartRow+", "+PageSize);
//»ñÈ¡×ÜÒ³Êý
MaxPage = RecordCount % PageSize;
if(RecordCount % PageSize == 0){
  MaxPage = RecordCoun


Ïà¹ØÎĵµ£º

jspµÄsessionÏê½â


http://www.egzcn.com/article/webbc/JSP/2006-03-22/2003.html À´Ô´
ÕªÒª£ºËäÈ»session»úÖÆÔÚwebÓ¦ÓóÌÐòÖб»²ÉÓÃÒѾ­ºÜ³¤Ê±¼äÁË£¬µ«ÊÇÈÔÈ»ÓкܶàÈ˲»Çå³þsession»úÖÆµÄ±¾ÖÊ£¬ÒÔÖÁ²»ÄÜÕýÈ·µÄÓ¦ÓÃÕâÒ»¼¼Êõ¡£±¾ÎĽ«ÏêϸÌÖÂÛsessionµÄ¹¤×÷»úÖÆ²¢ÇÒ¶ÔÔÚJava web applicationÖÐÓ¦ÓÃsession»úÖÆÊ±³£¼ûµÄÎÊÌâ×÷ ......

jsp¹ýÂËÆ÷Ö´ÐÐ˳Ðò

ÔÚÒ»¸ö´óÐÍÏîÄ¿ÖÐÍùÍùÓжà¸öservlet¹ýÂËÆ÷£¬µ«ÊÇÕâЩservlet¹ýÂËÆ÷µÄÖ´ÐÐ˳ÐòÊÇÔõÑùµÄÄØ£¿ ÏîÄ¿ÖйØÓÚSSH2ÖÐOpenSessionInViewFilterµÄѧϰÑо¿£¬²âÊÔFilterµÄÏȺó˳Ðò£¡£¡
Çë¿´Ò»ÏÂÀý×Ó£º 
´´½¨Á½¸ö¼òµ¥µÄservletÎļþ 
package filter; 
import java.io.IOException; 
import javax.servlet.Filt ......

JSP/ServletµÄURLÖØ¶¨Ïò

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()ÎÞ·¨Öض ......

jsp servletÖеĹýÂËÆ÷FilterÅäÖÃ×ܽá

Ô­ÎĵØÖ·£ºhttp://hi.baidu.com/wangking/blog/item/8a109423ff3d2341ac34dec9.html
ÔÚJava web¿ª·¢Öг£»áʹÓõ½¹¦ÄÜÇ¿´óµÄ¹ýÂËÆ÷£¬Ëû±Ï¾¹ÄܸøÎÒÃÇ´øÀ´ºÜ´óµÄ·½±ã£¬µ«ÊÇÕë¶Ô¹ýÂ˵Ä×ÊÔ´ÎÒÃÇÐèÒªÏêϸµÄÁ˽âËûÃÇÔÚweb.xmlÖеÄÅäÖÃÐÅÏ¢¡£Õâ¸ö¸ù¾Ý¼¸ÖÖ³£ÓõIJ»Í¬Çé¿ö½øÐÐÁË×ܽ᣺
1¡£Èç¹ûÒªÓ³Éä¹ýÂËÓ¦ÓóÌÐòÖÐËùÓÐ×ÊÔ´£º
< ......

jspѧϰ±Ê¼Ç4

JSP×Ô¶¨Òå±êÇ©£¨tag£©
ʲôÊÇ×Ô¶¨Òå±êÇ©
1£¬Óû§×Ô¶¨ÒåµÄJavaÓïÑÔÔªËØ, ʵÖÊÊÇÔËÐÐÒ»¸ö»òÕßÁ½¸ö½Ó¿ÚµÄJavaBean;
2£¬¿ÉÒԷdz£»úÃܵغÍJSPµÄ±íʾÂß¼­ÁªÏµÔÚÒ»Æð£¬ÓÖ¾ßÓÐºÍÆÕͨJavaBeanÏàͬµÄÒµÎñÂß¼­´¦ÀíÄÜÁ¦;
3£¬µ±Ò»¸öJSPÒ³Ãæ×ª±äΪservletʱ£¬Æä¼äµÄÓû§×Ô¶¨Òå±êǩת»¯Îª²Ù×÷Ò»¸ö³ÆÎª±êÇ©handerµÄ¶ÔÏó;
4£¬¿É²Ù×÷ĬÈÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ