atmexist.java

农业银行ATM对帐查询系统后台类包的源代码,实现了FTP,数据库管理等等功能

package boco.atmmonitor.docmonitor;

//******************************************************************************
//:功能:实现从atmstatus表中取出设备状态值
//:时间:2002-08
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//
//******************************************************************************

import java.util.*;
import java.sql.*;
public class AtmExist {
  //定义全局变量
  ResultSet rs=null;
  String AtmId;
  Vector AtmStatus;
  String sql;
  String driver;
  String url;
  String name;
  String passwd;
  Connection conn;
  Statement stmt;
  //构造函数，初始化变量
  public AtmExist(String dbDriver,String ConnStr,String UserName,String Pass) {
    driver = dbDriver;
    url = ConnStr;
    name = UserName;
    passwd = Pass;
    conn = null;
    stmt = null;
    AtmId = "";
    AtmStatus = new Vector();
    sql="";
  }
  public boolean isAtmExist(String atmid){
    boolean isThere=false;
    sql="select DevNo from DevBaseInfo where DevNo =" + "'" + atmid + "'";
    //:test:System.out.println("The exist sql:"+sql);
    try{
      Class.forName(driver).newInstance() ;
      Properties SysProps = System.getProperties();
      SysProps.put("user",name);
      SysProps.put("password",passwd);
      conn= DriverManager.getConnection(url, SysProps);
      stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
      ResultSet rs=stmt.executeQuery(sql);
      if(rs.next()){
        isThere=true;
      }
      //断开连接,释放资源
      rs.close() ;
      //断开连接,释放资源
      try{
        stmt.close();
        conn.close();
      }catch(Exception ex){
        System.out.print(ex.getMessage()) ;
      }
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
    return isThere;
    //:test:return true;
  }
  //测试主程序
  public static void main(String[] args){
  }
}