⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 booklist.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意: 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
	response.sendRedirect("error.htm");
} %>
<%@ page import="org.pan.web.book.books"%>
<jsp:useBean id="book_list" scope="page" class="org.pan.web.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">
<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">
</head>

<body bgcolor="#BAD9FA" text="#000000">
<div align="center">
  <table width="100%" border="0" cellspacing="2" cellpadding="2">
    <tr> 
      <td align="center" width="23%"><img src="../images/javabeans.gif" width="126" height="88"></td>
      <td align="center" width="77%"><img src="../images/baners.gif" width="468" height="60"></td>
    </tr>
    <tr>
      <td align="center" width="23%" valign="top"> 
        <table width="100%" border="0" cellspacing="2" cellpadding="2">
          <tr> 
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td align="center"><a href="main.jsp">回管理首页</a></td>
          </tr>
          <tr> 
            <td align="center"><a href="booklist.jsp">商店商品查询</a></td>
          </tr>
          <tr> 
            <td align="center"><a href="addbook.jsp">添加商品资料</a></td>
          </tr>
          <tr> 
            <td align="center"><a href="orderlist.jsp">订单信息查询</a></td>
          </tr>
          <tr> 
            <td align="center"><a href="userlist.jsp">用户信息查询</a></td>
          </tr>
          <tr> 
            <td align="center"><a href="logout.jsp">退出</a></td>
          </tr>
        </table>
      </td>
      <td align="center" width="77%">
        <p>&nbsp;<% if (!mesg.equals("")) out.println(mesg);%></p>
        <p>极限空间电子商务当前商品情况:</p>
        <table width="90%" border="1" cellspacing="2" cellpadding="2" bordercolor=#CC0000>
          <tr align="center"> 
            <td>编号</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 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>&nbsp;&nbsp;<a href="booklist.jsp?action=del&page=<%= pages %>&id=<%= bk.getId() %>" onclick="confirm('真的要删除吗');">删除</a></td>
          </tr>
<% }
} else {%>
          <tr> 
            <td align="center" colspan=8>&nbsp;网站正在维护中,请稍后......</td>
            
          </tr>
<% } %>
        </table>
        <br>
        <table width="85%" border="0" cellspacing="1" cellpadding="1">
          <tr>
            <td align="right">当前页第<%= book_list.getPage() %>页 <a href="booklist.jsp">首页</a>&nbsp;
	<% if (book_list.getPage()>1) {%><a href="booklist.jsp?page=<%= book_list.getPage()-1 %>">上一页</a>&nbsp;<% } %>
	<% if (book_list.getPage()<book_list.getPageCount()-1) {%><a href="booklist.jsp?page=<%= book_list.getPage()+1 %>">下一页</a>&nbsp;<% } %>
				<a href="booklist.jsp?page=<%= book_list.getPageCount() %>">未页</a>&nbsp;</td>
          </tr>
        </table>
        <p>&nbsp;</p>
      </td>
    </tr>
  </table>
  <br>
  <table width="70%" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td align="center">多智能网络有限公司开发<br>
        CopyRight@2003 <br>
        Email:<a href="mailto:pz990@163.net">pz990@163.net</a></td>
    </tr>
  </table>
  
</div>
</body>
</html>
<% book_list.close();%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -