?? 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 + -