tradecode.java

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

package boco.transmonitor.tranmonitor;

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

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class TradeCode {
  //定义全局变量
  ResultSet rs=null;
  String TradeCode;
  String TradeName;
  String TradeDes;
  String sql;
  Vector vTradeCode;
  Vector vTradeName;
  Vector vTradeDes;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  //构造函数，初始化变量
  public TradeCode() {
    db=new DBAccess();
    objDBConnection=objDBConnection.getInstance() ;
    TradeCode="";
    TradeName="";
    TradeDes="";
    sql="";
    vTradeCode=new Vector();
    vTradeName=new Vector();
    vTradeDes=new Vector();
  }
  //返回所有数据源记录
  public void getAllTrade(){
    sql="select * from tradecode order by tradecode";
    objDBConnection = objDBConnection.getInstance() ;
    try{
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      while(rs.next()){
        //:test:System.out.print("TradeName=" + rs.getString(2)) ;
        vTradeCode.addElement(rs.getString(1));
        vTradeName.addElement(rs.getString(2));
        vTradeDes.addElement(rs.getString(3)) ;
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
      //取得所有数据字段信息
    public Vector getAllTradeCode(){
      return vTradeCode;
    }
    public Vector getAllTradeName(){
      return vTradeName;
    }
    public Vector getAllTradeDes(){
      return vTradeDes;
    }
    //测试主程序
    public static void main(String[] args){
      TradeCode dbf = new TradeCode();
      dbf.getAllTrade() ;
      Vector vTrdName = dbf.getAllTradeName() ;
      System.out.println("size="+vTrdName.size() ) ;
      for(int i=0 ;i<vTrdName.size() ;i++){
        String dbfname=vTrdName.elementAt(i).toString() ;
        System.out.println(dbfname) ;
      }
      //System.out.print("Test OK!") ;
    }
}