JSP·ÖÒ³´úÂë

<%
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");