restaurantmenu31.java

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

package restaurant;

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

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

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

    
    
    public Vector getRoomID(){
         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 boolean receiveService(Vector receiveMessage){
    	common = new Common();
    	String sql="insert into roomBook values(";
		        sql+="'"+common.toChinese((String)receiveMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)receiveMessage.get(1))+"',";
    	        sql+="'"+common.toChinese((String)receiveMessage.get(2))+"',";
    	        sql+="'"+common.toChinese((String)receiveMessage.get(3))+"',";
    	        sql+="'"+common.toChinese((String)receiveMessage.get(4))+"',";
    	        sql+="now(),"; 
    	        sql+="'receive')";
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql);  
            
            sql="update room set flag='full' where id='"+receiveMessage.get(4)+"'";
            write.executeUpdate(sql);  
            
            common=new Common();
            common.WriteSystemLog("酒店经理:"+common.toChinese((String)receiveMessage.get(0))+"接待顾客:"+common.toChinese((String)receiveMessage.get(1))+" 房间:"+common.toChinese((String)receiveMessage.get(3)));
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
    }
    
    public boolean BookService(Vector bookMessage){
    	common = new Common();
    	String sql="insert into roomBook values(";
		        sql+="'"+common.toChinese((String)bookMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)bookMessage.get(1))+"',";
    	        sql+="'"+common.toChinese((String)bookMessage.get(2))+"',";
    	        sql+="'"+common.toChinese((String)bookMessage.get(3))+"',";
    	        sql+="'"+common.toChinese((String)bookMessage.get(4))+"',";
    	        sql+="now(),";
    	        sql+="'book')";
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            sql="update room set flag='full' where id='"+bookMessage.get(4)+"'";
            write.executeUpdate(sql);  
              
            common=new Common();
            common.WriteSystemLog("酒店经理:"+common.toChinese((String)bookMessage.get(0))+"预定顾客"+common.toChinese((String)bookMessage.get(1))+" 房间:"+common.toChinese((String)bookMessage.get(3)));
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
    }

}