📄 brow.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="Beans.*" %>
<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>
<form action="brow.jsp" method=get>
<font color="blue" >选择查询条件：</font>
<select name="condition" size=1 >
<option checked value="所有书">所有书</option>
</select>
<input type="submit" name=submit color="blue" >
</form>
<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 book_info where book_name like '%%'";
String queryCount="select count(*) from book_info where book_name like '%%'";
int pageSize=6;
int pageOf=1;
int totalPage=1;
int totalRecord=0;
/*连接 数据库 */
try{
ResultSet rs;
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 width=37%><font color=blue> 编号</font></td>
<td><font color=blue> 名称</font></td>
<td><font color=blue> 状态</font></td>
<td><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.getInt(4)+"</td></tr>");
if(!rs.next()) break;
}
rs.close();
grs.close();//关闭STMT和CONN连接
}catch(Exception e2){}
%>
</table></center><br>
<form action="brow.jsp" method=get>
<center>
<%
if(pageOf!=1)
{
out.print("<a href=brow.jsp?page=1>第一页</a> ");
out.print("<a href=brow.jsp?page="+(pageOf-1)+">上一页</a> ");
}
if(pageOf!=totalPage)
{
out.print("<a href=brow.jsp?page="+(pageOf+1)+">下一页</a> ");
out.print("<a href=brow.jsp?page="+totalPage+">最后一页</a>");
}
%>
</center>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -