package?c229.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;

import?c229.db.DB;
import?c229.model.Goods;

public?class?GoodsDAO?{
		private?DB?db=new?DB（）;
		public?int?delete（int?G_id）?{
			int?res=0;
			try?{
				Connection?con=db.getCon（）;
				String?sql=“delete?from?goods?where?G_id=?“;
				PreparedStatement?ps=con.prepareStatement（sql）;
				ps.setInt（1?G_id）;
				res=ps.executeUpdate（）;
				ps.close（）;
				db.close（）;
			}catch?（Exception?e）?{
				e.printStackTrace（）;
			}
			return?res;
		}
		public?int?insert（String?G_namefloat?G_priceString?G_classint?G_dateint?G_numfloat?G_sumString?Sup_nameint?Sup_DateString?G_on_name）?{
			int?res=0;
			try?{
					Connection?con=db

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????7533??2019-09-05?11:14??c229.sql
?????目錄???????????0??2020-06-03?21:20??c229\
?????文件?????????842??2020-06-03?21:39??c229\.classpath
?????目錄???????????0??2020-06-09?16:47??c229\.idea\
?????文件?????????267??2020-06-03?21:11??c229\.idea\misc.xml
?????文件?????????255??2020-06-03?21:11??c229\.idea\modules.xml
?????文件????????2566??2020-06-09?16:47??c229\.idea\workspace.xml
?????文件?????????904??2019-09-05?11:12??c229\.project
?????目錄???????????0??2020-06-03?22:01??c229\.settings\
?????文件?????????567??2019-09-05?11:12??c229\.settings\.jsdtscope
?????文件??????????57??2019-09-05?11:12??c229\.settings\org.eclipse.core.resources.prefs
?????文件?????????670??2020-06-03?21:35??c229\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2019-09-05?11:12??c229\.settings\org.eclipse.wst.common.component
?????文件?????????305??2020-06-03?22:01??c229\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件?????????345??2019-09-05?11:12??c229\.settings\org.eclipse.wst.common.project.facet.core.xml.bak
?????文件??????????49??2019-09-05?11:12??c229\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-09-05?11:12??c229\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2020-06-03?21:20??c229\build\
?????目錄???????????0??2020-06-11?21:02??c229\build\classes\
?????目錄???????????0??2020-06-11?21:02??c229\build\classes\c229\
?????目錄???????????0??2020-06-11?21:02??c229\build\classes\c229\dao\
?????文件????????4236??2020-06-11?21:02??c229\build\classes\c229\dao\GoodsDAO.class
?????文件????????5097??2020-06-11?21:02??c229\build\classes\c229\dao\PeopleDAO.class
?????文件????????4613??2020-06-11?21:02??c229\build\classes\c229\dao\SalesDAO.class
?????文件????????3563??2020-06-11?21:02??c229\build\classes\c229\dao\StockDAO.class
?????文件????????3490??2020-06-11?21:02??c229\build\classes\c229\dao\SuppierDAO.class
?????文件????????1789??2020-06-11?21:02??c229\build\classes\c229\dao\UserDAO.class
?????目錄???????????0??2020-06-11?21:02??c229\build\classes\c229\db\
?????文件????????1472??2020-06-11?21:02??c229\build\classes\c229\db\DB.class
?????目錄???????????0??2020-06-11?21:02??c229\build\classes\c229\model\
?????文件?????????766??2020-06-11?21:02??c229\build\classes\c229\model\Code.class
............此處省略113個文件信息