lockedmanagerdate.java

java 网吧项目 源码

package netbar;

import java.sql.*;

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


    //判断该管理员是否有权删除 这个管理员
    public boolean iscan(String cardId){
        boolean avaiable=true;
        SQLDate.sqldate();
    try{
        Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select LevelOfManager from Manager where Id='"+cardId+"'");
        rs.next();
        if(rs.getString(1).equals("0")){
            avaiable=true;
        }
        else
            avaiable=false;
    }catch(SQLException ee){
        System.out.println(ee);
    }
    return avaiable;
    }

    //根据卡号更改状态
  public void rewordislocaked(String cardId){
      SQLDate.sqldate();
  try{
      Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
      Statement st=con.createStatement();
      st.executeUpdate("update Manager set IsLocked='1' where Id='"+cardId+"' ");
      st.close();
      con.close();
  }catch(SQLException ee){
      System.out.println(ee);
  }
}

    private void jbInit() throws Exception {
    }
}