ÐÂÎÅÍøÒ³Éè¼Æ±¨¸æ ÏÂÔØ±¾ÎÄ

ÇëÑ¡Ôñ²éѯÀà±ð£º

ÇëÊäÈë²éѯ¹Ø¼ü×Ö£º

<%

temp=conn.executeQuery(sql2); int totalrecord=0; if(temp.next())

totalrecord=temp.getInt(1);

if(totalrecord % size == 0) totalPage = totalrecord/size;

- 13 -

else totalPage=totalrecord/size+1; if(totalPage==0) totalPage=1; temp.close(); try {

if(request.getParameter(\)==null

p=1;

p=Integer.parseInt(request.getParameter(\));

||request.getParameter(\).equals(\))

else

}catch(NumberFormatException e){p=1;} if(p<1) p=1;

if(p>totalPage) p=totalPage; rs=conn.executeQuery(sql1); if(rs.next())

out.println(printPage(rs,p,size));

%>

±êÌâ×÷ ÕßÈÕÆÚ

<%

for(int i=1;i<=totalPage;i++){ }

out.println(\

href=index.jsp?p=\+i+\+i+\); %>

ÊäÈëÒ³Êý£º

Ò³Êý£º<%=p %>/<%=totalPage %> ¼ÌÐø·¢²¼   

2) ϵͳµ¼º½À¸Ò³Ãæ

- 14 -

4.3ÐÂÎÅ·¢²¼Ä£¿é

´ËÄ£¿éÌṩÐÂÎÅ·¢²¼¹¦ÄÜ£¬°üÀ¨ÐÂÎÅ·¢²¼Ê×Ò³£¬¼°ÐÂÎÅ·¢²¼´¦ÀíÒ³Ãæ¡£ 1£© . ÐÂÎÅ·¢²¼Ê×Ò³£ºÌṩÊäÈëÐÂÎÅÐÅÏ¢±íµ¥£¬ÈçÏÂͼ£º

Ïà¹Ø´úÂëÈçÏ£º

- 15 -

2£© ÐÂÎÅ·¢²¼´¦ÀíÒ³Ãæ£º

3£©

4£©

±à¼­ÐÂÎÅ

5£©

·µ»Ø¹ÜÀíÒ³

Ãæ

6£©
7£© <%

8£© String editid=\; 9£© String title=\; 10£© 11£© 12£© 13£© 14£© 15£© 16£© 17£© 18£© 19£© 20£© 21£© 22£© 23£© 24£© 25£©

String content=\; String author=\; String pubdate=\;

if(request.getParameter(\)!=null)

editid=request.getParameter(\);

//Éú³É²éѯSQLÓï¾ä£¬²éÕÒidΪ±äÁ¿editidµÄ¼Ç¼

String sql =\+editid; ResultSet rs=null;

rs=conn.executeQuery(sql); if(rs.next()){

//¶ÁÈ¡µ±Ç°¼Ç¼µÄ¸÷×Ö¶ÎÖµ

title=rs.getString(\); content=rs.getString(\); author=rs.getString(\); pubdate=rs.getString(\);

%>

26£©

onSubmit=\> 27£©

\>

28£©

borderColor=\width=\> 29£©

- 16 -