cart_0005forder_0002ejsp_jsp.java

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

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
import java.sql.*;
import java.util.Vector;
import commerce.goodselement;
import com.wgh.DB.chStr;
import com.wgh.DB.connDB;

public class cart_0005forder_0002ejsp_jsp extends HttpJspBase {


  private static java.util.Vector _jspx_includes;

  public java.util.List getIncludes() {
    return _jspx_includes;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    javax.servlet.jsp.PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");

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>");
}

      out.write("\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">");
    } catch (Throwable t) {
      out = _jspx_out;
      if (out != null && out.getBufferSize() != 0)
        out.clearBuffer();
      if (pageContext != null) pageContext.handlePageException(t);
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
    }
  }
}