package?market.Dao;

import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?entity.Market;

public?class?marketDao?extends?baseDao?{
?//新建庫存物品
	public?int?addMarket（Market?marketGoods）
	{
		int?result?=?0;
		String?sql?=?“insert?into?marketGoods?values（null?????）“;
		con?=?getConn（）;
		try?{
			pst?=?con.prepareStatement（sql）;
			pst.setString（1?marketGoods.getName（））;
????????????pst.setString（2?marketGoods.getType（））;
????????????pst.setInt（3marketGoods.getGoodNumber（））;
????????????pst.setDouble（4marketGoods.getInPrice（））;
????????????pst.setDouble（5marketGoods.getOutPrice（））;
			result?=?pst.executeUpdate（）;
			closeAll（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}
//刪除表
	public?int?delMarket（int?id）?{
		int?result?=?0;
		String?sql?=?“delete?from?marketGoods?where?id=?“;
		con?=?getConn（）;
		try?{
			pst?=?con.prepareStatement（sql）;
			pst.setInt（1?id）;
			result?=?pst.executeUpdate（）;
			closeAll（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}

	public?int?updateMarket1（int?id?double?change）?{//
		int?result?=?0;
		String?sql?=?“update?marketGoods?set?outPrice=??where?id=?“;
		con?=?getConn（）;
		try?{
			pst?=?con.prepareStatement（sql）;
			pst.setDouble（1?change）;
			pst.setInt（2?id）;
			result?=?pst.executeUpdate（）;
			closeAll（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}

	public?int?updateMarket2（int?id?double?change）?{
		int?result?=?0;
		String?sql?=?“update?marketGoods?set?goodNumber=??where?id=?“;
		con?=?getConn（）;
		try?{
			pst?=?con.prepareStatement（sql）;
			pst.setDouble（1?change）;
			pst.setInt（2?id）;
			result?=?pst.executeUpdate（）;
			closeAll（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}
	public?int?updateMarket3（int?id?double?change）?{
		int?result?=?0;
		String?sql?=?“update?marketGoods?set?badNumber=??where?id=?“;
		con?=?getConn（）;
		try?{
			pst?=?con.prepareStatement（sql）;
			pst.setDouble（1?change）;
			pst.setInt（2?id）;
			result?=?pst.executeUpdate（）;
			closeAll（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}
	//報損更改
	public?int?turnMarket（int?id?double?change）?{
		int?result?=?0;
		String?sql1?=?“update?marketGoods?set?goodNumber=goodNumber-??where?id=?“;
		String?sql2?=?“update?marketGoods?set??badNumber=?badNumber+??where?id=?“;
		int?r1=0r2=0;
		con?=?getConn（）;
		try?{
			con.setAutoCommit（false）;
			
			pst=con.prepareStatement（sql1）;
			pst.setDouble（1?change）;
			pst.setInt（2?id）;
			
			r1?=?pst.executeUpdate（）;
			
			pst=con.prepareStatement（sql2）;
			pst.setDouble（1?change）;
			pst.se

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-08-09?17:33??superMarket\
?????文件?????????380??2018-08-09?17:33??superMarket\.classpath
?????文件?????????387??2018-08-09?17:33??superMarket\.project
?????目錄???????????0??2018-08-09?17:33??superMarket\.settings\
?????文件?????????598??2018-08-09?17:33??superMarket\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\entity\
?????文件????????3375??2018-08-09?17:33??superMarket\bin\entity\Market.class
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\market\
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\market\Dao\
?????文件????????1477??2018-08-09?17:33??superMarket\bin\market\Dao\baseDao.class
?????文件????????8470??2018-08-09?17:33??superMarket\bin\market\Dao\marketDao.class
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\market\server\
?????文件?????????289??2018-08-09?17:33??superMarket\bin\market\server\marketServer.class
?????目錄???????????0??2018-08-09?17:33??superMarket\bin\market\web\
?????文件???????11348??2018-08-09?17:33??superMarket\marketDao.java
?????目錄???????????0??2018-08-09?17:33??superMarket\src\
?????目錄???????????0??2018-08-09?17:33??superMarket\src\entity\
?????文件????????2375??2018-08-09?17:33??superMarket\src\entity\Market.java
?????目錄???????????0??2018-08-09?17:33??superMarket\src\market\
?????目錄???????????0??2018-08-09?17:33??superMarket\src\market\Dao\
?????文件????????1027??2018-08-09?17:33??superMarket\src\market\Dao\baseDao.java
?????文件???????11348??2018-08-09?17:33??superMarket\src\market\Dao\marketDao.java
?????目錄???????????0??2018-08-09?17:33??superMarket\src\market\server\
?????文件??????????60??2018-08-09?17:33??superMarket\src\market\server\marketServer.java
?????目錄???????????0??2018-08-09?17:33??superMarket\src\market\web\
?????目錄???????????0??2018-08-09?17:33??superMarket\zlib\
?????文件??????789885??2018-08-09?17:33??superMarket\zlib\mysql-connector-java-5.1.18-bin.jar
?????目錄???????????0??2018-08-09?17:33??superMarket\zsql\
?????文件?????????256??2018-08-09?17:33??superMarket\zsql\SQl.java