dbclothestypesql.java

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

package dao.common.sql;

public interface DbClothesTypeSql {
	public String INSERT_CLOTHESTYPE = "insert into clothes_type values" +
			"(?,?,?,?,?,?,to_date(?,'yyyy-mm-dd'))";
	
	public String FIND_ALL_CLOTHESTYPE = "select clothes_id,clothes_name,service_type," +
			"unit_original_price,lowest_discount,operator_name,add_date from clothes_type";
	
	public String MODIFY_CLOTHESTYPE = "update clothes_type set clothes_name = ?,service_type = ?," +
			"unit_original_price = ?,lowest_discount = ? where clothes_id = ?";
	
	public String DELETE_CLOTHESTYPE = "delete from clothes_type where clothes_id = ?";
}