dbgetclothessql.java

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

package dao.common.sql;

public interface DbGetClothesSql {
	public String GET_VIPCARDVO_BY_ID = "select * from vip_card where vip_id = ?";
	public String GET_VIPVO_BY_ID = "select * from vip where vip_id = ?";
	public String GET_VIP_DISCOUNT_BY_LEVEL = "select vip_discount from vip_card_level where vip_level = ?";
	public String GET_MAX_ORDERID = "select max(order_id) max_id from oneOrder";
	public String REGIST_AN_ORDER = "insert into oneOrder values(?,?,?,to_date(?,'yyyy-mm-dd')," +
			                           "to_date(?,'yyyy-mm-dd'),?,?,?)";  
	public String REGIST_ORDER_ITEM = "insert into order_item values(?,?,?,?,?,?,?,?,?)";
	public String REGIST_VIPCUNSUMEVO = "insert into vip_consume values(?,?,to_date(?,'yyyy-mm-dd'),?,?,?)";
	public String GET_VIP_POINT_BY_ID = "select vip_point from vip_card where vip_id = ?";
	public String GET_VIP_LEVEL_BY_POINT = "select vip_level from vip_card_level " +
			                             "where ? between point_lower and point_upper";
	public String GET_VIP_REST_MONEY_BY_ID =  "select rest_money from vip_card where vip_id = ?";
	public String SET_ORDER_PAID_OR_NOT = "update oneOrder set paid_or_not = ?,take_or_not = ? where order_id = ?";
	
	public String UPDATE_VIP_CARD_AFTER_PAYING = "update vip_card set vip_level = ?," +
			                            "rest_money = rest_money - ?,vip_point = vip_point + ? where vip_id = ?";
	public String SEARCH_CLOTHESTYPE_BY_NAME = "select * from clothes_type " +
			"where clothes_name like '%'||?||'%'";
	public String SEARCH_CLOTHESTYPE_BY_SERVICETYPE = "select * from clothes_type " +
			"where service_type like '%'||?||'%'";
	public String SEARCH_CLOTHESTYPE_BY_NAME_TYPE = "select * from clothes_type" +
			" where clothes_name like '%'||?||'%' and service_type like '%'||?||'%'";
}