package?com.db;

import?java.util.List;

import?com.entity.Bill;

public?class?BillOperation?{
	/**
	?*?屬性dbo
	?*/
	private?DBOperation?dbo;
	/**
	?*?屬性的get與set方法
	?*?@return
	?*/
	public?DBOperation?getDbo（）?{
		return?dbo;
	}

	public?void?setDbo（DBOperation?dbo）?{
		this.dbo?=?dbo;
	}
	/**
	?*?數據庫的初始化
	?*?@return
	?*/
	private???DBOperation?getDB（）{
		DBOperation?dbo1=new?DBOperation（）;
		dbo1.setDriver（“oracle.jdbc.driver.OracleDriver“）;
		dbo1.setUrl（“jdbc:oracle:thin:@localhost:1521:pbdemo“）;
		dbo1.setUser（“dbdemo“）;
		dbo1.setPassWord（“sa“）;
		return?dbo1;
	}
	/**
	?*?查詢操作
	?*?@return
	?*/
	public?static?List?selectBill（）{
		BillOperation?db=new?BillOperation（）;
		db.setDbo（db.getDB（））;
		return?db.dbo.selectBill（）;	
	}
	/**
	?*?更新操作
	?*/
	public?static?boolean?isUpdate（Bill?bill）{
		Boolean?update=null;
		BillOperation?db=new?BillOperation（）;
		db.setDbo（db.getDB（））;
		update=db.dbo.updateBill（bill）;
		return?update;
	}
	/**
	?*?插入操作
	?*?@param?bill
	?*?@return
	?*/
	public?static?boolean?isInsert（Bill?bill）{
		Boolean?insert=null;
		BillOperation?db=new?BillOperation（）;
		db.setDbo（db.getDB（））;
		insert=db.dbo.insertBill（bill）;
		return?insert;
	}
	/**
	?*?刪除操作
	?*/
	public?static?boolean?isDelete（Bill?bill）{
		Boolean?delete=null;
		BillOperation?db=new?BillOperation（）;
		db.setDbo（db.getDB（））;
		delete=db.dbo.deleteBill（bill）;
		return?delete;
		
	}


}

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

?????文件???????1420??2011-07-26?20:57??SupermarketBMS\.project

?????文件???????1507??2011-08-01?08:30??SupermarketBMS\src\com\entity\Bill.java

?????文件???????1255??2011-08-01?17:42??SupermarketBMS\src\com\entity\Supplier.java

?????文件???????1356??2011-08-01?07:05??SupermarketBMS\src\com\entity\US.java

?????文件??????11657??2011-08-04?09:41??SupermarketBMS\src\com\db\DBOperation.java

?????文件???????1504??2011-08-03?20:27??SupermarketBMS\src\com\db\BillOperation.java

?????文件???????1792??2011-08-02?15:47??SupermarketBMS\src\com\db\SupplierOperation.java

?????文件???????1804??2011-08-04?09:59??SupermarketBMS\src\com\db\USOperation.java

?????文件???????2300??2011-08-04?09:25??SupermarketBMS\src\com\Servlet\LoginServlet.java

?????文件??????20682??2011-07-22?17:42??SupermarketBMS\WebRoot\WEB-INF\lib\jstl.jar

?????文件????1536554??2011-07-22?20:58??SupermarketBMS\WebRoot\WEB-INF\lib\ojdbc14.jar

?????文件?????393259??2011-07-22?17:42??SupermarketBMS\WebRoot\WEB-INF\lib\standard.jar

?????文件???????1859??2011-08-02?21:40??SupermarketBMS\WebRoot\WEB-INF\classes\com\entity\US.class

?????文件???????1604??2011-08-02?21:40??SupermarketBMS\WebRoot\WEB-INF\classes\com\entity\Supplier.class

?????文件???????2043??2011-08-02?21:40??SupermarketBMS\WebRoot\WEB-INF\classes\com\entity\Bill.class

?????文件???????1882??2011-08-04?09:59??SupermarketBMS\WebRoot\WEB-INF\classes\com\db\USOperation.class

?????文件???????2020??2011-08-02?21:40??SupermarketBMS\WebRoot\WEB-INF\classes\com\db\SupplierOperation.class

?????文件??????11137??2011-08-04?09:41??SupermarketBMS\WebRoot\WEB-INF\classes\com\db\DBOperation.class

?????文件???????1809??2011-08-03?20:27??SupermarketBMS\WebRoot\WEB-INF\classes\com\db\BillOperation.class

?????文件???????2953??2011-08-04?09:25??SupermarketBMS\WebRoot\WEB-INF\classes\com\Servlet\LoginServlet.class

?????文件????????989??2011-07-28?08:30??SupermarketBMS\WebRoot\WEB-INF\web.xml

?????文件?????????36??2011-07-25?21:22??SupermarketBMS\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2318??2011-08-07?22:47??SupermarketBMS\WebRoot\main.jsp

?????文件????????900??2011-08-04?07:15??SupermarketBMS\WebRoot\css\maincss.css

?????文件????????462??2011-08-04?07:57??SupermarketBMS\WebRoot\css\css.css

?????文件????????715??2011-07-28?00:01??SupermarketBMS\WebRoot\mainimage\top.jpg

?????文件????????699??2011-07-28?00:01??SupermarketBMS\WebRoot\mainimage\left.jpg

?????文件???????1149??2011-07-28?00:01??SupermarketBMS\WebRoot\mainimage\left1.jpg

?????文件???????1181??2011-07-28?00:01??SupermarketBMS\WebRoot\mainimage\left2.jpg

?????文件???????1162??2011-07-28?00:01??SupermarketBMS\WebRoot\mainimage\left3.jpg

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