?? bookmanage.jsp
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,bean.DBClass" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>圖書(shū)管理</title>
<link href="source/bookshop.css" rel="stylesheet" type="text/css">
</head>
<% if(session.getAttribute("adminId")==null) { %>
<jsp:forward page="/notLogin.jsp" />
<% } else { %>
<body>
<div id="masthead">
<jsp:include page="/utility/siteName.jsp" />
<jsp:include page="/utility/bar.jsp" />
</div>
<div id="pagecell1">
<div id="breadCrumb">
<table width="100%" border="0">
<tr>
<% String requestURL= request.getRequestURI();
String param=request.getQueryString();
String hidAddr="/bookshop/MenuHidden?jspURL=" + requestURL +"¶m="+ param ;
String showAddr="/bookshop/MenuShow?jspURL=" + requestURL +"¶m="+ param ; %>
<td width="211"><a href=<%= hidAddr %> align="left">隱藏</a> / <a href=<%= showAddr %>>顯示</a> </td>
<td width="516"></td>
</tr>
</table>
</div>
<table width="100%" border="0">
<tr valign="top">
<% if(session.getAttribute("hidden")==null){ %>
<jsp:include page="/utility/adminMenu.jsp" />
<% } %>
<td width="81%" >
<div class="book">
<form name="form" method="post" action="/bookshop/DeleteBook">
<table width="100%" border="0" >
<tr>
<td background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td>
</tr>
<tr>
<td height="11" bgcolor="#FFFFFF" >
<table width="100%" border="0" >
<tr>
<td width="5%"><div align="left">刪除</div></td>
<td width="8%"><div align="left">ID</div></td>
<td width="21%"><div align="left">書(shū)名</div></td>
<td width="20%"><div align="left">作者</div></td>
<td ><div align="left">出版社</div></td>
<td width="8%"><div align="left">類別</div></td>
<td width="10%"><div align="left">單價(jià)</div></td>
<td width="8%"><div align="left">推薦</div></td>
<td ><div align="left">操作</div></td>
</tr>
<tr>
<td colspan="9"><hr></td>
</tr>
<%
String pg="";
if(request.getParameter("pg")==null){
pg="1";
}else{
pg=request.getParameter("pg");
}
int index=(Integer.parseInt(pg)-1)*30;
String query="SELECT * FROM book";
DBClass db=new DBClass();
db.connect();
ResultSet resultset=db.executeQuery(query);
for(int i=0;i<index;i++){
resultset.next();
}
int n=0;
while(resultset.next()&&n<30){
n++;
String bookId=resultset.getString("id");
String commentURL="/bookshop/commentManage.jsp?bookId="+bookId;
String changeURL="/bookshop/changeBookInf.jsp?bookId="+bookId;
%>
<tr>
<td ><div align="center">
<input name="bookId" type="checkbox" id="bookId" value="<%= bookId %>">
</div></td>
<td ><%= bookId %></td>
<td ><%= resultset.getString("name") %></td>
<td><%= resultset.getString("author") %></td>
<td><%= resultset.getString("publisher") %></td>
<td><%= resultset.getString("type") %></td>
<td>¥ <%= resultset.getString("price") %></td>
<td><%= resultset.getString("ifNew") %></td>
<td><a href=<%= changeURL %>><font color="black">修改</font></a></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<tr>
<td height="5" background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td>
</tr>
</table>
<table width="100%" border="0">
<tr>
<td width="25%"><input type="submit" name="Submit" value="刪除"> <a href="/bookshop/addBook.jsp"><font color="black">添加圖書(shū)</font>
</a></td>
<td width="75%">
<%
String pre="/bookshop/bookManage.jsp?pg="+Integer.toString(index/30);
String aft="/bookshop/bookManage.jsp?pg="+Integer.toString(index/30+2);
if(pg.equals("1")){
if(resultset.next()){ %>
<div align="right">上一頁(yè)/<a href=<%= aft %>>下一頁(yè)</a></div>
<% }else{ %>
<div align="right">上一頁(yè)/下一頁(yè)</div>
<% }
} else {
if(resultset.next()){ %>
<div align="right"><a href=<%= pre %>>上一頁(yè)</a>/<a href=<%= aft %>>下一頁(yè)</a></div>
<% } else { %>
<div align="right"><a href=<%= pre %>>上一頁(yè)</a>/下一頁(yè)</div>
<% }
}
db.closeConnection();
%>
</td>
</tr>
</table>
</form>
</div>
</td>
</tr>
</table>
<jsp:include page="/utility/copyRight.jsp" />
</div>
<br>
</body>
<% } %>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -