operatordao.java

基于JSF开发的一个洒店管理系,具有中文

/*
 * 创建日期 2005-10-17
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.husthotel.datebase;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import net.husthotel.beans.Order;

public class OperatorDAO extends DataBase {
	private ResultSet rst = null;
	public OperatorDAO() {

	}
/**
 * 登陆.
 * @param name   .
 * @param password  .
 * @return   true/false  .
 * @throws SQLException  .
 */
	public boolean login(String name, String password) throws SQLException {
		boolean bologin = false;
		String sql = "select * from operator where name='" + name
				+ "'and password='" + password + "'";
		rst=super.executeQuery(sql);
		if (rst.next()) {
			bologin = true;
		} else {
			bologin = false;
		}
		rst.close();
		return bologin;
	}

	
/**
 * 退出 .
 *
 */
	public void logout() {

	}

	
/**
 * 删除订单 .
 * @param orderNum  .
 * @return true/false.
 * @throws SQLException  .
 * @throws NoOrderAvailableException   .
 */
	public boolean deleteOrder(String orderNum) throws SQLException,
			NoOrderAvailableException {
		boolean bodelte = false;
		String sql = "delete from hotelorder where orderNum='" + orderNum + "'";
		if (super.executeUpdate(sql))
			bodelte = true;
		else {
			bodelte = false;
			throw new NoOrderAvailableException("no order available");
		}
		return bodelte;
	}

	/**
	 * modify the order.
	 * @param morder  .
	 * @return  true/false.
	 * @throws SQLException.
	 */
	public boolean modifyOrder(Order morder) throws SQLException {
		boolean bomodify = false;
		String sql = "update hotelorder set  name='" + morder.getName() + "',"
				+ "sex='" + morder.getSex() + "', telNum='"
				+ morder.getTelNum() + "', orderState='"
				+ morder.getOrderState() + "', bookDate='"
				+ new java.sql.Date (morder.getBookDate().getTime()) + "', checkinDate='" // 把java.util.Date 转换为java.sql.Date
				+ new java.sql.Date (morder.getCheckinDate().getTime()) + "',checkoutDate='"
				+ new java.sql.Date (morder.getCheckoutDate().getTime()) + "', roomType='"
				+ morder.getRoomType() + "', bookNum='" + morder.getBookNum()
				+ "', specialDesc='" + morder.getSpecialDesc() + "', roomNum='"
				+ morder.getRoomNum() + "' where orderNum='"
				+ morder.getOrderNum() + "'";
		System.out.println(sql); ////-------------------
		if (super.executeUpdate(sql))
			bomodify = true;
		else
			bomodify = false;
		return bomodify;
	}

	public ArrayList<Order> queryOrder() throws SQLException {
		ArrayList<Order> querylist;
		querylist = new ArrayList<Order>();
		//Order quorder = new Order(); //新建的Order应该在 rst.next 循环中 要不然引用是指向一个对象的
		String sql = "select * from hotelorder";
		rst = executeQuery(sql);
		while (rst.next()) {
			//--------------------------
			System.out.println(rst.getString("name"));
			Order quorder = new Order();
			quorder.setName(rst.getString("name"));
			quorder.setBookDate(rst.getDate("bookDate"));
			quorder.setBookNum(rst.getString("bookNum"));
			quorder.setCheckinDate(new java.util.Date(rst.getDate("checkinDate").getTime())); //把数据转换为需要的格式
			quorder.setCheckoutDate(new java.util.Date(rst.getDate("checkoutDate").getTime()));//
			quorder.setOrderNum(rst.getString("orderNum"));
			quorder.setOrderState(rst.getString("orderState"));
			quorder.setRoomNum(rst.getString("roomNum"));
			quorder.setRoomType(rst.getString("roomType"));
			quorder.setSex(rst.getString("sex"));
			quorder.setSpecialDesc(rst.getString("specialDesc"));
			quorder.setTelNum(rst.getString("telNum"));
			querylist.add(quorder);
		}
		rst.close();
		return querylist;

	}
	
	/**
	 * query order by condition.
	 * @param a query sql sendence like "where ?=?".
	 * @return  orderlist.
	 * @throws SQLException.
	 */
	
	public ArrayList<Order> queryOrderInfoByCondition(String querySql) throws SQLException {
		ArrayList<Order> queryList = new ArrayList<Order>();;
		
		String sql = "select * from hotelorder " + querySql;
		rst = super.executeQuery(sql);
		while (rst.next()) {
			Order order = new Order();
			order.setName(rst.getString("name"));
			order.setBookDate(rst.getDate("bookDate"));
			order.setBookNum(rst.getString("bookNum"));
			order.setCheckinDate(rst.getDate("checkinDate"));
			order.setCheckoutDate(rst.getDate("checkoutDate"));
			order.setOrderNum(rst.getString("orderNum"));
			order.setOrderState(rst.getString("orderState"));
			order.setRoomNum(rst.getString("roomNum"));
			order.setRoomType(rst.getString("roomType"));
			order.setSex(rst.getString("sex"));
			order.setSpecialDesc(rst.getString("specialDesc"));
			order.setTelNum(rst.getString("telNum"));
			queryList.add(order);
		}
		rst.close();
		return queryList;
	}
}