shoplogic.java

关于shopmanager的源码

package businesslogic;


import dao.*;
import java.sql.*;
import dao.CommodityDAO;
import dao.CommodityStocksDAO;
import dao.ShoppingListDAO;
import java.util.*;
import javax.swing.*;
import javax.swing.JOptionPane;

import shopbean.ItemOrder;
import shopbean.Item;

public class ShopLogic extends JFrame {
    private CommodityDAO commodity=new CommodityDAO();
    private CommodityStocksDAO commoditystocks=new CommodityStocksDAO();
    private ShoppingListDAO shoppinglist=new ShoppingListDAO();
    private Vector list=new Vector();
    private ResultSet rs,rs1,rs2;
    private double totalcost=0;
    private String itemid="";
    private String shortname="";
    private String longname="";
    private int itemnumber=0;
    private double price=0.0;
    private String values[]=new String [5];
    int num;
   //private ItemOrder itemorder=new ItemOrder();
  public ShopLogic(){}
  
  public Vector purchase (String userid,String id,int number)
  {
	  this.num=number;
	  try
	  {
		  rs=commodity.execute(id);
		  while(rs.next())
		  {
			  itemid=rs.getString("itemid");
			  shortname=rs.getString("shortname");
			  longname=rs.getString("longname");
			  price=Double.parseDouble(rs.getString("price"));
		  }
		  rs1=commoditystocks.executeQuery(id);
		  while(rs1.next())
		  {
			  itemid=rs.getString("itemid");
			  shortname=rs.getString("shortname");
			  itemnumber=Integer.parseInt(rs.getString("numitems"));
		  }
		  if((itemnumber-num)<=1)
		  {
			  JOptionPane.showMessageDialog(this, "对不起,库存不够 !", "警告", JOptionPane.INFORMATION_MESSAGE);
			  throw(new Exception("对不起,库存不够 !"));
		  }
	  }
	  catch(Exception e)
	  {
		  System.out.println(e.getMessage());
	  }
	  Item item=new Item();
	  item.setItemID(itemid, shortname, longname, price);
	 ItemOrder itemorder=new ItemOrder(item);
	  itemorder.setNumItem(number);
	  values[0]=userid;
	  values[1]=item.getItemID();
	  values[2]=itemorder.getshortname();
	  values[3]=String.valueOf(itemorder.getNumItem());
	  values[4]=String.valueOf(itemorder.getTotalCost());
	  shoppinglist.executeADD(values);
	  commoditystocks.executeUpdate(item.getItemID(),String.valueOf(itemnumber-number));
	  list.add(itemorder);
	  return list;
  }
  public double checkout(String userid,String id,int number)
  {   this.num=number;
	  try
	  {
		rs2=shoppinglist.executeQuery(id);
		while(rs2.next())
		{   
			shoppinglist.executeUpdate(userid);
			price=Double.parseDouble(rs2.getString("price"));
			totalcost=price*num;
		}
	
	  }
	  catch(Exception e)
	  {
		 System.err.println(e.getMessage());
		  }
	 return totalcost;
  }
  


}