/*============================*/ 
/* Table: 用戶表結(jié)構(gòu)    */ 
/*============================*/ 
create table user 
( 
 /* 用戶編號(hào),自動(dòng)增長 */ 
 id     int primary key not null auto_increment, 
 /* 用戶登錄名 */ 
 login    varchar(20), 
 /* 用戶真實(shí)姓名 */ 
 name    varchar(20), 
 /* 用戶登錄密碼 */ 
 pass    varchar(20), 
 /* 用戶性別 */ 
 sex     varchar(20), 
 /* 用戶電話 */ 
 phone    varchar(20), 
 /* 用戶Email */ 
 email    varchar(20) 
); 
 
/*=============================*/ 
/* Table: 訂單狀態(tài)表結(jié)構(gòu)    */ 
/*=============================*/ 
create table status 
( 
 /* 狀態(tài)編號(hào),自動(dòng)增長 */ 
 id     int primary key not null auto_increment, 
 /* 訂單狀態(tài) */ 
 status    varchar(10) 
); 
 
/*=============================*/ 
/* Table: 購物車（訂單）表結(jié)構(gòu)   */ 
/*=============================*/ 
create table forder 
( 
 /* 訂單編號(hào),自動(dòng)增長 */ 
 id     int primary key not null auto_increment, 
 /* 收件人名字 */ 
 name    varchar(20), 
 /* 收件人電話 */ 
 phone    varchar(20), 
 /* 配送信息 */ 
 remark    varchar(20), 
 /* 下單日期 */ 
 date    timestamp default CURRENT_TIMESTAMP, 
 /* 訂單總金額 */ 
 total    decimal(8,2), 
 /* 收件人郵編 */ 
 post    varchar(20), 
 /* 收件人郵編 */ 
 address    varchar(200), 
 /* 訂單狀態(tài) */ 
 sid     int default 1, 
 /* 會(huì)員編號(hào) */ 
 uid     int, 
 constraint sid_FK foreign key(sid) references status(id), 
 constraint uid_FK foreign key(uid) references user(id) 
); 
 
/*=============================*/ 
/* Table: 購物項(xiàng)表結(jié)構(gòu)    */ 
/*=============================*/ 
 
create table sorder 
( 
 /* 購物項(xiàng)編號(hào),自動(dòng)增長 */ 
 id     int primary key not null auto_increment, 
 /* 被購買商品的名稱 */ 
 name    varchar(20), 
 /* 購買時(shí)商品的價(jià)格 */ 
 price    decimal(8,2), 
 /* 購買的數(shù)量 */ 
 number    int not null, 
 /* 所屬商品編號(hào) */ 
 pid     int, 
 /* 此訂單項(xiàng),所屬的訂單編號(hào) */ 
 fid     int, 
 constraint pid_FK foreign key(pid) references product(id), 
 constraint fid_FK foreign key(fid) references forder(id) 
); 

//SorderService接口 
public interface SorderService extends BaseService<Sorder> { 
 //添加購物項(xiàng)，返回新的購物車 
 public Forder addSorder(Forder forder, Product product); 
 //把商品數(shù)據(jù)轉(zhuǎn)化為購物項(xiàng) 
 public Sorder productToSorder(Product product); 
} 
//ForderService接口 
public interface ForderService extends BaseService<Forder> { 
 //計(jì)算購物總價(jià)格 
 public double cluTotal(Forder forder); 
} 

//SorderServiceImpl實(shí)現(xiàn)類 
@Service("sorderService") 
public class SorderServiceImpl extends BaseServiceImpl<Sorder> implements 
  SorderService { 
 
 @Override 
 public Forder addSorder(Forder forder, Product product) { 
  boolean isHave = false; //用來標(biāo)記有沒有重復(fù)購物項(xiàng) 
  //拿到當(dāng)前的購物項(xiàng) 
  Sorder sorder = productToSorder(product); 
  //判斷當(dāng)前購物項(xiàng)是否重復(fù)，如果重復(fù)，則添加數(shù)量即可 
  for(Sorder old : forder.getSorders()) { 
   if(old.getProduct().getId().equals(sorder.getProduct().getId())) { 
    //購物項(xiàng)有重復(fù)，添加數(shù)量即可 
    old.setNumber(old.getNumber() + sorder.getNumber()); 
    isHave = true; 
    break; 
   } 
  } 
  //當(dāng)前購物項(xiàng)在購物車中不存在，新添加即可 
  if(!isHave) { 
   forder.getSorders().add(sorder); 
  } 
  return forder; 
 } 
 
 @Override 
 public Sorder productToSorder(Product product) { 
  Sorder sorder = new Sorder(); 
  sorder.setName(product.getName()); 
  sorder.setNumber(1); 
  sorder.setPrice(product.getPrice()); 
  sorder.setProduct(product); 
  return sorder; 
 } 
} 
 
//ForderServiceImpl實(shí)現(xiàn)類 
@Service("forderService") 
public class ForderServiceImpl extends BaseServiceImpl<Forder> implements ForderService { 
 
 @Override 
 public double cluTotal(Forder forder) { 
 
  double total = 0.0; 
  for(Sorder sorder : forder.getSorders()) { 
   total += sorder.getNumber() * sorder.getPrice(); 
  } 
  return total; 
 } 
  
} 

@Controller("baseAction") 
@Scope("prototype") 
public class BaseAction<T> extends ActionSupport implements RequestAware,SessionAware,ApplicationAware,ModelDriven<T> { 
 
 //省略其他無關(guān)代碼…… 
 
 @Resource 
 protected ForderService forderService; 
 @Resource 
 protected SorderService sorderService; 
 
} 

@Controller 
@Scope("prototype") 
public class SorderAction extends BaseAction<Sorder> { 
 public String addSorder() { 
   
  //1. 根據(jù)product.id獲取相應(yīng)的商品數(shù)據(jù) 
  Product product = productService.get(model.getProduct().getId()); 
   
  //2. 判斷當(dāng)前session是否有購物車，如果沒有則創(chuàng)建 
  if(session.get("forder") == null) { 
   //創(chuàng)建新的購物車，存儲(chǔ)到session中 
   session.put("forder", new Forder(new HashSet<Sorder>())); 
  } 
 
  //3. 把商品信息轉(zhuǎn)化為sorder,并且添加到購物車中（判斷購物項(xiàng)是否重復(fù)） 
  Forder forder = (Forder) session.get("forder"); 
  forder = sorderService.addSorder(forder, product); 
   
  //4. 計(jì)算購物的總價(jià)格 
  forder.setTotal(forderService.cluTotal(forder)); 
  //5. 把新的購物車存儲(chǔ)到session中 
  session.put("forder", forder); 
  return "showCart"; 
 } 
} 

<action name="sorder_*" class="sorderAction" method="{1}"> 
 <result name="showCart">/showCart.jsp</result> 
</action>