releaseassociatordate.java

网吧管理系统JAVA代码

package netbar;

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

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

    //获得已被锁的用户
  public ArrayList  getIdOfUser(){
  ArrayList array=new ArrayList();
  SQLDate.sqldate();
  try{
      Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
      Statement st=con.createStatement();
      ResultSet rs=st.executeQuery("select Id from Card where OnUse='1'");
      while(rs.next()){
          array.add(rs.getString(1));
      }
  }catch(SQLException ee){
      System.out.println(ee);
  }
  return array;
  }

  //释放用户
  public void releaseOfUse(String cardId){
      SQLDate.sqldate();
   try{
       Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
       Statement st=con.createStatement();
       st.executeUpdate("update Card set OnUse='0' where Id='"+cardId+"'");
       st.close();
       con.close();
   }catch(SQLException ee){
   }
  }

    private void jbInit() throws Exception {
    }
}