manageroperate.java

模拟银行的ATM自动取款机

import java.sql.*;

public class ManagerOperate 
{
  private String mid;
  private String mcode;
  private int ifmaster;
  private String mname;
  private String idcard;
  ManagerDiary diary;
  
  
  public ManagerOperate()
  {
   mid=new String();
   mcode=new String();
   mname=new String();
   idcard=new String();
   diary=new ManagerDiary();
}


  //检查管理员密码是否正确 
   
  public int CheckCode(String ID,String CODE) 
   {
    Connection con;Statement sql;ResultSet rs;  
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db2","","");
    sql=con.createStatement();
    rs=sql.executeQuery("SELECT * FROM master where id='"+ID+"'");
    if(rs.next())
    {
      mid=rs.getString(1);mcode=rs.getString(2);mname=rs.getString(3);idcard=rs.getString(4);ifmaster=rs.getInt(5);
      
      con.close();
         if(mcode.equals(CODE))
         { //注意要在数据库内加入登陆进去的时间
            //ManagerDiary diary=new ManagerDiary();
            diary.setlogintime(ID);
            if(ifmaster==1)
            return 2;//是超级管理员
            else
            return 1;//是普通管理员
         }
         else
         {
            return 3;//密码错误
         }
      
      //con.close();
   }
       else 
       {con.close();return 0;}//不存在这个帐号
   }
   catch(SQLException e1){System.out.println(e1.getMessage());return 0;}

}

public void leave()
{
   
   diary.setlogouttime();
}

//创建一个新的管理员

public void CreateManager(String ID,String CODE,String NAME,String IDCARD,int MASTER)
 {Connection con;Statement sql;ResultSet rs;
 
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db2","","");
    sql=con.createStatement();
    sql.execute("insert into master values('"+ID+"','"+CODE+"','"+NAME+"','"+IDCARD+"',"+MASTER+")");
    
 con.close(); }
    catch(SQLException e1){System.out.println("SQLException:"+e1.getMessage());}
    
  }
 
//修改管理员的密码 
public void ModifyCode(String NEWCODE,String ID)
{
   Connection con;Statement sql;ResultSet rs;
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db2","","");
    sql=con.createStatement();
    
    sql.executeUpdate("update master set code='"+NEWCODE+"' where id='"+ID+"'");
    con.close();
    
  }
    catch(SQLException e1){System.out.println("bbb");}
    }
 
//删除某个管理员所有资料 
 public void RemoveManager(String ID)
 {
    Connection con;Statement sql;ResultSet rs;
 
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db2","","");
    sql=con.createStatement();
   // System.out.println(sql.execute("select * from master where id='"+ID+"'"));
    System.out.println(sql.executeUpdate("delete from master where id='"+ID+"'"));
    con.close();
}
catch(SQLException e){System.out.println(e.getMessage());}
    }
    
//显示某个管理员的所有信息
public ManagerOperate getInfo(String ID)

{
    Connection con;Statement sql;ResultSet rs;
    ManagerOperate manager1=new ManagerOperate();
   
   
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e){}
   try
   {con=DriverManager.getConnection("jdbc:odbc:db2","","");
    sql=con.createStatement();
   // System.out.println(sql.execute("select * from master where id='"+ID+"'"));
    rs=sql.executeQuery("select * from master where id='"+ID+"'");
    if(rs.next())
    {
      manager1.mid=ID;manager1.mname=rs.getString(3);manager1.idcard=rs.getString(4);manager1.ifmaster=rs.getInt(5);
   }
   else{
    con.close();
    manager1.mid="00000";}
   }
catch(SQLException e){System.out.println(e.getMessage());}
finally{return manager1;}
}
   



public String getid()
{
   return mid;
}
public String getname()
{
   return mname;
}
public String getidcard()
{
   return idcard;
}
public int getifmaster()
{
   return ifmaster;
}


 
 
 
 
 
/*public static void main(String args[])
{  ManagerOperate manager=new ManagerOperate();
  //manager.CreateManager("001","456","xiaoyang2","320",1);
   //System.out.println(manager.CheckCode("001","123"));
  // manager.ModifyCode("234","111");
  // manager.RemoveManager("001");
   System.out.println(manager.CheckCode("002","1234"));
   System.out.println(manager.getifmaster());
   System.out.println(manager.getidcard());
}*/
 
 
 
 
 
 }