数据库编程

开发平台：
Java

buy.jsp：源码内容
							<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page session="true" %>
<%@ page import="bookshop.book.book" %>
<jsp:useBean id="book" scope="page" class="bookshop.run.op_book" />
<jsp:useBean id="shop" scope="page" class="bookshop.run.op_buy" />
<%
String mesg = "";
String submits = request.getParameter("Submit");
int Id=0;
if (submits!=null && !submits.equals("")){
	if (shop.addnew(request)){
		mesg = "你要的图书已经放入你的购物车中！谢谢";
	} else if (shop.getIsEmpty()){
		mesg = "库存图书数量不足！只剩"+shop.getLeaveBook()+"本";
	} else {
		mesg = "暂时不能购买！";
	}
}else {
	if (request.getParameter("bookid")==null || request.getParameter("bookid").equals("")) {
			mesg = "你要购买的图书不存在！";
	} else {
		try {
			Id = Integer.parseInt(request.getParameter("bookid"));
			if (!book.getOnebook(Id)){
				mesg = "你要购买的图书不存在！";
			}
		} catch (Exception e){
			mesg = "你要购买的图书不存在！";
		}
	}
}
%>
<html>
<head>
<title>隽隽书店在线　购买图书</title>
<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' );
}
function check()
{
	if (document.form1.amount.value<1){
		alert("你的购买数量有问题");
		document.form1.amount.focus();
		return false;
	}
	return true;
}
</script>
<link rel="stylesheet" href="books.css" type="text/css">
</head>
<body bgcolor="#FFCC99" text="#000000" onload="javascript:window.focus();">
<div align="center">
  <p>隽隽书店欢迎你<font color="#CC0066">选购图书</font>！</p>
   <% if(!mesg.equals("")){
		out.println(mesg);
	  } else {
		book bk = (book) book.getBooklist().elementAt(0);			  
	%>
  <table width="90%" border="0" cellspacing="2" cellpadding="1">
    <form name="form1" method="post" action="buy.jsp">
      <tr> 
        <td align="center">图书名：<%= bk.getBookName() %></td>
      </tr>
      <tr align="center"> 
        <td>你想要的数量： 
          <input type="text" name="amount" maxlength="4" size="3" value="1"> 本</td>
      </tr>
      <tr align="center"> 
        <td>
		  <input type="hidden" name="bookid" value="<%=Id %>">
          <input type="submit" name="Submit" value="购 买" onclick="return(check());">
          <input type="reset" name="Reset" value="取 消">
        </td>
      </tr>
	   <tr align="center"> 
        <td><a href="#" onclick="openScript('detail.jsp?bookid=<%= Id %>','show',400,450)" >查看详细资料</a> </td>
      </tr>
    </form>
  </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@2004 <br>
        Email:<a href="mailto:wxy8108123@163.com">wxy8108123@163.com</a></td>
    </tr>
  </table>
  
</div>
</body>
</html>

						