startuse.java

来自「一个java+sql2000开发的网吧管理系统」· Java 代码 · 共 46 行

package com.jbaptech.accp.netbar.client;

import java.sql.*;


public class StartUse {
  public StartUse() {
  }

  //上机界面CheckInPanel按下确定时调用此方法
  public void doStartUseComputerBusiness(String CardId,String ComputerId,String BeginTime){

    Connection con = ConnectionManager.getConnection();
    try{

      //向Record表插入上机记录

      String sql1
          = "insert into Record(CardId,ComputerId,BeginTime) values(?,?,?)";
      PreparedStatement ps = con.prepareStatement(sql1);
      ps.setString(1,CardId);
      ps.setString(2,ComputerId);
      ps.setString(3,BeginTime);
      ps.executeUpdate();

      //修改Computer表中上机的机器使用状态为1

      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

}