?? adminbrow.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">
<%
if(session.isNew())
response.sendRedirect("login.jsp");
%>
</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>
<img src="../imgs/color.JPG">
<ul><li><b><font color=blue>以下是所有圖書信息:<b></font></li></ul><br>
<%-- 以下是信息的分頁輸出設(shè)置 每頁輸出6行 --%>
<%
int tempInt=0;
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;
/*連接 數(shù)據(jù)庫 */
try{
ResultSet rs;
grs.setQueryStr(queryCount); //得到數(shù)量
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);
%>
<form name=form1 action="mul.jsp" onsubmit="return check()">
<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> 狀態(tài)</font></td>
<td><font color=blue> 價格</font></td>
<td><font color=blue> ----</font></td>
</tr>
<%
for(int iPage=1;iPage<=pageSize;iPage++)
{
tempInt=iPage; //tempint是用做全選的作用
String temp=rs.getString(1);
out.print("<tr bgcolor=009999 align=middle><td>"+temp+
"</td><td>"+rs.getString(2)+
"</td><td>"+rs.getString(3)+"</td>"+
"<td>"+rs.getInt(4)+"</td>");
out.print("<td><input type=checkbox value="+temp+" name=k"+iPage+"></td></tr>");
if(!rs.next()) break;
}
rs.close();
grs.close();//關(guān)閉STMT和CONN連接
}catch(Exception e2){}
%>
</table></center><br>
<center>
<%
if(pageOf!=1)
{
out.print("<a href=adminbrow.jsp?page=1>第一頁</a> ");
out.print("<a href=adminbrow.jsp?page="+(pageOf-1)+">上一頁</a> ");
}
if(pageOf!=totalPage)
{
out.print("<a href=adminbrow.jsp?page="+(pageOf+1)+">下一頁</a> ");
out.print("<a href=adminbrow.jsp?page="+totalPage+">最后一頁</a>");
}
session.setAttribute("countOfCheckBox",new Integer(tempInt));
%>
<hr>
</center>
<center>
<table cellpadding=1 cellspacing=5><tr align=middle><td width=><input type=button name=sel value="全選" onclick="selectAll()">
<td><input type=button value="反選" onclick="unselect()"></td>
<td><input type=submit value="租借" name="lent"></td>
<td><input type="submit" value="刪除" name="del"></td><td>
<input type=button value="添加" onclick="addBookWin()"> </td><tr></table>
</center>
</form>
</body>
<Script LANGUAGE="JavaScript">
function addBookWin()
{
window.location="add.jsp";
}
function selectAll()
{
<%
for(int i=1;i<=tempInt;i++)
out.print("document.form1.k"+i+".checked=true;");
%>
}
function unselect()
{
<%
for(int i=1;i<=tempInt;i++)
out.print("document.form1.k"+i+".checked=false;");
%>
}
function check()
{
<%
for(int i=1;i<=tempInt;i++)
{
String str1=(new Integer(tempInt)).toString();
%>
if(document.form1.k<%=str1%>.checked==false) document.form1.k<%=str1%>.value=null;
<%
}
%>
}
</Script>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -