submitorderaction.java

网上商城

package store;

import java.sql.*;
import java.util.*;
import java.util.Date;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
public class SubmitOrderAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
  HttpSession session=request.getSession();
  ActionErrors errors=new ActionErrors ();
  String tt=session.getAttribute("total").toString();
  float total=Float.parseFloat(tt);
  String qu=session.getAttribute("quantity").toString();
  int quantity=Integer.parseInt(qu);
  String de=session.getAttribute("delivery").toString();
  int delivery=Integer.parseInt(de);
  String pay=session.getAttribute("payment").toString();
  int payment=Integer.parseInt(pay);
  Object userid=session.getAttribute("userid");
  int customerid=Integer.parseInt(userid.toString());
  Date date=new Date();
  String datetime=date.toLocaleString();
  Vector vc=(Vector)session.getAttribute("cart");
  String pageForward="";
  DBConn conn=new DBConn();
  PreparedStatement pstmt=null;
  int maxid=0;
  try{
    String sql="SELECT * FROM orders WHERE isorder=1";
    ResultSet rs=conn.query(sql);
    rs.last();
    maxid=rs.getInt("orderid")+1;
    rs.close();
    String sql2="INSERT INTO orders VALUE(?,?,?,?,?,?,?,?,?,?,?)";
    pstmt=conn.getPstmt(sql2);
    pstmt.setInt(1,0);
    pstmt.setInt(2,1);
    pstmt.setInt(3,maxid);
    pstmt.setInt(4,0);
    pstmt.setInt(5,customerid);
    pstmt.setInt(6,quantity);
    pstmt.setFloat(7,total);
    pstmt.setString(8,datetime);
    pstmt.setInt(9,delivery);
    pstmt.setInt(10,payment);
    pstmt.setInt(11,0);
    int uu=pstmt.executeUpdate();
    if(uu>0){
      for(int i=0;i<vc.size();i++)
      {
        ProInfo PI=(ProInfo)vc.elementAt(i);
        pstmt.setInt(1,0);
        pstmt.setInt(2,0);
        pstmt.setInt(3,maxid);
        pstmt.setInt(4,PI.getId());
        pstmt.setInt(5,customerid);
        pstmt.setInt(6,PI.getStock());
        pstmt.setFloat(7,PI.getPrice());
        pstmt.setString(8,datetime);
        pstmt.setInt(9,delivery);
        pstmt.setInt(10,payment);
        pstmt.setInt(11,0);
        pstmt.addBatch();
      }
      int n[]=pstmt.executeBatch();
      if(!(n.length>0)){
        pageForward="error";
      }
      else{
        pageForward = "ShowOrder";
        UserInfo UI=(new UserInfo()).getUserInfo(customerid);
        String email=UI.getEmail();
        String content=UI.getName()+"您好，您在线购物订单已提交成功，请在付款后查收商品！您的订单号为"+maxid;
        (new SendMail()).send(email,content);
      }
    }
    else{
      pageForward="error";
    }
    pstmt.cancel();
    conn.DBclose();
    vc=null;
  }
  catch(Exception e){
    System.out.print(e.toString());
    ActionError err= new ActionError ("error.global");
    errors.add(ActionErrors.GLOBAL_ERROR,err);
    this.saveErrors(request,errors);
    pageForward="error";
  }
  session.removeAttribute("total");
  session.removeAttribute("quantity");
  session.removeAttribute("payment");
  session.removeAttribute("cart");

  ListOrder LO=new ListOrder();
  OrderInfo OI=LO.getOrderInfo(maxid);
  session.setAttribute("order",OI);
  return mapping.findForward(pageForward);
 }
}