managerdiary.java

模拟银行的ATM自动取款机

import java.util.*;
import java.sql.*;
class ManagerDiary
{
   private String time1;
  private String time2;
   
   public ManagerDiary()
   {
      time1=new String();
     time2=new String();
   }
//在管理员日志中写入管理员的登陆时间   
   public void setlogintime(String ID)
   {
      int year,month,date,hour,minute,second;
      Calendar cal=Calendar.getInstance();
      year=cal.get(Calendar.YEAR);
      month=cal.get(Calendar.MONTH);
      date=cal.get(Calendar.DATE);
      hour=cal.get(Calendar.HOUR_OF_DAY);
      minute=cal.get(Calendar.MINUTE);
      second=cal.get(Calendar.SECOND);
      time1=+year+"年"+month+"月"+date+"日"+hour+"点"+minute+"分"+second+"秒";
      
   
  
   
     
      Connection con;Statement sql;ResultSet rs;
 
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db4","","");
    sql=con.createStatement();
    sql.execute("insert into managerdiary values('"+ID+"','"+time1+"','wait')");
    
 con.close(); }
    catch(SQLException e1){System.out.println("SQLException:"+e1.getMessage());}
    
  }


//在管理员日志中写入管理员的离开时间  
   public void setlogouttime()
   {
      int year,month,date,hour,minute,second;
      Calendar cal=Calendar.getInstance();
      year=cal.get(Calendar.YEAR);
      month=cal.get(Calendar.MONTH);
      date=cal.get(Calendar.DATE);
      hour=cal.get(Calendar.HOUR_OF_DAY);
      minute=cal.get(Calendar.MINUTE);
      second=cal.get(Calendar.SECOND);
      time2=+year+"年"+month+"月"+date+"日"+hour+"点"+minute+"分"+second+"秒";
      
   
  
   
     
      Connection con;Statement sql;ResultSet rs;
 
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db4","","");
    sql=con.createStatement();
   sql.executeUpdate("update managerdiary set logouttime='"+time2+"' where logintime='"+time1+"'");
    
 con.close(); }
    catch(SQLException e1){System.out.println("SQLException:"+e1.getMessage());}
    
  }
  
  
  //删除管理员日志
  public void DeleteDiary()
  {
   
   
   Connection con;Statement sql;ResultSet rs;
 
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db4","","");
    sql=con.createStatement();
   System.out.println(sql.executeUpdate("delete * from managerdiary"));
 con.close(); }
    catch(SQLException e1){System.out.println("SQLException:"+e1.getMessage());}
  }
 
    
    
 //显示所有管理员日志   
 public String ShowDiary()
 {
   Connection con;Statement sql;ResultSet rs;
   String DiaryResult=new String("显示所有管理员日志:"+"\n");
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db4","","");
    sql=con.createStatement();
    rs=sql.executeQuery("SELECT * FROM managerdiary");
    
    while(rs.next())
    {DiaryResult+="管理员:"+rs.getString(1)+"   登陆时间"+rs.getString(2)+",  离开时间"+rs.getString(3)+"\n";
    }
 con.close(); return DiaryResult; }
   catch(SQLException e1){System.out.println("SQLException:"+e1.getMessage());}
   finally{return DiaryResult;}
  


   }
 }
 


      
      
    
    
      
      
      
      
      
      
 /*public static void main(String args[])
  {
   ManagerDiary diary=new ManagerDiary();
  //diary.setlogintime("004");
  //diary.setlogouttime();
  diary.DeleteDiary();
}*/