getdbtkey.java

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

package boco.shabank.dbmanager;

/**
 * <p>Title: dbmanager</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: boco</p>
 * @author xugs
 * @version 1.0
 */
import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class getDBTKey {
  //定义变量
  String Key="";
  ResultSet rs=null;
  String sql;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  //构造函数，初始化变量
  public getDBTKey() {
    //objDBConnection = new DBConnectionManager();
    db=new DBAccess();
    sql="";
  }
  //返回所有数据源记录
  public void getKey(String DBTName){
    sql="select * from dbtable where dbtname='" + DBTName + "'";
    //System.out.println(sql);
    objDBConnection = objDBConnection.getInstance() ;
    try{
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      if(rs.next()){
        Key=rs.getString(6);
       }
      if(Key==null){
        Key="noKey";
      }
      //free connection
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
      //取得数据表键值
    public String getKey(){
      return Key;
    }
    public int getKeyAt(){
      return 1;
    }
    //main test
    public static void main(String[] args){
      getDBTKey dbtk = new getDBTKey();
      String vTName="dbsource";
      dbtk.getKey(vTName);
      String Key=dbtk.getKey();
      System.out.println("Key="+Key) ;
      }
}