News的全部代码.docx

News的全部代码：1.Index.jsp%@ page contentType=text/html;charset=gb2312 %%@ include file=incoming/Common.jsp%%@ include file=incoming/ConnectDB.jsp%htmlheadtitle%=title%/titlelink href=incoming/style.css rel=stylesheet type=text/cssmeta http-equiv=Content-Type content=text/html; charset=gb2312/headbodycenter%@ include file=incoming/Header.jsp%table width=700 height=370 border=0 cellpadding=0 cellspacing=0 tr td width=143 valign=top background=images/left.jpgdiv align=center table width=100% border=0 cellspacing=0 cellpadding=0 tr td height=32 background=images/left_banner.gifdiv align=centerfont size=3 发新闻者排行/div/td /tr /table table width=100% height=97 border=0 cellpadding=0 cellspacing=0 tr td valign=topbr %sql1=SELECT * FROM Manager ORDER BY TotalNews DESC;rs1 = smt1.executeQuery(sql1);int i=0;while(rs1.next()){ %nbsp;a class=listfont size=3 %=i+1%.nbsp;nbsp;%=rs1.getString(ManagerID)%nbsp;nbsp;nbsp;共%=rs1.getInt(TotalNews)%篇新闻/aBR%i++;}% /td /tr /table /div /td td width=370 valign=topdiv align=center table width=100% height=50 border=0 cellpadding=0 cellspacing=0 tr tdnbsp;/td /tr /table table width=100% border=0 align=center cellpadding=0 cellspacing=0 id=table1 tbody %sql1=SELECT * FROM category;rs1 = smt1.executeQuery(sql1);while(rs1.next()) { %font color=#990000strongfont size=3 【%=rs1.getString(CategoryName)%】/strong/fontbrbr % sql2 = SELECT NewsID,Title FROM news WHERE CategoryID = +rs1.getString(CategoryID)+ ORDER BY AddDate DESC; rs2 = smt2.executeQuery(sql2); int j=1; while(rs2.next()) { if(j5){continue;} %img src=images/icon.gif width=8 height=6a href=ViewNews.jsp?id=%=rs2.getInt(NewsID)% target=_blankfont size=3 %=rs2.getString(Title)%/abr % j++; }%div align=righta href=ListNews.jsp?categoryid=%=rs1.getString(CategoryID)%categoryname=%=rs1.getString(CategoryName)%更多…/a/divbr % } % /tbody /table /div /td td width=187 valign=top background=images/right.giftable width=100% border=0 cellspacing=0 cellpadding=0 tr td height=32 background=images/left_banne