restaurantmenu33.java

酒店管理asp的源代码和各种文档说明,很齐全的,只要你解压后就能运行程序.

package restaurant;

import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
import java.util.Calendar;
import java.util.Date;

public class RestaurantMenu33{
    
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;

     public Vector OvertimeBookRoomID(){
         Vector vec = new Vector();
         String sql="select * from roomBook where DATEDIFF('d',bookDate,now()) >10";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
    			vec.addElement(rs.getString("roomNo"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          return vec;
    }

     public Vector oldEmptyRoomID(){
         Vector vec = new Vector();
  
         String sql="select * from room where flag='full'";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
    			vec.addElement(rs.getString("id"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          return vec;
    }

     public Vector newEmptyRoomID(){
         Vector vec = new Vector();
  
         String sql="select * from room where flag='empty'";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
    			vec.addElement(rs.getString("id"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          return vec;
    }


    public String searchOvertimeBook(){
    	  ResultSet rs=null;
    	  Vector vec = new Vector();
	      String sql="select * from roomBook where DATEDIFF('d',bookDate,now()) >10 AND jy='book'";
    	  
          con = new DBCon();
	      read = new Read(con.getConnection());    
          rs=read.executeQuery(sql); 
          
          try{
              while(rs.next()){
              	 //vec.addElement(rs.getString("operator"));
              	 vec.addElement(rs.getString("roomNo"));
              	 vec.addElement(rs.getString("customer"));
              	 vec.addElement(rs.getString("tel"));
              	 vec.addElement(rs.getString("bookDate"));
              	 //vec.addElement(rs.getString("remark"));
              	 exit = new Exit(con.getConnection());
                 exit.Close();	              	
          }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }
         
          String  str=""; 
                  
          for(int i=0; i<vec.size();)    
          {
                  str+="房号:"+vec.get(i++)+"<br>";
			      str+="顾客:"+vec.get(i++)+"<br>";
			      str+="电话:"+vec.get(i++)+"<br>";
			      str+="预定日期:"+vec.get(i++)+"<br><br>";
          }
          
          if(vec.size()==0)
              str="没有预定超时的顾客!";
          return str;
    }

    public boolean removeBook(String removeID,String operator){ 	
    	  common=new Common();
    	  
    	  removeID=common.toChinese(removeID);
    	  operator=common.toChinese(operator);
    	  
    	  if(!common.roomExist(removeID)){	 
    	      return false;
    	  }
          String sql="delete * from roomBook where roomNo='"+removeID+"'";
            	     
    	  con = new DBCon();
	      write = new Write(con.getConnection());    
          write.executeUpdate(sql); 
            
          sql="update room set flag='empty' where id='"+removeID+"'"; 
          write.executeUpdate(sql); 
          exit = new Exit(con.getConnection());
          exit.Close();      
          
          
          common.WriteSystemLog("操作员:"+operator+"取消预定房间:"+removeID+"."+common.getNowTime());
          return true;
    }
    public boolean changeRoom(String oldRoom,String newRoom,String operator){
    	
    	  common=new Common();
    	  operator=common.toChinese(operator);
    	  newRoom=common.toChinese(newRoom);
    	  oldRoom=common.toChinese(oldRoom);
    	  
    	  if(!common.roomExist(oldRoom)){	 
    	      return false;
    	  }
    	  if(common.roomExist(newRoom)){	 
    	      return false;
    	  }	  
    	  if(common.roomExist(newRoom)){	 
    	      return false;
    	  }
          String sql="update roomBook set roomNo='"+newRoom+"' where roomNo='"+oldRoom+"'";
            	     
    	  con = new DBCon();
	      write = new Write(con.getConnection());    
          write.executeUpdate(sql); 
          exit = new Exit(con.getConnection());
          exit.Close();	
          
          common.WriteSystemLog("操作员:"+operator+"把房间:"+oldRoom+"换到了房间:"+newRoom+"."+common.getNowTime());
          return true;
    }
}