timerdao.java

来自「基于JSF开发的一个洒店管理系,具有中文」· Java 代码 · 共 23 行

package net.husthotel.datebase;

import java.util.Date;
import java.sql.SQLException;

public class TimerDAO extends DataBase {
	public boolean clearOrder(Date clearDate) throws SQLException {
		// 删除顾客没有按入住时间入住的订单
		String sql1 = "delete  from hotelorder where checkinDate > '"
				+ new java.sql.Date(clearDate.getTime()) + "'"
				+ " and orderState='undealed'";
		// 删除已经处理完,顾客退出时间已经过了的订单
		String sql2 = "delete from hotelorder where checkoutDate < '"
				+ new java.sql.Date(clearDate.getTime()) + "'"
				+ " and orderState='dealed'";
		if (executeUpdate(sql1) && executeUpdate(sql2))
			return true;
		else
			return false;
	}

}