数据库编程

开发平台：

Java

order.jsp：源码内容

							<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page session="true" %>
<%
String username = (String)session.getAttribute("username");
if ( username == null || username.equals("") ){
	response.sendRedirect("login.jsp?msg=nologin");
}
%>
<%@ page import="bookshop.book.book "%>
<%@ page import="bookshop.util.*" %>
<%@ page import="bookshop.book.allorder" %>
<%@ page import="bookshop.run.op_book" %>
<jsp:useBean id="myIndentlist" scope="page" class="bookshop.run.op_buy" />
<jsp:useBean id="mybook" scope="page" class="bookshop.run.op_book" />
<%
String mesg = "";
long Id=0;
String indentNo = request.getParameter("orderno");
if( (indentNo==null)|| indentNo.equals("")) {
		mesg = "你要查看的订单清单不存在！";
} else {
	try {
		Id = Long.parseLong(request.getParameter("id"));
		if (!myIndentlist.getAllorder(indentNo)){
			mesg = "你要查看的订单清单不存在！";
		}
	} catch (Exception e){
		mesg = "你要查看的订单清单不存在！";
	}
}
%>
<html>
<head>
<title>隽隽电子书店　查看订购清单资料</title>
<link rel="stylesheet" href="books.css" type="text/css">
</head>
<body bgcolor="#FFCC99" text="#000000" onload="javascript:window.focus();" >
<div align="center">
  
  <% if(!mesg.equals("")){
		out.println(mesg);
	  } else {
	%>
		<p>隽隽书店图书订单<%= indentNo %>&nbsp;清单:</p>
          <table width="95%" border="1" cellspacing="1" cellpadding="1" bordercolor="#CC9966">
          <tr align="center"> 
            <td>图书名称</td>
            <td>作者</td>
            <td>图书类别</td>
            <td>单价(元)</td>
            <td>数量</td>
          </tr>
	<%
	for (int i=0; i<myIndentlist.getOrder_list().size();i++){
		allorder idList = (allorder) myIndentlist.getOrder_list().elementAt(i);
		//out.print(idList.getBookNo());
		if (mybook.getOnebook((int)idList.getBookNo()) ){
			book bk = (book) mybook.getBooklist().elementAt(0);		
	%>	  
	      <tr align="center"> 
            <td><%= bk.getBookName() %></td>
            <td><%= bk.getAuthor() %></td>
            <td><%= bk.getClassname() %></td>
            <td><%= bk.getPrince() %></td>
            <td><%= idList.getAmount() %></td>
          </tr>
	<%
		}
	}%>
		</table>
<% } %>
  <br><p><a href="javascript:window.close()">关闭窗口</a></p>
  <table width="100%" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td align="center">隽隽书店版权所有<br>
        CopyRight@2003 <br>
        Email:<a href="mailto:wxy8108123@163.com">wxy8108123@163.com</a></td>
    </tr>
  </table>
  
</div>
</body>
</html>

						