startuse.java~27~

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

package com.jbaptech.accp.netbar.client;

import java.sql.*;


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

 /* public int getId(String UserName){
    Connection con = ConnectionManager.getConnection();
    int id=0;
    try{
      String sql = "select id from Card where UserName ='"+UserName+"'";
      Statement s = con.createStatement();
      ResultSet rs = s.executeQuery(sql);
      id = rs.getInt(1);

    }catch (SQLException ce){
      System.out.println(ce);
    }
  return id;
  }*/

//向Record表插入上机记录
  public void doStartUseComputerBusiness(int Id,String CardId,String ComputerId,String BeginTime){

    Connection con = ConnectionManager.getConnection();
    try{
      String sql1
          = "insert into Record(Id,CardId,ComputerId,BeginTime) values(?,?,?,?)";
      PreparedStatement ps = con.prepareStatement(sql1);
      ps.setInt(1,Id);
      ps.setString(2,CardId);
      ps.setString(3,ComputerId);
      ps.setString(4,BeginTime);
      ps.executeUpdate();

      String sql2 =
          "update computer set OnUse =1 where id ='"+ComputerId+"'";
      Statement s = con.createStatement();
      s.executeUpdate(sql2);

    }catch (SQLException sqlE) {
      sqlE.printStackTrace();
    }finally{
      try{
        con.close();
      }catch (SQLException e) {
        e.printStackTrace();
      }
    }

  }          //finally

}