vipsql.java

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

package dao.common.sql;

public interface VipSql {

	// 从数据库操作员信息表中查询得到操作员列表
	// v.vip_id, v.vip_name, v.vip_sex, c.vip_level,c.rest_money,
	// c.card_state, v.vip_phone, c.vip_point, v.vip_birthday, c.regist_date
	public static final String VIP_LIST = "select * from vip v, vip_card c where v.vip_id = c.vip_id";

	// 按照顾客的Id进行查询,得到属性为-同上
	public static final String SEARCH_BY_VIP_ID = "select * from vip v, vip_card c " + "where v.vip_id = c.vip_id and v.vip_id= ?";

	// 按照顾客的姓名进行模糊查询，得到属性为-同上
	public static final String SEARCH_UNCLEAR_BY_VIP_NAME = "select * from vip v, vip_card c " + "where v.vip_id = c.vip_id and v.vip_name like ?";

	// 用传递过来的值插入数据到表VIP中
	public static final String INSERTINTO_VIP_BY_ID = "insert into vip "
	      + "values( ?, ?, ?, to_date(?, 'yyyy-mm-dd'), ?, ?)";

	// 用传递过来的值插入数据到VIP_CARD表中
	public static final String INSERTINTO_CARD_BY_ID = "insert into vip_card "
	      + "values(?, ?, ?, to_date(?, 'yyyy-mm-dd'), ?, ?, ?, ?)";
	// 找出Vip_Card表中card_id的最大值
	public static final String MAX_CARD_ID = "select max(card_id) from vip_card";
	public static final String MAX_VIP_ID = "select max(vip_id) from vip";

	// 使用预编译语句对象更新表vip
	/*public static final String UPDATE_VIP_BY_ID = "update vip set vip_id = ?, vip_name = ?, vip_sex = ?,"
	      + " vip_birthday = to_date(?, 'yyyy-MM-dd'), vip_phone = ?, vip_address = ? where vip_id = ?";*/
	public static final String UPDATE_VIP_BY_ID = "update vip set vip_sex = ?,"
	      + "vip_phone = ?, vip_address = ? where vip_id = ?";
	// 使用预编译语句对象更新表vip_card
	/*public static final String UPDATE_CARD_BY_ID = "update vip_card set vip_id = ?, card_id = ?, vip_pwd = ?,"
	      + " regist_date = to_date(?,'yyyy-MM-dd'), vip_level = ?, rest_money = ?, vip_point = ?, card_state = ? where vip_id = ?";*/
	public static final String UPDATE_CARD_BY_ID = "update vip_card set vip_pwd = ?"+
		"where vip_id = ?";
	
	// 删除编号对应的会员，其中Id是可赋值
	public static final String DELETE_VIP_BY_ID = "delete from vip where vip_id = ?";
	// 删除对应编号的会员卡，其中Id将由赋值得到
	public static final String DELETE_CARD_BY_ID = "delete from vip_card where vip_id = ?";
	
	// 按照会员编号更新剩余金额
	public static final String UPDATE_RESTMONEY_BY_ID ="update vip_card set rest_money = ? where vip_id = ?";
	
	// 会员换卡信息
	public static final String CHANGE_VIP_CARD_ID = "update vip_card set card_id = ?, vip_pwd = ? where vip_id = ?";
	
	// 查找会员充值记录
	public static final String GET_RECHARGE_RECORD ="select * from vip_charge where vip_id = ?";
	// 插入会员充值记录( HH24:mi)
	public static final String INSERT_RECHARGE_RECORD = "insert into vip_charge values(?, to_date(?, 'yyyy-MM-dd'), ?, ?, ?)";

	public static final String INSERT_CARD_LEVEL_ONE = "insert into vip_card_level values('普通',9.0,000,200)";
	
	public static final String INSERT_CARD_LEVEL_TWO = "insert into vip_card_level values('中级',8.0,200,400)";

	public static final String INSERT_CARD_LEVEL_THREE = "insert into vip_card_level values('高级',7.0,400,600)";

	
}