landingofmanagerdate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;
import java.util.*;

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

    //判断密码,帐号是否输入正确
    //判断是否锁定
    //判断管理员等级
    public ArrayList istrue(String cardId){
    ArrayList array=new ArrayList();
    Connection con=null;
    Statement st=null;
    ResultSet rs=null;
    SQLDate.sqldate();
    try{
     con=DriverManager.getConnection("jdbc:odbc:netbar");
     st=con.createStatement();
     rs=st.executeQuery("select * from Manager where Id='"+cardId+"'");
     rs.next();
     array.add(rs.getString(2));
     array.add(rs.getString(4));
     array.add(rs.getString(5));
    }catch(SQLException ee){
    }finally{
            try {
                rs.close();
                st.close();
                con.close();
    }catch(Exception ee){}
    }
    return array;
    }

    //判断是否有这个卡号

    //记录数据,更新状态
    public void noteDate(String cardId,String begintime){
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    st.executeUpdate("update Manager set Onuse=1 where Id='"+cardId+"'");
    st.executeUpdate("insert into WorkOfManager(ManagerId,BeginTime) values('"+cardId+"','"+begintime+"')");
    st.close();
    con.close();
    }catch(SQLException ee){
    }
    }
    //判断该卡号是否存在
    public boolean ishava(String cardId){
        Connection con=null;
        Statement st=null;
        ResultSet rs=null;
        boolean avaiable=false;
        SQLDate.sqldate();
        try{
            con=DriverManager.getConnection("jdbc:odbc:netbar");
            st=con.createStatement();
            rs=st.executeQuery("select Id from Manager");
            while(rs.next()){
                if (rs.getString(1).equals(cardId)){
                    avaiable = true;
                    break;
                }
                else
                    avaiable = false;
            }
            rs.close();
            st.close();
            con.close();
        }catch(SQLException ee){
       }
       return avaiable;
    }

    private void jbInit() throws Exception {
    }
}