dbfieldmanager.java

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

package boco.DBManager.Tree;

//******************************************************************************
//:功能:实现从DBField表中取出数据字段信息
//:时间:2002-07
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//
//******************************************************************************

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class DBFieldManager {
  //定义全局变量
  ResultSet rs=null;
  int DBFID;
  int DBTID;
  String DBFName;
  String DBFNameCN;
  String DBFOperator;
  String DBFRemark;
  String sql;
  Vector vDBFID;
  Vector vDBTID;
  Vector vDBFName;
  Vector vDBFNameCN;
  Vector vDBFOperator;
  Vector vDBFRemark;
  Vector vDBFType;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  ChineseTransfer ct = new ChineseTransfer();
  //构造函数，初始化变量
  public DBFieldManager() {
    db=new DBAccess();
    objDBConnection=objDBConnection.getInstance() ;
    DBFID=1;
    DBTID=1;
    DBFName="";
    DBFNameCN="";
    DBFOperator="";
    DBFRemark="";
    sql="";
    vDBFID=new Vector();
    vDBTID=new Vector();
    vDBFName=new Vector();
    vDBFNameCN=new Vector();
    vDBFOperator=new Vector();
    vDBFRemark=new Vector();
    vDBFType=new Vector();
  }
  //返回所有数据源记录
  public void getAllFieldRecode(String DBTID){
    sql="select * from dbfield where dbtid = " + DBTID;
    objDBConnection = objDBConnection.getInstance() ;
    try{
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      while(rs.next()){
        //:test:System.out.print("DbSource=" + rs.getString(2)) ;
        vDBFID.addElement(rs.getString(1));
        vDBTID.addElement(rs.getString(2));
        vDBFName.addElement(rs.getString(3)) ;
        vDBFNameCN.addElement(ct.AsciiToChineseString(rs.getString(4))) ;
        vDBFOperator.addElement(rs.getString(5));
        vDBFRemark.addElement(ct.AsciiToChineseString(rs.getString(6)));
        vDBFType.addElement(rs.getString(7));
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
      //取得所有数据字段信息
    public Vector getAllDBFID(){
      return vDBFID;
    }
    public Vector getAllDBTID(){
      return vDBTID;
    }
    public Vector getAllDBFName(){
      return vDBFName;
    }
    public Vector getAllDBFNameCN(){
      return vDBFNameCN;
    }
    public Vector getAllDBFOperator(){
      return vDBFOperator;
    }
    public Vector getAllDBFRemark(){
      return vDBFRemark;
    }
    public Vector getAllDBFType(){
      return vDBFType;
    }

    //测试主程序
    public static void main(String[] args){
      DBFieldManager dbf = new DBFieldManager();
      dbf.getAllFieldRecode("1") ;
      Vector vDBFname = dbf.getAllDBFName() ;
      System.out.println("size="+vDBFname.size() ) ;
      for(int i=0 ;i<vDBFname.size() ;i++){
        String dbfname=vDBFname.elementAt(i).toString() ;
        System.out.println(dbfname) ;
      }
      //System.out.print("Test OK!") ;
    }
}