📄 order.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="java.util.Date" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style8 {
font-size: 14px;
color: #0000FF;
}
.style9 {font-size: 12px}
-->
</style>
</head>
<%! //处理字符串的常用方法
public String getString(String s) {
if(s == null) s = "";
try{
byte a[] = s.getBytes("ISO-8859-1");
s = new String(a);
}
catch(Exception e) {}
return s;
}
%>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
//获取session值，以及防止非法访问本页面
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
%>
<% String total1=request.getParameter("total");
float total=Float.parseFloat(total1);
String accepter=request.getParameter("accepter");
accepter=getString(accepter);
String sendtime=request.getParameter("sendtime");
sendtime=getString(sendtime);
String address=request.getParameter("address");
address=getString(address);
String buyer=request.getParameter("buyer");
buyer=getString(buyer);
String paytype=request.getParameter("paytype");
paytype=getString(paytype);
if(paytype==null)
{paytype=""; }
String mess=request.getParameter("mess");
mess=getString(mess);
String orderdate=request.getParameter("orderdate");
orderdate=getString(orderdate);
String orderrem=mess+"-----"+buyer;
%>
<%
Calendar calendar=Calendar.getInstance();
calendar.setTime(new Date());
String year=String.valueOf(calendar.get(Calendar.YEAR)),
month=String.valueOf(calendar.get(Calendar.MONTH)+1),
day=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH));
int hour=calendar.get(Calendar.HOUR_OF_DAY),
minute=calendar.get(Calendar.MINUTE),
second=calendar.get(Calendar.SECOND);
String orderid=year+month+day+hour+minute+second;
%>
<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String str="'"+orderid+"'"+","+"'"+userid+"'"+","+"'"+accepter+"'"+","+"'"+address+"'"+","+"'"+orderrem+"'"+","+total+","+"'"+orderdate+"'"+","+'0'+","+"'"+paytype+"'"+","+"'"+sendtime+"'"+","+'0';
String condition= "INSERT INTO orderinfo VALUES"+"("+str+")";
sql.executeUpdate(condition);
rs=sql.executeQuery("select * from orderinfo where orderid="+"'"+orderid+"'");
if(rs.next())
{
Cookie[] cookies=request.getCookies();
for (int i=0;i<cookies.length-1;i++)
{
String id=cookies[i].getName();
String num=cookies[i].getValue();
String strSQL="'"+orderid+"'"+","+"'"+id+"'"+","+"'"+num+"'";
String con1= "INSERT INTO orderdetail VALUES"+"("+strSQL+")";
sql.executeUpdate(con1);
cookies[i].setMaxAge(0);
}
%>
<table width="700" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="center" valign="top">
<tr>
<td height="300" colspan="3" align="center" valign="top">
<table width="100%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="45%"><span class="style9"><img src="images/5_img3.jpg" width="74" height="91" align="absmiddle"> 您的位置：<a href="index.jsp">HOME</a> >> 生成购物订单</span></td>
<td align="left" valign="bottom"><span class="style18 style9"><img src="images/arrow_right.gif"><a href="index.jsp">花坊首页</a></span></td>
<td align="left" valign="bottom"><span class="style18 style9"><img src="images/arrow_right.gif"><A href="usercenter.jsp">会员中心</A></span></td>
<td align="left" valign="bottom"><span class="style18 style9"><img src="images/arrow_right.gif"><A href="cart.jsp">我的购物车</A></span></td>
<td align="left" valign="bottom"><span class="style18 style9"><img src="images/arrow_right.gif"><A href="help.jsp">帮助中心</A></span></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#EEE6D2" class="tableall_shop">
<tr align="center" bgcolor="#EEE6D2">
<td height="25" class="sstitle">订单提交成功</td>
</tr>
<tr bgcolor="#FAF8F1">
<td height="50" bgcolor="#FAF8F1" style="line-height:18px; ">
恭喜您！<span class="style8"><%=userid%></span>，
您的订单已提交成功（订单号：<font color="#ff0000"><%=orderid%></font>
金额：￥<font color="#ff0000"><%=total%></font>,请记住您的订单号码，方便以后查询；同时我们给您打电话以确认信息；
您选择的支付方式是<font color="#ff0000"><%=paytype%></font>，请仔细阅读下面的付款提示进行付款，以便我们尽快安排您的订单！
</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#EEE6D2" class="tableall_shop">
<tr align="center" bgcolor="#EEE6D2">
<td height="25" class="sstitle">网上支付</td>
</tr>
<tr bgcolor="#FAF8F1">
<td height="50" bgcolor="#FAF8F1" style="line-height:18px; "> <span class="sstitle">国内银行卡支付</span> <a href="#" onClick="javascript:document.payForm.submit();"><font color="red">>> 点击进入支付</font></a><br>
支持工商银行、招商银行、建设银行、农业银行、中国银行、交通银行、浦发银行、民生银行、兴业银行、华夏银行、广发银行等绝大多数银行卡及信用卡的在线支付<br>
<span class="sstitle">国际信用卡支付</span> 支持VISA Card，Master Card (暂未开通)
</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#EEE6D2" class="tableall_shop">
<tr align="center" bgcolor="#EEE6D2">
<td height="25" class="sstitle">银行汇款</td>
</tr>
<tr bgcolor="#FAF8F1">
<td height="50" bgcolor="#FAF8F1" style="line-height:18px; "> <span class="sstitle">银行汇款注意事项： </span><br>
（1）汇款银行：中国工商银行、招商银行、中国建设银行、中国农业银行、中国银行，汇款帐号请查阅 <a href="/help/pay.htm"><font color="red">付款方式 </font></a><br>
（2）汇款后请务必用以下方式及时通知我们：电话、传真、在线交流工具（QQ，MSN） </td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#EEE6D2" class="tableall_shop">
<tr align="center" bgcolor="#EEE6D2">
<td height="25" class="sstitle">上门收款</td>
</tr>
<tr bgcolor="#FAF8F1">
<td height="86" bgcolor="#FAF8F1" style="line-height:18px; "> （1）目前花坊鲜花礼品网暂时只开通成都地区上门收款服务。<br>
（2）上门收款需 加收10元 上门收款费 。<br>
（3）如您选择上门收款方式，我们在收到定单后要与您联系确认,所以如果无法及时联系到您，我们无法保证将花送抵，因此请您提前与我们联系来确认定单是否有效 。</td>
</tr>
<tr bgcolor="#FAF8F1">
<td height="87" bgcolor="#FAF8F1" style="line-height:18px; "> </td>
</tr>
</table>
</td>
</tr>
<%
}
con.close();
}
catch(SQLException e1) { System.out.println("where");}
%>
</table></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -