<
%@ 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 >
< %@ 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 >