dbsourcemanager.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 DBSourceManager {
  //定义变量
  ResultSet rs=null;
  String DBSID;
  String DBSName;
  String DBSDriver;
  String DBSURL;
  String DBUser;
  String DBPin;
  String DBSRemark;
  String sql;
  Vector vDBSID;
  Vector vDBSDriver;
  Vector vDBSName;
  Vector vDBUser;
  Vector vDBSURL;
  Vector vDBPin;
  Vector vDBSRemark;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  //构造函数，初始化变量
  public DBSourceManager() {
    //objDBConnection = new DBConnectionManager();
    db=new DBAccess();
    //objDBConnection=objDBConnection.getInstance() ;
    DBSID="";
    DBSName="";
    DBSDriver="";
    DBSURL="";
    DBUser="";
    DBPin="";
    DBSRemark="";
    sql="";
    vDBSID=new Vector();
    vDBSDriver=new Vector();
    vDBSName=new Vector();
    vDBUser=new Vector();
    vDBSURL=new Vector();
    vDBPin=new Vector();
    vDBSRemark=new Vector();
  }
  public DBSourceManager(String dbsname){
    sql="select * from dbsource where dbsname='"+dbsname+"'";
    //System.out.println("sqlllll="+sql) ;
    try{
        db=new DBAccess();
        objDBConnection = objDBConnection.getInstance() ;
        m_Connection = objDBConnection.getConnection("access") ;
        rs = db.executeQuery(m_Connection,sql) ;
        while(rs.next()){
            DBSID=rs.getString(1);
            DBSName=rs.getString(2);
            DBSDriver=rs.getString(3) ;
            DBSURL=rs.getString(4) ;
            DBUser=rs.getString(5) ;
            DBPin=rs.getString(6) ;
            DBSRemark=rs.getString(7) ;
        }
        rs.close() ;
        objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
        System.out.print(e) ;
    }
  }
  //返回所有数据源记录
  public void getAllSourceRecode(){
    sql="select * from dbsource";
    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)) ;
        vDBSID.addElement(rs.getString(1));
        vDBSName.addElement(rs.getString(2)) ;
        vDBSDriver.addElement(rs.getString(3));
        vDBSURL.addElement(rs.getString(4)) ;
        vDBUser.addElement(rs.getString(5));
        vDBPin.addElement(rs.getString(6));
        vDBSRemark.addElement(rs.getString(7));
      }
      //free connection
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
      //取得所有数据源信息
    public Vector getAllDBSID(){
      return vDBSID;
    }
    public Vector getAllDBSName(){
      return vDBSName;
    }
    public Vector getAllDBSURL(){
      return vDBSURL;

    }
    public Vector getAllDBSDriver(){
      return vDBSDriver;
    }
    public Vector getAllDBUser(){
      return vDBUser;
    }
    public Vector getAllDBPin(){
      return vDBPin;
    }
    public Vector getAllDBSRemark(){
      return vDBSRemark;
    }
    //返回单条记录
    public String getDBSID(){
      return DBSID;
    }
    public String getDBSName(){
      return DBSName;
    }
    public String getDBSURL(){
      return DBSURL;
    }
    public String getDBSDriver(){
      return DBSDriver;
    }
    public String getDBUser(){
      return DBUser;
    }
    public String getDBPin(){
      return DBPin;
    }
    public String getDBSRemark(){
      return DBSRemark;
    }

    //main test
    public static void main(String[] args){
      DBSourceManager dbm = new DBSourceManager("dbmng");
      //System.out.print("dbsid="+dbm.getDBSID()) ;
      //dbm.getAllSourceRecode() ;
      //Vector vDBname = dbm.getAllDBSName() ;
      //System.out.print("size="+vDBname.size() ) ;
      //for(int i=0 ;i<vDBname.size() ;i++){
       // String dbsname=vDBname.elementAt(i).toString() ;
        //System.out.print(dbsname) ;
      //}
      //System.out.print("dddddddddd") ;
    }
}