restaurantmenu21.java

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

package restaurant;

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

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

    public Vector selectFood(){
    	  Vector vec=new Vector();
    	  String sql="select * from food";
          ResultSet rs=null;
  
          con = new DBCon();
	      read = new Read(con.getConnection());    
          rs=read.executeQuery(sql); 
          
          try{
            while(rs.next())
            {
            	vec.addElement(rs.getString("name"));
            	vec.addElement(rs.getString("proPlace"));
            	vec.addElement(rs.getString("unit"));
            	vec.addElement(rs.getString("foodType"));
            	vec.addElement(rs.getString("price"));  
            	vec.addElement(rs.getString("retailPrice"));
            	vec.addElement(rs.getString("updateTime"));
            	vec.addElement(rs.getString("remark"));
            }
            
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }
		  exit = new Exit(con.getConnection());
          exit.Close();
          
          return vec;
    	
    }

	public boolean addFood(Vector FoodMessage,String operator){
		  
		 common=new Common();
		 operator=common.toChinese(operator);
		 
		 if(common.haveFood((String)FoodMessage.get(0))){
		    return false;
		 }
	     else{
	     	String sql="insert into food values(";
		        sql+="'"+common.toChinese((String)FoodMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)FoodMessage.get(1))+"',";
    	        sql+="'"+common.toChinese((String)FoodMessage.get(2))+"',";
    	        sql+="'"+common.toChinese((String)FoodMessage.get(3))+"',";
    	        sql+=Integer.parseInt(common.toChinese((String)FoodMessage.get(4))) +",";
    	        sql+=Integer.parseInt(common.toChinese((String)FoodMessage.get(5))) +",";
    	        sql+=Integer.parseInt(common.toChinese((String)FoodMessage.get(6))) +",";
    	        sql+="now(),";
    	        sql+="'"+common.toChinese((String)FoodMessage.get(7))+"')";
    	    
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            common.WriteSystemLog("酒店经理:"+operator+"增加食品:"+common.toChinese((String)FoodMessage.get(0))+"."+common.getNowTime());
             
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
		}
	}
    
    public boolean modifyFood(Vector vec,String operator){
    	
		 common=new Common();
		 String name=common.toChinese((String)vec.get(0));
		 operator=common.toChinese(operator);

		 if(!common.haveFood(name)){
		    return false;
		 }
    	 else{
    	     String sql="update food set ";
    	           sql+="proPlace='"+ common.toChinese((String)vec.get(1)) +"',";
    	           sql+="foodType='"+ common.toChinese((String)vec.get(2)) +"',";
    	           sql+="unit='"+ common.toChinese((String)vec.get(3)) +"',";
    	           sql+="price="+ Integer.parseInt(common.toChinese((String)vec.get(4))) +",";
    	           sql+="retailPrice="+ Integer.parseInt(common.toChinese((String)vec.get(5)))+",";
    	           sql+="discount="+Integer.parseInt(common.toChinese((String)vec.get(6))) +",";
    	           sql+="updateTime=now(),";
    	           sql+="remark='"+ common.toChinese((String)vec.get(7)) +"'";
    	           sql+=" where name='"+name+"'";	
    	     

    	     con = new DBCon();
	         write = new Write(con.getConnection());    
             write.executeUpdate(sql); 
             exit = new Exit(con.getConnection());
             exit.Close();
             
             common.WriteSystemLog("酒店经理:"+operator+"修改食品:"+name+"."+common.getNowTime());
             return true;
             
		  }
    }
      
    public boolean deleteFood(String foodID,String operator){
    	
		 common=new Common();
		 foodID=common.toChinese(foodID);
		 operator=common.toChinese(operator);
		 
		 if(!common.haveFood(foodID)){
		    return false;
		 }
    	 else{
    	   String sql="delete from food where name='"+foodID+"'";
   
           con = new DBCon();
	       write = new Write(con.getConnection());    
           write.executeUpdate(sql); 
           exit = new Exit(con.getConnection());
           exit.Close();
            
           common.WriteSystemLog("酒店经理:"+operator+"删除了食品:"+foodID); 
           return true;
         }
    }
}