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?rsrs1rs2;
????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?useridString?idint?number）
??{
	??this.num=number;
	??try
	??{
		??rs=commodity.execute（id）;
		??while（rs.next（））
		??{
			??itemid=rs.getString（“itemid“）;
			??shortname=rs.getString（“shortname“）;
			??longname=rs.getString（“l(fā)ongname“）;
			??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?useridString?idint?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;
??}
??


}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????346??2008-06-11?17:47??shopmanager\.classpath

?????文件????????387??2008-06-11?17:47??shopmanager\.project

?????文件???????3537??2008-06-11?17:47??shopmanager\businesslogic\ShopLogic.class

?????文件???????2717??2008-06-11?17:47??shopmanager\businesslogic\ShopLogic.java

?????文件???????3017??2008-06-11?17:47??shopmanager\common\DBConnection.class

?????文件???????2304??2008-06-11?17:47??shopmanager\common\DBConnection.java

?????文件????????837??2008-06-11?17:47??shopmanager\dao\CommodityDAO.class

?????文件????????981??2008-06-11?17:47??shopmanager\dao\CommodityDAO.java

?????文件???????1119??2008-06-11?17:47??shopmanager\dao\CommodityStocksDAO.class

?????文件????????731??2008-06-11?17:47??shopmanager\dao\CommodityStocksDAO.java

?????文件???????1840??2008-06-11?17:47??shopmanager\dao\ShoppingListDAO.class

?????文件???????1331??2008-06-11?17:47??shopmanager\dao\ShoppingListDAO.java

?????文件???????1966??2008-06-11?17:47??shopmanager\date\gwb.sql

?????文件??????????0??2008-06-11?17:47??shopmanager\date\gwqdb.csv

?????文件???????1087??2008-06-11?17:47??shopmanager\date\gwqdb.sql

?????文件??????????0??2008-06-11?17:47??shopmanager\date\spb.csv

?????文件????????445??2008-06-11?17:47??shopmanager\date\spb.sql

?????文件??????????0??2008-06-11?17:47??shopmanager\date\spkcb.csv

?????文件???????1015??2008-06-11?17:47??shopmanager\date\spkcb.sql

?????文件???????1408??2008-06-11?17:47??shopmanager\shopbean\Item.class

?????文件???????1026??2008-06-11?17:47??shopmanager\shopbean\Item.java

?????文件???????1437??2008-06-11?17:47??shopmanager\shopbean\ItemOrder.class

?????文件????????965??2008-06-11?17:47??shopmanager\shopbean\ItemOrder.java

?????文件???????5853??2008-06-11?17:47??shopmanager\showframe\Shopframe.class

?????文件???????3729??2008-06-11?17:47??shopmanager\showframe\Shopframe.java

?????目錄??????????0??2009-05-05?19:26??shopmanager\businesslogic

?????目錄??????????0??2009-05-05?19:26??shopmanager\common

?????目錄??????????0??2009-05-05?19:26??shopmanager\dao

?????目錄??????????0??2009-05-05?19:26??shopmanager\date

?????目錄??????????0??2009-05-05?19:26??shopmanager\shopbean

............此處省略5個文件信息