dbclothesadditionsql.java

一个优秀的干洗店管理系统

package dao.common.sql;

public interface DbClothesAdditionSql {
	public String INSERT_CLOTHES_BRAND = "insert into clothes_brand_set values(?)";
	public String INSERT_CLOTHES_COLOR = "insert into clothes_color_set values(?)";
	public String INSERT_CLOTHES_ACCESSORY = "insert into clothes_accessory_set values(?)";
	public String INSERT_CLOTHES_FLAW = "insert into clothes_flaw_set values(?)";
	
	public String FIND_ALL_CLOTHES_BRAND = "select CLOTHES_BRAND from clothes_brand_set";
	public String FIND_ALL_CLOTHES_ACCESSORY = "select CLOTHES_ACCESSORY from clothes_accessory_set";
	public String FIND_ALL_CLOTHES_COLOR = "select CLOTHES_COLOR from clothes_color_set";
	public String FIND_ALL_CLOTHES_FLAW = "select CLOTHES_FLAW from clothes_flaw_set";
	
	public String DELETE_CLOTHES_BRAND = "delete from clothes_brand_set where CLOTHES_BRAND = ?";
	public String DELETE_CLOTHES_ACCESSORY = "delete from clothes_accessory_set where CLOTHES_ACCESSORY = ?";
	public String DELETE_CLOTHES_COLOR = "delete from clothes_color_set where CLOTHES_COLOR = ?";
	public String DELETE_CLOTHES_FLAW = "delete from clothes_flaw_set where CLOTHES_FLAW = ?";
 
	public String UPDATE_CLOTHES_BRAND  =  "update clothes_brand_set set clothes_brand = ? where clothes_brand = ?";
	public String UPDATE_CLOTHES_ACCESSORY  =  "update clothes_accessory_set set CLOTHES_ACCESSORY = ? where CLOTHES_ACCESSORY = ?";
	public String UPDATE_CLOTHES_COLOR  =  "update clothes_color_set set CLOTHES_COLOR = ? where CLOTHES_COLOR = ?";
	public String UPDATE_CLOTHES_FLAW =  "update clothes_flaw_set set CLOTHES_FLAW = ? where CLOTHES_FLAW = ?";	
}