📄 log1.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="Beans.*" %>
<%
//判断是否返回到登陆页面：
response.setCharacterEncoding("GBK");
if(session.isNew())
response.sendRedirect("login.jsp");
%>
<html>
<head>
<title>租/还书日志浏览</title>
<LINK REL=STYLESHEET HREF="../CSS/style.css" TYPE="TEXT/CSS">
</head>
<br><img src="../imgs/disc2.jpg">
<body bgcolor="#EFFBFE" leftmargin="0" topmargin="0" link="#666666" vlink="#336699" alink="#666666">
<a href=index.html>主页>> </a><a href=management.jsp>管理>></a><hr>
<input type="submit" name=submit color="blue" ><br>
<img src="../imgs/color.JPG">
<ul><li><b><font color=blue>以下是所有租/还日志:<b></font></li></ul><br>
<%-- 以下是信息的分页输出设置 每页输出6行 --%>
<%
GetRS grs=new GetRS();
String queryStr="select * from updateLog_tb";
String queryCount="select count(*) from UpdateLog_tb";
int pageSize=6;
int pageOf=1;
int totalPage=1;
int totalRecord=0;
/*连接 数据库 */
try{
ResultSet rs=null;
grs.setQueryStr(queryCount);
rs=grs.getRs();
if(rs.next()) totalRecord=rs.getInt(1);
grs.setQueryStr(queryStr);
rs=grs.getRs();
//确定totalPage的值
if(totalRecord%pageSize==0)
totalPage=totalRecord/pageSize;
else
{
totalPage=totalRecord/pageSize+1;
}
if(totalPage==0) totalPage=1;
//确定pageOf的值：当前页号
if(request.getParameter("page")==null || request.getParameter("page").equals(""))
pageOf=1;
else
{
try {
pageOf=Integer.parseInt(request.getParameter("page"));
}catch(NumberFormatException e2)
{
pageOf=1;
}
}
if(pageOf<1) pageOf=1;
if(pageOf>totalPage) pageOf=totalPage;
//定位到某一行
rs.absolute((pageOf-1)*pageSize+1);
%>
<center>
<table border=0 width=50% name=mytb bgcolor=#e1e1e1 border=1 bordercolordark=#ffffff bordercolorlight=#999999 cellpadding=1 cellspacing=5>
<tr bgcolor=009999 align=center><td colspan=4 ><font color=white size=-1>共<%=totalRecord%>条记录</font><td>
<tr bgcolor=FFCC00 align=middle>
<td height=40% width=37%><font color=blue> 日期</font></td>
<td height=40% width=><font color=blue> 书号</font></td>
<td height=40% width=><font color=blue> 书名</font></td>
<td height=40% width=><font color=blue> 状态</font></td>
<td height=40% width=><font color=blue> 操作</font></td>
</tr>
<%
for(int iPage=1;iPage<=pageSize;iPage++)
{
out.print("<tr bgcolor=009999 align=middle><td>"+rs.getString(1)+
"</td><td>"+rs.getString(2)+
"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td>"+
"<td>"+rs.getString(5)+"</td></tr>");
if(!rs.next()) break;
}
rs.close();
grs.close();//grs中封装了关闭connection 和 statement
}catch(Exception e3){}
%>
</table></center><br>
<form action="log1.jsp" method=get>
<center>
<%
if(pageOf!=1)
{
out.print("<a href=log1.jsp?page=1>第一页</a> ");
out.print("<a href=log1.jsp?page="+(pageOf-1)+">上一页</a> ");
}
if(pageOf!=totalPage)
{
out.print("<a href=log1.jsp?page="+(pageOf+1)+">下一页</a> ");
out.print("<a href=log1.jsp?page="+totalPage+">最后一页</a>");
}
%>
</center>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -