cart_order.jsp

电子商务系统(系统主要分为前台和后台。前台包括产品的展示及会员购物等模块

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.Vector"%>
<%@ page import="commerce.goodselement"%>
<%@ page import="com.wgh.DB.chStr"%>
<%@ page import="com.wgh.DB.connDB"%>
<%
chStr chStr=new chStr();
connDB conn=new 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=(float)0.0;
	float sum=(float)0;
	float Totalsum=(float)0;
	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">