📄 book.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="sqlconn" scope="page" class="mysql.MySqlCon" />
<!-- date 2006-4-25
感谢zhjb的帮助...
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>修改过后的分页器</title>
<html>
<body bgcolor="#3A6EA5">
<%
sqlconn.setDbName("first");
sqlconn.setUser("test");
sqlconn.setPass("123456");%>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td></td>
</tr>
</table>
<table width="750" border="0" cellspacing="2" cellpadding="2" align="center">
<tr align="center">
<td> </td>
</tr>
<tr>
<td> </td></tr>
<table width="740" border="0" cellspacing="1" cellpadding="1" align="center">
<tr align="center" bgcolor="#fffbf78">
<td><b><font color="#662c2d">标题</font></b></td>
<td><b><font color="#662c2d">作者</font></b></td>
<td><b><font color="#662c2d">类型</font></b></td>
<td><b><font color="#662c2d">加入时间</font></b></td>
</tr>
<%
int i;
int ipage=10; //分页单位
int allpage; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //开始页
String selectsql2="select count(a_id) as C from book";
ResultSet rs1=sqlconn.selectLog(selectsql2);
rs1.next(); //这里我出过错，不写这个的话，数据就不能赋给其它的变量
int allCol=rs1.getInt(1);
//获得总页面数
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;
//每页只显示10个页号
int [] disp=new int[1000];
for(i=1;i<1000;i++)
if(i%10==0)
disp[i]=i/10;
else disp[i]=i/10+1;
int cu=1;
String Color=""; //记录行背景颜色值
//数据库连接
String selectsql1="select * from book order by a_id desc limit "+ spage +","+ ipage;
rs1=sqlconn.selectLog(selectsql1);
while(rs1.next())
{
String aID=rs1.getString(4);
String ArticleType="";
int ArticleTypeID =Integer.parseInt(aID);
switch (ArticleTypeID) {
case(1):
ArticleType="小说";
break;
case(2):
ArticleType="散文";
break;
case(3):
ArticleType="诗歌";
break;
case(4):
ArticleType="随笔";
break;
}
if (cu++%2==0) { Color="#DBECFD"; }
else { Color="#C6E1FD"; }
%>
<tr align="center" bgcolor=<%=Color%>>
<td><b><%=rs1.getString(2)%></b></td>
<td><b><%=rs1.getString(3)%></b></td>
<td><b><%=ArticleType%></b></td>
<td><b><%=rs1.getString(5)%></b></td>
</tr>
<%
}%>
<tr bgcolor="#fffbf78">
<td colspan="5" align="center" valign="middle">
<b><font color="#662c2d">共 <%= allCol %>条记录 共 <%= allpage %>页
<% if (cpage>1) { %>
<a href="book.jsp?pages=<%= cpage-1 %>"><img src="images/prev.gif" border="0"></a>
<% }
for (i=(disp[cpage]-1)*10+1;i<=allpage&&i<=(disp[cpage]*10);i++)
{
if (i != pages) {%>
<a href="book.jsp?pages=<%= i %>"><%= i %></a> <%
}
}
if (cpage<allpage)
{ %><a href="book.jsp?pages=<%= cpage+1 %>"><img src="images/next.gif" border="0"></a>
<% } %>
</font></b></td>
</tr>
</table>
<%rs1.close();
sqlconn.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -