Struts+MySQL网上购物系统源代码

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