forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcart_order.jsp
More file actions
112 lines (111 loc) · 4.07 KB
/
cart_order.jsp
File metadata and controls
112 lines (111 loc) · 4.07 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.Vector"%>
<%@ page import="com.model.Goodselement"%>
<jsp:useBean id="chStr" scope="page" class="com.tools.ChStr"/>
<jsp:useBean id="conn" scope="page" class="com.tools.ConnDB"/>
<%
if(session.getAttribute("cart")==""){
out.println("<script language='javascript'>alert('您还没有购物!');window.location.href='index.jsp';</script>");
}
String Username="";
Username=(String)session.getAttribute("username");
if (Username!=""){
try{
ResultSet rs_user=conn.executeQuery("select * from tb_Member where username='"+Username+"'");
if(!rs_user.next()){
session.invalidate();
out.println("<script language='javascript'>alert('请先登录后，再进行购物!');window.location.href='index.jsp';</script>");
return;
}else{
String username=chStr.chStr(request.getParameter("username"));
String truename=chStr.chStr(request.getParameter("truename"));
String address=chStr.chStr(request.getParameter("address"));
String postcode=request.getParameter("postcode");
String tel=request.getParameter("tel");
String pay=chStr.chStr(request.getParameter("pay"));
String carry=chStr.chStr(request.getParameter("carry"));
String bz=chStr.chStr(request.getParameter("bz"));
int orderID=0;
//计算打折
float rebate=1;
ResultSet rs_rebate=conn.executeQuery("select rebate from V_Member where username='"+username+"'");
if (rs_rebate.next()){
rebate=rs_rebate.getFloat("rebate");
}
Vector cart=(Vector)session.getAttribute("cart");
int number=0;
float nowprice=0f;
float sum=0f;
float Totalsum=0f;
String flag="True";
int temp=0;
int ID=-1;
//插入订单主表数据
float bnumber=cart.size();
String sql="insert into tb_Order(bnumber,username,truename,address,postcode,tel,pay,carry,rebate,bz) values("+bnumber+",'"+username+"','"+truename+"','"+address+"','"+postcode+"','"+tel+"','"+pay+"','"+carry+"',"+rebate+",'"+bz+"')";
temp=conn.executeUpdate_id(sql);
//out.print("sql:"+sql);
if (temp==0){
flag="false";
// out.print(flag+"主表出错");
}else{
orderID=temp;
}
String str="";
//插入订单明细表数据
for(int i=0;i<cart.size();i++){
Goodselement mygoodselement=(Goodselement)cart.elementAt(i);
ID=mygoodselement.ID;
nowprice=mygoodselement.nowprice*rebate;
number=mygoodselement.number;
sum=nowprice*number;
str="insert into tb_order_Detail (orderID,goodsID,price,number) values("+orderID+","+ID+","+nowprice+","+number+")";
temp=conn.executeUpdate(str);
//out.print("sql2:"+str);
Totalsum=Totalsum+sum;
if (temp==0){
flag="false";
//out.print(flag+"从表出错");
}
}
//更新会员信息
String sql_up="update tb_Member set Amount=Amount+"+Totalsum+" where username='"+username+"'";
temp=conn.executeUpdate(sql_up);
if (temp==0){
flag="false";
// out.print(flag+"更新会员销费额出错");
}
//更新会员等级
ResultSet rs_Amount=conn.executeQuery("select Amount from tb_Member where username='"+username+"'");
if (rs_Amount.next()){
int Amount=0;
Amount=rs_Amount.getInt("Amount");
ResultSet rs_grade=conn.executeQuery("select Top 1 grade,Amount from tb_rebate where Amount<="+Amount+" order by grade desc");
if (rs_grade.next()){
int grade=0;
grade=rs_grade.getInt("grade");
String sql_upgrade="update tb_Member set grade="+grade+" where username='"+username+"'";
temp=conn.executeUpdate(sql_upgrade);
if (temp==0){
flag="false";
//out.print(flag+"更新会员等级出错");
}
}
}
if(flag.equals("false")){
out.println("<script language='javascript'>alert('订单无效');history.back();</script>");
}else{
session.removeAttribute("cart");
out.println("<script language='javascript'>alert('订单生成，请记住您的订单号["+orderID+"]');window.location.href='index.jsp';</script>");
}
conn.close();
}
}catch(Exception e){
out.println(e.toString());
}
}else{
session.invalidate();
out.println("<script language='javascript'>alert('请先登录后，再进行购物!');window.location.href='index.jsp';</script>");
}
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">