operatorsql.java

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

package dao.common.sql;

public interface OperatorSql {
	/**
	 * 对数据库中操作员的数据进行的操作
	 */
	// operator_id，operator_name，operator_psw三条件同时匹配得到记录
	public static final String OPERATOR_MATCH = "select * from operator where operator_id = ? "
	      + " and operator_name = ? and operator_psw = ?";
	// 从数据库操作员信息表中查询得到操作员列表
	public static final String OPERATOR_LIST = "select operator_id, operator_name, operator_phone, "
	      + "operator_address, operator_purview from operator";
	// 根据操作员的姓名进行查询
	public static final String SEARCH_OPERATOR_BY_NAME = "select operator_id, operator_name, operator_phone, "
      + "operator_address, operator_purview from operator where operator_name = ?";
	// 根据操作员的编号进行查询
	public static final String SEARCH_OPERATOR_BY_ID = "select operator_id, operator_name, operator_phone, "
      + "operator_address, operator_purview from operator where operator_id = ?";
	// 根据操作员的编号删除相应的记录
	public static final String DELETE_BY_ID = "delete from operator where operator_id = ?";
	
	// 插入操作员信息
	public static final String INSERT_OPERATOR = "insert into operator values(?, ?, ?, ?, ?, ?)";
	// 更新操作员信息，以Id作为标识
	public static final String UPDATE_BY_ID = "update operator set operator_id = ?, operator_name = ?, operator_psw = ?," +
			"operator_purview = ?,operator_phone = ?,operator_address = ? where operator_id = ?";
}