📄 checkout.jsp

📁 sql server 2005书中11到16章的全部代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center">
<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
    <tr> 
      <td height="87" align="center"><br>
      <img src="images/bookhead.jpg" width="700" height="110"> </td>
    </tr>
</table>

<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
  <tr>
      <td width="164"><div align="center"><a href="index.jsp">首页</a></div></td>
      <td width="224"><div align="center"><a href="booklist.jsp">在线购书</a></div></td>
      <td width="304" align="right"><div align="center"><a href="shopcar.jsp">我的购物车</a>      </div>        <div align="center"></div></td>
      <td width="304" align="right"><div align="center"><a href="myshop.jsp">我的订单</a></div></td>
      <td width="304" align="right"><div align="center"><a href="admin/login.jsp">网站管理</a></div></td>
      <td width="304" align="right"><div align="center">当前日期:<%=dateString%></div></td>
  </tr>
</table>
<%
	Vector buylist = (Vector)session.getValue("shopcar");
	if(buylist==null||buylist.size()<1)
		{
%>
	<jsp:forward page="index.jsp"></jsp:forward>
<%}
	String userid = (String)session.getValue("userid");
	float pricenum =0;
	for(int i=0;i<buylist.size();i++)
		{
			Book book = (Book)buylist.elementAt(i);
			pricenum = pricenum + book.getBuynum()*book.getPrice();
		}
	
	DBSQLManager dbsm = new DBSQLManager();
	String sql="INSERT INTO myorder(USER_ID, PRICE_NUM, ORDER_DATE) VALUES('"+userid+"',"+pricenum+",'"+_dateString+"')";
	dbsm.setSqlStr(sql);
	dbsm.executeUpdate();
	dbsm.close();  
	
	DBSQLManager dbsm_ = new DBSQLManager();
	String sql_="SELECT ORDER_ID FROM myorder WHERE USER_ID='"+userid+"' AND ORDER_DATE='"+_dateString+"'";
	dbsm_.setSqlStr(sql_);
	dbsm_.executeQuery();
	ResultSet rs_=dbsm_.getRs();
	rs_.next();
	String orderid = rs_.getString("ORDER_ID");
	dbsm_.close();  
	
	for(int j=0; j<buylist.size(); j++)
	{
		Book book = (Book)buylist.elementAt(j);
		DBSQLManager _dbsm = new DBSQLManager();
		String _sql="INSERT INTO orderitem(ORDER_ID, ISBN, BOOK_NUM) VALUES('"+orderid+"','"+book.getIsbn()+"','"+book.getBuynum()+"')";
		_dbsm.setSqlStr(_sql);
		_dbsm.executeUpdate();
		_dbsm.close();  
	}		
%>
<br><a class="title">谢谢您购买！</a><br>
<hr width="700">
 <table width="700" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td align="center" bgcolor="#CCCCCC">峰杰工作技术中心<br>
        CopyRight@2006<br>
      Email:<a href="mailto:zfno1@163.com">zfno1@163.com</a></td>
    </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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