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

public class RestaurantMenu12{

	private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
    ResultSet rs=null;
    
	public void selectLogInfo(){
	     String sql="select * from system";
         
         con = new DBCon();
	     read = new Read(con.getConnection());    
         rs=read.executeQuery(sql);       
    }
      
    public Vector getLogInfo(){
    	Vector vec = new Vector();
    	try{
    		while(rs.next()){
    			vec.addElement(rs.getString("information"));
    		}
        }catch(SQLException e){
		   System.err.println(e.getMessage());
		}
		exit = new Exit(con.getConnection());
        exit.Close();
        
		return vec;
    }

    public void clearLog(String operator){
    	
    	   common = new Common();
    	   operator=common.toChinese(operator);
    	   
    	   String sql="delete from system";
   
           con = new DBCon();
	       write = new Write(con.getConnection());    
           write.executeUpdate(sql); 
           exit = new Exit(con.getConnection());
           exit.Close();
           
           common.WriteSystemLog("酒店經理:"+operator+"清空了日志"); 
            
    }
}