businessaction.java~24~

来自「一个java+sql2000开发的网吧管理系统」· JAVA~24~ 代码 · 共 65 行

package com.jbaptech.accp.netbar.client;

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


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 北京阿博泰克北大青鸟信息技术有限公司</p>
 *
 * @author Michael Luo
 * @version 1.0
 */
public class BusinessAction {

  public BusinessAction() {
  }

//获取未使用的机号
  public void getNotUsedComputeList(){

    Connection con = null;

    try{
      con=ConnectionManager.getConnection();
      Statement s = con.createStatement();
      String strSql =
          "select id from Computer where OnUse =\'0\'; ";
      ResultSet rs = s.executeQuery(strSql);

      while (rs.next()){
        CheckInPanel.computerIdCombox.addItem(rs.getString("id"));
      }
    }catch(SQLException sqlE){
      sqlE.printStackTrace();
    }
  }

  //获取已上机的机号
  public void getUsedComputeList(){
    Connection con = null;

    try{
      con=ConnectionManager.getConnection();
      Statement s = con.createStatement();
      String strSql =
          "select id from Computer where OnUse =\'1\'; ";
      ResultSet rs = s.executeQuery(strSql);

      while (rs.next()){
        CheckOutDialog.computerIdCombox.addItem(rs.getString("id"));
      }
    }catch(SQLException sqlE){
      sqlE.printStackTrace();
    }

  }
}