< %@ page import ="java.sql.*" % > < %@ page import ="java.io.*" % > < %@ page import ="java.util.*" % > < jsp:useBean id ="sqlconn" scope ="page" class ="kk.database.sqlconn" /> < %! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; % > <! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > < HTML > < HEAD > < TITLE > ArticleList </ TITLE > < META NAME ="Generator" CONTENT ="jBuilder3.5 && jEdit1.0" > < META NAME ="Author" CONTENT ="bigangell" > < META NAME ="Keywords" CONTENT ="Java,Servlet,Jsp,Beans,PHP" > < META NAME ="Description" CONTENT ="A Pure World For Programming Include C/C++,Java" > < META HTTP-EQUIV ="Content-Type" CONTENT ="text/html; CHARSET=gb2312" > < link rel ="stylesheet" href ="style.css" > </ head > < body bgcolor ="#FFFFFF" > < table width ="760" border ="0" cellspacing ="0" cellpadding ="0" align ="center" > < tr > < td > < table width ="750" border ="0" cellspacing ="2" cellpadding ="2" align ="center" > < tr align ="center" > < td > </ td > </ tr > < tr > < td > < table width ="740" border ="0" cellspacing ="1" cellpadding ="1" align ="center" > < tr align ="center" bgcolor ="#CCCCCC" > < td >< b > 标题 </ b ></ td > < td >< b > 作者 </ b ></ td > < td >< b > 类型 </ b ></ td > < td >< b > 点击 </ b ></ td > < td >< b > 加入时间 </ b ></ td > </ tr > < % int i; int ipage =10; //分页单位 int allpage; //总页数 int pages; //接受的页码变量 int cpage =1; //当前页 int spage; //开始页 //数据库连接声明 java.lang.String sql,pagesql; java.sql.ResultSet rs,pagers; pagesql = "select count(a_id) as A from article" ; //取总文章数 pagers = sqlconn.executeQuery(pagesql); int allCol = pagers.getInt("A"); //获得总页面数 allpage = (int)Math.ceil((allCol + ipage-1) / ipage); //判断参数pages是否为空 if (request.getParameter("pages") ==null) { pages =1; } else { pages = new Integer(request.getParameter("pages")).intValue(); } //判断当前页 if(pages > allpage // pages == 0){ cpage = 1; } else { cpage = pages; } //判断起始页 spage=(cpage-1)*ipage; sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit "+ spage +","+ ipage; rs = sqlconn.executeQuery(sql); int cu=1; //循环取数据库值 while (rs.next()) { int aID = rs.getInt("a_id"); aTitle = rs.getString("a_title"); aAuthor = rs.getString("a_author"); int ArticleTypeID = rs.getInt("aID"); int ReadTime = rs.getInt("a_readtime"); InsertTime = rs.getString("a_time"); if (cu % 2 == 0) { Color="#DBECFD"; } else { Color="#C6E1FD"; } switch (ArticleTypeID) { case(1): ArticleType="小说"; break; case(2): ArticleType="散文"; break; case(3): ArticleType="诗歌"; break; case(4): ArticleType="随笔"; break; } %> < tr bgcolor ="<%= Color %>" > < td width ="300" >< a href ="viewarticle.jsp?aID=<%= aID %>" >< %= aTitle % ></ a ></ td > < td align ="center" width ="100" >< %= aAuthor % ></ td > < td align ="center" width ="50" >< %= ArticleType % ></ td > < td align ="center" width ="50" >< %= ReadTime % ></ td > < td align ="center" width ="240" >< %= InsertTime % ></ td > </ tr > < % cu ++; } % > < tr bgcolor ="#CCCCCC" > < td colspan ="5" align ="right" valign ="middle" > 共 < %= allCol % > 条记录 共 < %= allpage % > 页 < % if (cpage > 1) { %> < a href ="article.jsp?pages=<%= cpage-1 %>" >< img src ="images/prev.gif" border ="0" ></ a >< % } if (cpage<allpage) { % >< a href ="article.jsp?pages=<%= cpage+1 %>" >< img src ="images/next.gif" border ="0" ></ a >< % } % > / < % for (i =1;i<=allpage;i++) { if (i ! = pages) {% >< a href ="article.jsp?pages=<%= i %>" >< %= i % ></ a > < % } }% ></ td > </ tr > </ table > </ td > </ tr > </ table > </ td > </ tr > </ table > </ body > </ html >