upcomputerrule.java

一个简单的机房管理系统 可以简单的实现查询,计费 上下机,充值等功能

package src.Rule;

import src.Bean.UpComputerCardBean;
import src.Bean.UpComputerComputerBean;
import src.Bean.UpComputerRecordBean;
import src.Conn.DateBiase;
import java.sql.*;
import java.util.Vector;
import java.util.Date;
import java.text.SimpleDateFormat;

/**
 *  这是上机处理层
 *
 * objVector是可用机器的集合对像,objSetComputerVerctor是设制上机状态为1时的集合对像,
 * objSetCardVerctor是设制用户卡使用中状态为1的集合对像.
 */
public class UpComputerRule {
  DateBiase objDateBiase;
  Vector objVector, objSetComputerVerctor, objSetCardVerctor, objBtimeVector;
  public UpComputerRule() throws Exception {
    objDateBiase = new DateBiase();
    objVector = new Vector();
  }

//找到可使用的机器,即机器上机状态编号为0
  public Vector getCardInfo(UpComputerComputerBean UpComputer) throws
      SQLException {
    objVector = new Vector();
    String selectSQL = "select id from Computer where onuse = 0";
    ResultSet objResultSet = objDateBiase.objStatement.executeQuery(selectSQL);
    while (objResultSet.next()) {
      objVector.addElement(objResultSet.getString(1));
    }
    return objVector;
  }

  //读取系统的上机时间
  public String getBtime() {
    Date upTime = new Date();
    SimpleDateFormat DateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
    String time = DateFormat.format(upTime);
    return time;
  }

//向RECORD表中写入数据!
  //insert into record (cardid,computerid,begintime) values('aaa','1',getdate())
  public void setupintert(UpComputerCardBean setupCard,
                          UpComputerComputerBean setupComputer,
                          UpComputerRecordBean setupRecord) throws
      SQLException {
    String insertSQL =
        "insert into record (cardid,computerid,begintime) values( '" +
        setupCard.getUserName() + "' ,'" + setupComputer.getID() +
        "', getdate())";
    objDateBiase.objStatement.executeUpdate(insertSQL);
  }

  //用户上机后,将上机状态从0改为1
  public void upCometersetOnComputer(UpComputerComputerBean setUpComputer) throws
      SQLException {
    String setUpcomputerComputerSQL =
        "update computer set onuse = 1 where id = '" + setUpComputer.getID() +
        "' ";
    objDateBiase.objStatement.executeUpdate(setUpcomputerComputerSQL);
  }

  //用户上机后,将用户卡状态从0改为1
  public void upCometersetOnCard(UpComputerCardBean setUpComputer_Card) throws
      SQLException {
    String setUpcomputerInfoSQL =
        "update Card set OnUse = 1 where username = '" +
        setUpComputer_Card.getUserName() + "' ";
    objDateBiase.objStatement.executeUpdate(setUpcomputerInfoSQL);
  }

//检查用户上网使用状态
  public boolean upComputerUseCardChick(UpComputerCardBean UpOnUseChickBean) throws
      SQLException {
    //select onuse from card where username  = 'ddd'
    String OnUseSQL = "select onuse from card where onuse =1 and  username = '" +
        UpOnUseChickBean.getUserName() + "' ";
    ResultSet OnUseResult = objDateBiase.objStatement.executeQuery(OnUseSQL);
    if (OnUseResult.next()) {
      return true;
    }
    else {
      return false;
    }
  }

  //检查用户上网余额是否充足
  public boolean upComputerUseBalanceChick(UpComputerCardBean
                                           UpOnBalanceChickBean) throws
      SQLException {
    String onUerBalaceSQL =
        "select balance from card where balance > 2 and username= '" +
        UpOnBalanceChickBean.getUserName() + "' ";
    ResultSet OnUseBlance = objDateBiase.objStatement.executeQuery(
        onUerBalaceSQL);
    if (OnUseBlance.next()) {
      return true;
    }
    else {
      return false;
    }
  }

//验证用户卡号
  public boolean upComputer_CardCheck(UpComputerCardBean UpComputerCard) throws
      SQLException {
    String CardSQL = "select username , password from Card where username = '" +
        UpComputerCard.getUserName() + "' and  password = '" +
        UpComputerCard.getPassword() + "'";
    ResultSet objResultSetCard = objDateBiase.objStatement.executeQuery(CardSQL);
    if (objResultSetCard.next()) {
      return true;
    }
    else {
      return false;
    }
  }
}