finalresult.java

一个java+sql2000开发的网吧管理系统

package com.jbaptech.accp.netbar.client;

import java.sql.*;


//此类用于显示下机结果界面上的信息
public class FinalResult {
  String cardId ;                 //卡号
  String computerId ;             //机器号
  String beginTime ;              //上机时间
  String endTime ;                //下机时间
  int fee ;                       //本次消费
  int balance ;                   //此卡余额

  public FinalResult() {
  }

  public void select(String ComputerId){

    Connection con = ConnectionManager.getConnection();

    try{
      String sql1 = "select * from Record where ComputerId = '"+ComputerId+"'";
      Statement s = con.createStatement();
      ResultSet rs = s.executeQuery(sql1);
      while(rs.next()){
        cardId = rs.getString("cardId");
        computerId = rs.getString(3);
        beginTime = rs.getString(4);
        endTime = rs.getString(5);
        fee = rs.getInt(6);
      }

      CheckOutResultPanel.computerIdLabel.setText(computerId);
      CheckOutResultPanel.cardIdLabel.setText(cardId);
      CheckOutResultPanel.beginTimeLabel.setText(beginTime);
      CheckOutResultPanel.endTimeLabel.setText(endTime);
      CheckOutResultPanel.consumerFeeLabel.setText(Integer.toString(fee));

      OverUse overuse = new OverUse();
      overuse.update(cardId,fee);
      String sql2 = "select * from Card where Id ='"+cardId+"'";
      Statement s2 = con.createStatement();
      ResultSet rs2 = s2.executeQuery(sql2);
      while(rs2.next()){
        balance = rs2.getInt("balance");
      }

      CheckOutResultPanel.balanceLabel.setText(Integer.toString(balance));

      con.close();
    }catch (SQLException ce){
      ce.printStackTrace();
    }
  }
}