donenetting.java

网吧管理系统JAVA代码

package netbar;

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

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

    //获取没上机的机器号
    public ArrayList getcomputerId(){
    SQLDate.sqldate();
    ArrayList array=new ArrayList();
      try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from Computer where OnUse='0'");
    while(rs.next()){
    array.add(rs.getString(1));
    }
    rs.close();
    st.close();
    con.close();
  //  for(int i=0;i<array.size();i++)
      //  System.out.println(array.get(i));
    }catch(SQLException ee){
    //System.out.println(ee);
    }
    return array;
    }

    //获取余额
    public int ishavebalance(String cardId){
        int gain=0;
        SQLDate.sqldate();
        try{
            Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
            Statement st=con.createStatement();
            //System.out.println("用费"+fee);
            ResultSet rs=st.executeQuery("select Balance from Card where Id='"+cardId+"'");
            rs.next();
            gain=rs.getInt(1);
            // System.out.println("记录收费"+gain);
            rs.close();
            st.close();
            con.close();
        }catch(SQLException ee){
        }
        return gain;
    }

    //记录数据
    public  void notedate(String cardId,String computerId,String begintime){
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    st.executeUpdate("insert into Record (CardId,ComputerId,BeginTime) values('"+cardId+"','"+computerId+"','"+begintime+"')");
    st.executeUpdate("update Computer set OnUse='1' where Id='"+computerId+"'");
   }catch(SQLException ee){
    //System.out.println(ee);
    }
    }

    //判断上机的密码和帐号
    public boolean istrue(String cardId,String pass){
      boolean avaiable=false;
      SQLDate.sqldate();
      try{
          Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
          Statement st=con.createStatement();
          ResultSet rs=st.executeQuery("select * from Card ");
          while(rs.next()){
              if (rs.getString(1).equals(cardId) && rs.getString(2).equals(pass)) {
                  avaiable = true;
                  break;
              } else
                  avaiable = false;
          }
          rs.close();
          st.close();
          con.close();
      }catch(SQLException ee){
          //System.out.println("判断密码有误");
          //System.out.println(ee);
    }
    return avaiable;
  }

  //判断此卡号是否已经正在使用
  public boolean isDoNet(String cardId){
      boolean avaiable=true;
     SQLDate.sqldate();
           try{
               Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
               Statement st=con.createStatement();
               ResultSet rs=st.executeQuery("select CardId from Record where Endtime='1900-01-01 00:00:00' and Fee=0");
               while(rs.next()){
                   if(rs.getString(1).equals(cardId)){
                       avaiable=false;
                       break;
                   }
               }
               rs.close();
               st.close();
               con.close();
           }catch(SQLException ee){
             //  System.out.println(ee);
         }
         return avaiable;
  }

  //是否锁定
  public String isLocked(String cardId){
       String onuse="";;
      SQLDate.sqldate();
            try{
                Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
                Statement st=con.createStatement();
                ResultSet rs=st.executeQuery("select OnUse from Card");
                rs.next();
                onuse=rs.getString(1);
                rs.close();
                st.close();
                con.close();
            }catch(SQLException ee){
              //  System.out.println(ee);
          }
          return onuse;
  }

    private void jbInit() throws Exception {
    }
}