overuse.java~12~

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

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 OverUse {
  public OverUse() {
  }

  public String getBeginTime(String ComputerId){
   String BeginTime="";
    try{
      Connection con = ConnectionManager.getConnection();
      String sql = "select BeginTime from Record where ComputerId ='"+ComputerId+"'";
      Statement s =con.createStatement();
      ResultSet rs = s.executeQuery(sql);
      while(rs.next()){
        BeginTime = rs.getDate(1).toString();
      }
    }catch (SQLException ce){
      ce.printStackTrace();
    }
    return BeginTime;
  }

  public void update(String ComputerId,String EndTime,int ree){


    Connection con =ConnectionManager.getConnection();

    try{
      String sql
          = "update Record set EndTime = ?,Fee = ? where ComputerId ='"+ComputerId+"'";
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1,EndTime);
      ps.setInt(2,ree);
      ps.executeUpdate();

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


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

    }
  }
}