addmanagerdate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;

public class AddManagerDate {
    public AddManagerDate() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //记录添加管理员的信息
    public void notedate(String cardId,String pass,String lever,int age,String sex,String paper){
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    st.executeUpdate("insert into Manager(Id,Password,LevelOfManager,Age,Sex,PaperOfManager) values('"+cardId+"','"+pass+"','"+lever+"' ,'"+age+"','"+sex+"','"+paper+"')");
    }catch(SQLException ee){
    System.out.println(ee);
    }
    }

    //判断帐号是否存在
    public boolean isBeing(String cardId){
    boolean avaiable=false;
    SQLDate.sqldate();
   try{
   Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
   Statement st=con.createStatement();
   ResultSet rs=st.executeQuery("select Id from Manager ");
   while(rs.next()){
   if(cardId.equals(rs.getString(1)))
       avaiable=true;
   }
   }catch(SQLException ee){
   }
   return avaiable;
   }


    private void jbInit() throws Exception {
    }

}