📄 order.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@ page import="java.util.Vector"%>
<%@ page import="beans.bookelement"%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<HTML>
<HEAD>
<TITLE>Site Title</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<style type="../../web/text/css">
<!--
@import url("../../web/css_link.css");
@import url("../../web/text.css");
@import url("../../web/css_link.css");
-->
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="100%" height="397" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="386" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" height="397" valign="top" background="../../web/images/side_back.jpg">
<table width="100%" height="398" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="398" valign="top" background="../../web/images/home_side.jpg"> </td>
</tr>
</table>
</td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" height="525" border="0" cellpadding="2" cellspacing="2">
<tr>
<td height="521" valign="top">
<br>
<table width="80%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr valign="middle">
<td colspan="5"> <div align="left"><strong><font size="2">商品订购清单</font></strong></div></td>
</tr>
<tr valign="middle">
<td width="103"><div align="center"><font size="2">商品</font></div></td>
<td width="207"><div align="center"><font size="2">商品</font></div></td>
<td width="103"><div align="center"><font size="2">定价</font></div></td>
<td width="96"><div align="center"><font size="2">数量</font></div></td>
<td width="112"><div align="center"><font size="2">小计</font></div></td>
</tr>
<%Vector cart=(Vector)session.getAttribute("cart");
float sum=0;
float price=0;
String bookid="";
String bookname="";
int number=0;
for(int i=0;i<cart.size();i++){
bookelement mybookelement=(bookelement)cart.elementAt(i);
bookid=(String)mybookelement.bookid;
price=mybookelement.price;
number=mybookelement.number;
sum=sum+mybookelement.number*mybookelement.price;
if(bookid!=""){
ResultSet rs=conndb.executeQuery("select * from bookdata where bookid='"+bookid+"'");
if(rs.next()){bookname=rs.getString("bookname");}}
%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center"><%=bookid%></div></td>
<td bgcolor="E0E0E0"><div align="center"><%=bookname%></div></td>
<td bgcolor="E0E0E0"><div align="center"><%=price%></div></td>
<td bgcolor="E0E0E0"><div align="center"><%=number%></div></td>
<td bgcolor="E0E0E0"><div align="center"><%=(price*number)%></div></td>
</tr>
<%}%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"> </td>
<td bgcolor="E0E0E0"> </td>
<td bgcolor="E0E0E0"> </td>
<td valign="middle" bgcolor="E0E0E0"> <div align="right"><font size="2">合计：</font></div></td>
<td valign="middle"><font size="2">￥ <%=sum%>元</font></td>
</tr>
</table>
<br>
<%String Username=(String)session.getAttribute("Username");
ResultSet rs=conndb.executeQuery("select * from userdata where username='"+Username+"'");
if(rs.next()){
%>
<table width="80%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr valign="middle">
<td colspan="4"> <div align="left"><strong><font size="2">用户详细信息</font></strong></div></td>
</tr>
<tr bgcolor="E0E0E0" valign="middle">
<td width="117" bgcolor="E0E0E0"><div align="center"><font size="2">真实姓名</font></div></td>
<td width="198" bgcolor="E0E0E0"><font size="2"><%=rs.getString("truename")%></font></td>
<td width="114" bgcolor="E0E0E0"><div align="center"><font size="2">联系电话</font></div></td>
<td width="195" bgcolor="E0E0E0"><font size="2"><%=rs.getString("tel")%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="middle">
<td><div align="center"><font size="2">所在城市</font></div></td>
<td bgcolor="E0E0E0"><font size="2"><%=rs.getString("city")%></font></td>
<td bgcolor="E0E0E0"><div align="center"><font size="2">Email</font></div></td>
<td bgcolor="E0E0E0"><font size="2"><%=rs.getString("email")%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="middle">
<td bgcolor="E0E0E0"><div align="center"><font size="2">详细地址</font></div></td>
<td colspan="3" bgcolor="E0E0E0"><font size="2"><%=rs.getString("address")%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="middle">
<td height="17" bgcolor="E0E0E0"> <div align="center"><font size="2">邮政编码</font></div></td>
<td colspan="3" bgcolor="E0E0E0"><font size="2"></font><font size="2"><%=rs.getString("postcode")%></font></td>
</tr>
</table>
<form name="orderform" method="post" action="order_deal.jsp">
<table width="80%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr bgcolor="E0E0E0" valign="top">
<td width="117" valign="middle" bgcolor="E0E0E0"><div align="center"><font size="2">发货方式</font></div></td><td width="513" bgcolor="E0E0E0"><div align="center">
<select name="carry">
<option>送货上门</option>
<option>挂号邮寄</option>
<option>特快专递</option>
</select>
</div></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td valign="middle" bgcolor="E0E0E0"><div align="center"><font size="2">付款方式</font></div></td>
<td bgcolor="E0E0E0"><div align="center">
<select name="pay">
<option>货到付款</option>
<option>邮局汇款</option>
<option>银行电汇</option>
</select>
</div></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td valign="middle" bgcolor="E0E0E0"><div align="center"><font size="2">备注</font></div></td>
<td bgcolor="E0E0E0"> <div align="center">
<textarea name="message" cols="35" rows="3"></textarea>
</div></td>
</tr>
</table>
<br>
<table width="100%" align="center">
<tr>
<td width="100%" height="23">
<div align="center">
<input name="submit522" type="submit" id="submit522" value="提交" >
<input name="submit2222" type="button" id="submit2222" value="取消" onClick="history.back(1);">
</div></td>
</tr>
</table>
</form>
<%}else{%>
<table width="100%">
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><font size="2"><%out.println("请重新登录");session.removeAttribute("cart");%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="确定" onClick="window.location.href='../book/index.jsp';">
</div></td>
</tr>
</table>
<%}%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div align="center"></div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" height="19" valign="top" background="../../web/images/link_bar_hold.jpg"><img src="../../web/images/link_bar_hold.jpg" width="9" height="23"></td>
<td width="99%" background="../../web/images/link_bar_hold.jpg"><div align="center">:
<a href="#">License Agreemen</a>t : <a href="#">Jobs</a> : <a href="#">Site
Map</a> :</div></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="34" bgcolor="#000000"><div align="center">
<p class="smWhite">2003 Copyright Information or webmaster information</p>
</div></td>
</tr>
</table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -