📄 booklist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("error.htm");
} %>
<%@ page import="com.bookshop.bean.*"%>
<jsp:useBean id="book_list" scope="page" class="com.bookshop.dao.Booksmn" />
<%
int pages=1;
String mesg = "";
if (request.getParameter("action")!=null && request.getParameter("action").equals("del")){
try {
int delid = Integer.parseInt(request.getParameter("id"));
if (book_list.delete(delid)){
mesg = "删除成功！";
} else {
mesg = "删除出错！";
}
} catch (Exception e){
mesg = "你要删除的对象错误!";
}
}
if (request.getParameter("page")!=null && !request.getParameter("page").equals("")) {
String requestpage = request.getParameter("page");
try {
pages = Integer.parseInt(requestpage);
} catch(Exception e) {
mesg = "你要找的页码错误!";
}
}
%>
<html>
<head>
<title>倾城书屋管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>a{TEXT-DECORATION:none}a:hover{TEXT-DECORATION:underline}</style>
<script language="JavaScript">
setInterval("a.innerHTML=new Date().toLocaleString()+' 星期'+'日一二三四五六'.charAt(new Date().getDay());",1000);
</script>
<script language="javascript">
<script language="javascript">
function openScript(url,name, width, height){
var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script>
<link rel="stylesheet" href="books.css" type="text/css">
<style type="text/css">
<!--
.style14 {color: #3366FF}
.style16 {font-size: 18px; color: #3366FF;}
.style17 {font-size: 14px}
.style18 {color: #3366FF; font-size: 14px; }
.style20 {color: #3366FF; font-size: 16; }
.style21 {font-size: 16; }
-->
</style>
</head>
<body text="#000000">
<div align="center">
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><img src="../images/title.jpg" width="744" height="100"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="1" cellpadding="1" >
<tr>
<td width="100" height="30" align="center" background="../images/qntj.jpg" class="style14"><a href="../index.jsp" class="style18">首页</a></td>
<td width="100" align="center" background="../images/qntj.jpg" class="style14"><a href="../booklist.jsp" class="style18">在线购物</a></td>
<td width="100" align="center" background="../images/qntj.jpg" class="style14"><a href="../shoperlist.jsp" class="style18">我的购物车</a></td>
<td width="100" align="center" background="../images/qntj.jpg" class="style14"><a href="../login.jsp" class="style18">用户登录</a></td>
<td width="100" align="center" background="../images/qntj.jpg" class="style14"><a href="../manage/login.jsp" class="style14 style17">网站管理</a></td>
<td width="250" align="center" background="../images/qntj.jpg"><div id="a"><span class="style7"></span></div></td>
</tr>
</table>
<p> </p>
<div align="center">
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" width="23%" valign="top">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="30"> </td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="main.jsp" class="style21">回管理首页</a></td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="booklist.jsp" class="style21">商店图书查询</a></td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="addbook.jsp" class="style21">添加图书资料</a></td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="orderlist.jsp" class="style21">订单信息查询</a></td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="userlist.jsp" class="style20">用户信息查询</a></td>
</tr>
<tr>
<td height="30" align="center" class="style14"><a href="logout.jsp" class="style21">退出</a></td>
</tr>
</table>
</td>
<td align="center" width="77%">
<p> <% if (!mesg.equals("")) out.println(mesg);%></p>
<p class="style16">倾城当前图书情况:</p>
<table width="90%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CC0000">
<tr align="center">
<td height="35">编号</td>
<td>图书名</td>
<td>作者</td>
<td>类别</td>
<td>单价</td>
<td>总数量</td>
<td>剩余数</td>
<td>动作</td>
</tr>
<% if (book_list.execute(request)) {
for (int i=0;i<book_list.getBooklist().size();i++){
Books bk = (Books) book_list.getBooklist().elementAt(i);
%>
<tr>
<td height="33" align="center"><%=bk.getId() %></td>
<td><a href="#" onclick="openScript('showbook.jsp?bookid=<%= bk.getId() %>','sbook',450,500);"><%= bk.getBookName() %></a></td>
<td align="center"><%= bk.getAuthor() %></td>
<td align="center"><%= bk.getClassname() %></td>
<td align="center"><%= bk.getPrince() %></td>
<td align="center"><%= bk.getAmount() %></td>
<td align="center"><%= bk.getLeav_number() %></td>
<td align="center"><a href="modibook.jsp?id=<%= bk.getId() %>">修改</a> <a href="booklist.jsp?action=del&page=<%= pages %>&id=<%= bk.getId() %>" onclick="confirm('真的要删除吗');">删除</a></td>
</tr>
<% }
} else {%>
<tr>
<td height="34" colspan=8 align="center"> 网站正在维护中，请稍后......</td>
</tr>
<% } %>
</table>
<br>
<table width="89%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td height="34" align="right">当前页第<%= book_list.getPage() %>页 <a href="booklist.jsp">首页</a>
<% if (book_list.getPage()>1) {%><a href="booklist.jsp?page=<%= book_list.getPage()-1 %>">上一页</a> <% } %>
<% if (book_list.getPage()<book_list.getPageCount()-1) {%><a href="booklist.jsp?page=<%= book_list.getPage()+1 %>">下一页</a> <% } %>
<a href="booklist.jsp?page=<%= book_list.getPageCount() %>">未页</a> </td>
</tr>
</table>
<p> </p>
</td>
</tr>
</table>
<p> </p>
<hr width="750" color="#00CCFe"/>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" >
<div align="center" class="style11">06计算机科学与技术3班
<br>
CopyRight@2009
<br>
E-mail:
<a href="mailto:dengxianghai2005@163.com">Jinlf112@163.com</a>
</div></td>
</tr>
</table>
</div>
</body>
</html>
<% book_list.close();%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -