deleteproduct.java

这是一个网上卖衣服的网站项目

/*********************************
 *
 *从数据库删除产品
 *
 */

package mylib;

public class DeleteProduct {
	
	
	private DeleteProduct() {
		
	}
	
	
	public DeleteProduct getInstance() {
		return dp;
	}
	
	/**************************************
	 *
	 *从数据库删除指定ISDN的产品
	 **************************************/
	public int delete(String isdn) {
		ConnectionDB condb = new ConnectionDB();
		String sqlstr = "Delete from tb_Product where ISDN = \'" + isdn + "\'";
		
		int i = condb.executeUpdate(sqlstr);
		
		condb.close();
		
		return i;
	}
	/**************************************
	 *
	 *从数据库删除所有产品!
	 **************************************/
	public int formatProductTable() {
		ConnectionDB condb = new ConnectionDB();
		String sqlstr = "Delete from tb_Product";
		
		int i = condb.executeUpdate(sqlstr);
		
		condb.close();
		
		return i;
	}
	
	private static DeleteProduct dp = new DeleteProduct();
}