package?database;
import?java.sql.*;
public?class?Admin{
	private?String?admin_item=null;
	private?String?admin_price=null;
	private?String?admin_store=null;
	private?String?admin_sold=null;
	private?String?admin_sort=null;
	private?String?admin_id=null;
	public?String?getAdmin_item（）?{
		return?admin_item;
	}
	public?void?setAdmin_item（String?admin_item）?{
		this.admin_item?=?admin_item;
	}
	public?String?getAdmin_price（）?{
		return?admin_price;
	}
	public?void?setAdmin_price（String?admin_price）?{
		this.admin_price?=?admin_price;
	}
	public?String?getAdmin_store（）?{
		return?admin_store;
	}
	public?void?setAdmin_store（String?admin_store）?{
		this.admin_store?=?admin_store;
	}
	public?String?getAdmin_sold（）?{
		return?admin_sold;
	}
	public?void?setAdmin_sold（String?admin_sold）?{
		this.admin_sold?=?admin_sold;
	}
	public?String?getAdmin_sort（）?{
		return?admin_sort;
	}
	public?void?setAdmin_sort（String?admin_sort）?{
		this.admin_sort?=?admin_sort;
	}
	public?String?getAdmin_id（）?{
		return?admin_id;
	}
	public?void?setAdmin_id（String?admin_id）?{
		this.admin_id?=?admin_id;
	}
	public?Admin（）{}
	public?Admin（String?aString?bString?cString?dString?eString?f）{
		admin_item=a;
		admin_price=b;
		admin_store=c;
		admin_sold=d;
		admin_sort=e;
		admin_id=f;
	}
	public?int?Add（）?throws?ClassNotFoundException?SQLException{
		ConnectDbase?cdb=new?ConnectDbase（）;
		Connection?conn=cdb.getConnection（）;
		String?sql?=?“insert?into?item?（商品單價存貨售出分類書籍編號熱銷）?values?（‘“+?admin_item?+“‘‘“+?admin_price?+“‘‘“+?admin_store?+“‘‘“+?admin_sold+“‘‘“+?admin_sort+“‘‘“+?admin_id+“‘‘0‘）“;
		java.sql.Statement?statement?=?conn.createStatement（）;
		int?cnt=statement.executeUpdate（sql）;
		if（statement!=null）?statement.close（）;
		if（conn!=null）?conn.close（）;	
		return?1;
	}
	public?int?Delete（）?throws?ClassNotFoundException?SQLException{
		ConnectDbase?cdb=new?ConnectDbase（）;
		Connection?conn=cdb.getConnection（）;
		String?sql?=?“delete?from?item??where?商品?=?‘“?+?admin_item?+“‘?and?單價=‘“+?admin_price?+“‘“;
		java.sql.Statement?statement?=?conn.createStatement（）;
		int?cnt=statement.executeUpdate（sql）;
		if（statement!=null）?statement.close（）;
		if（conn!=null）?conn.close（）;	
		return?cnt;
	}
	public?int?Revise（）?throws?ClassNotFoundException?SQLException{
		ConnectDbase?cdb=new?ConnectDbase（）;
		Connection?conn=cdb.getConnection（）;
		String?sql?=?“update?item?set?單價=‘“+admin_price+“‘存貨=‘“+admin_store+“‘售出=‘“+admin_sold+“‘分類=‘“+admin_sort+“‘書籍編號=‘“+admin_id+“‘熱銷=‘0‘?where?商品?=?‘“?+?admin_item?+“‘“;
		java.sql.Statement?statement?=?conn.createStatement（）;
		int?cnt=statement.executeUpdate（sql）;
		if（statement!=null）?statement.close（）;
		if（conn!=null）?conn.close（）;	
		return?cnt;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-14?19:30??book_sale\
?????文件????????1177??2017-11-12?18:42??book_sale\.classpath
?????文件????????1334??2017-11-03?09:05??book_sale\.project
?????目錄???????????0??2017-11-14?19:30??book_sale\.settings\
?????文件?????????522??2017-10-14?13:43??book_sale\.settings\.jsdtscope
?????文件??????????66??2017-11-11?17:23??book_sale\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-10-14?13:43??book_sale\.settings\org.eclipse.jdt.core.prefs
?????文件?????????486??2017-11-03?09:05??book_sale\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-10-14?13:43??book_sale\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-10-14?13:43??book_sale\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-10-14?13:43??book_sale\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\meta-INF\
?????文件??????????39??2017-10-14?13:43??book_sale\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\WEB-INF\
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\WEB-INF\classes\database\
?????文件????????3824??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Admin.class
?????文件????????1421??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Books.class
?????文件????????4710??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Buy.class
?????文件????????2051??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\ConnectDbase.class
?????文件????????2421??2017-11-14?17:49??book_sale\WebRoot\WEB-INF\classes\database\Login.class
?????文件????????2511??2017-11-14?17:56??book_sale\WebRoot\WEB-INF\classes\database\Register.class
?????文件????????2385??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Shopping_trolley.class
?????文件????????2334??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Sort.class
?????文件????????1273??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\database\Users.class
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\WEB-INF\classes\filter\
?????文件????????2359??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\filter\Shopping_Trolley_filter.class
?????目錄???????????0??2017-11-14?19:30??book_sale\WebRoot\WEB-INF\classes\servlets\
?????文件????????2604??2017-11-14?17:42??book_sale\WebRoot\WEB-INF\classes\servlets\DoAddorSub.class
?????文件????????3791??2017-11-14?17:51??book_sale\WebRoot\WEB-INF\classes\servlets\DoAdmin.class
............此處省略1013個文件信息