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);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
网上购物系统,基于MVC模式设计,使用了Struts框架,前台由jsp+Action(结尾标识的类)+JavaBean组成,还是使用MySQL作为后台存储数据库,实现了按商品名称,厂商的搜索,对客户信息的维护,购物车的维护和定单的修改等。对于客户的维护采用了javascript验证
资源推荐
资源详情
资源评论
收起资源包目录
Struts+MySQL网上购物系统源代码.rar (117个子文件)
SubmitOrderAction.class 5KB
RegistAction.class 4KB
BuyAction.class 4KB
SearchAction.class 4KB
ListProAction.class 4KB
ProDetailAction.class 4KB
ModifyOrderAction.class 3KB
CommentAction.class 3KB
LoginAction.class 3KB
ModifyOrder.class 3KB
UserInfo.class 3KB
ShowImage.class 3KB
ModifyCartAction.class 3KB
ShowItemsAction.class 3KB
DetailInfo.class 3KB
ShowDetailAction.class 3KB
SendMail.class 3KB
DeliveryInfo.class 2KB
DBConn.class 2KB
OrderItems.class 2KB
ShowOrderAction.class 2KB
ListOrder.class 2KB
ProInfo.class 2KB
ShowSort.class 2KB
OrderInfo.class 2KB
SetMethodAction.class 2KB
ModifyAction.class 2KB
CommentInfo.class 1KB
LogoutAction.class 1KB
CheckUser.class 1KB
Param.class 989B
style.css 477B
Thumbs.db 22KB
Thumbs.db 9KB
Thumbs.db 6KB
next.gif 633B
21.html 8KB
folder.htt 376B
struts.jar 537KB
antlr.jar 350KB
mail.jar 320KB
commons-beanutils.jar 184KB
commons-collections.jar 171KB
commons-digester.jar 164KB
commons-validator.jar 82KB
jakarta-oro.jar 64KB
activation.jar 53KB
commons-logging.jar 37KB
commons-fileupload.jar 22KB
catalina-root.jar 5KB
SubmitOrderAction.java 4KB
RegistAction.java 3KB
ModifyOrder.java 3KB
BuyAction.java 3KB
ModifyOrderAction.java 2KB
SearchAction.java 2KB
DBConn.java 2KB
LoginAction.java 2KB
UserInfo.java 2KB
CommentAction.java 2KB
ShowImage.java 2KB
ListProAction.java 2KB
ProDetailAction.java 2KB
ListOrder.java 2KB
ModifyCartAction.java 2KB
ShowItemsAction.java 2KB
SendMail.java 1KB
DetailInfo.java 1KB
ShowOrderAction.java 1KB
ShowDetailAction.java 1KB
OrderItems.java 1KB
DeliveryInfo.java 1KB
OrderInfo.java 1KB
ProInfo.java 1KB
SetMethodAction.java 1KB
ShowSort.java 1KB
Param.java 995B
LogoutAction.java 964B
ModifyAction.java 889B
CommentInfo.java 864B
CheckUser.java 449B
0001.jpg 45KB
ll.jpg 11KB
1.jpg 11KB
0002.jpg 11KB
0004.jpg 9KB
0003.jpg 8KB
buy.jpg 3KB
OrderDetail.jsp 4KB
DispProInfo.jsp 4KB
CheckOrder.jsp 3KB
modifyinfo.jsp 2KB
showorders.jsp 2KB
CheckInfo.jsp 2KB
listCart.jsp 2KB
Modify_Method.jsp 2KB
showorder.jsp 2KB
modifymethod.jsp 2KB
regist.jsp 2KB
listPro.jsp 2KB
共 117 条
- 1
- 2
zhangyantao19
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页