branchcodeinfo.java

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

package boco.atmmonitor.docmonitor;


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

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class BranchCodeInfo {
  //定义全局变量
  ResultSet rs=null;
  String BranchCode;
  String BranchName;
  String BranchPin;
  String BranchDes;
  String sql;
  Vector vBranchCode;
  Vector vBranchName;
  Vector vBranchPin;
  Vector vBranchDes;
  //Vector vAreaPower;
  //Vector vJudge;
  //int judge;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  ChineseTransfer A2C;
  //构造函数，初始化变量
  public BranchCodeInfo() {
    //objDBConnection=objDBConnection.getInstance() ;
    BranchCode = "";
    BranchName = "";
    BranchPin = "";
    BranchDes = "";
    sql="";
    //judge=0;
    vBranchCode=new Vector();
    vBranchName=new Vector();
    vBranchPin=new Vector();
    vBranchDes=new Vector();
    //vAreaPower=new Vector();
    A2C = new ChineseTransfer();
    sql="select * from branchcodepin order by branchname";
    db =new DBAccess();
    try{
      objDBConnection = objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      while(rs.next()){
        vBranchCode.addElement(rs.getString(1));
        vBranchName.addElement(A2C.AsciiToChineseString(rs.getString(2)));
        vBranchDes.addElement(rs.getString(4));
        //vAreaPower.addElement(thePower.substring(judge,judge+1));
        //}
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
  //返回所有分区信息,并由权限值判数返回内容
  public void BranchCodeInfo(String branchofcode){
    //if(branchofcode.equals("95599")){
    sql="select * from branchcodepin where branchcode='"+branchofcode+"'";
    //System.out.println(sql) ;
    db =new DBAccess();
    try{
      objDBConnection = objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      if(rs.next()){
        //:test:System.out.print("AreaName=" + rs.getString(2)) ;
        //判断对应权限位是否是1
        //judge=Integer.parseInt(rs.getString(5).trim());
        //:test:System.out.println("The judge:"+judge);
        //:test:System.out.println("The Power value:"+thePower.substring(judge-1,judge));
        //if(!thePower.substring(judge,judge+1).equals("0")){
        BranchCode = rs.getString(1);
        BranchName = A2C.AsciiToChineseString(rs.getString(2));
        BranchPin = rs.getString(3);
        BranchDes = rs.getString(4);
        //vAreaPower.addElement(thePower.substring(judge,judge+1));
        //}
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }
  public int getAreaId(String branchofcode){
    int areaid=0;
    sql="select areaid from areainfo where powersite='"+branchofcode+"'";
    db =new DBAccess();
    try{
      objDBConnection = objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      if(rs.next()){
        areaid = rs.getInt(1);
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
    return areaid;
  }
  public void getBranchUnitInfo(String branchofcode){
    //if(branchofcode.equals("95599")){
    sql="select * from branchcodepin where branchcode like '"+branchofcode+"%' ande branchcode <> '"+branchofcode+"' order by branchname";
    db =new DBAccess();
    try{
      objDBConnection = objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      while(rs.next()){
        vBranchCode.addElement(rs.getString(1));
        vBranchName.addElement(A2C.AsciiToChineseString(rs.getString(2)));
        vBranchDes.addElement(rs.getString(4));
        //vAreaPower.addElement(thePower.substring(judge,judge+1));
        //}
      }
      //断开连接,释放资源
      rs.close() ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
      System.out.print("errorMsg=" + e.getMessage()) ;
    }
  }

  public String getBranchCode(){
    return BranchCode;
  }
  public String getBranchName(){
    return BranchName;
  }
  public String getBranchDes(){
    return BranchDes;
  }

  public Vector getAllBranchCode(){
    return vBranchCode;
  }
  //返回分区名称
  public Vector getAllBranchName(){
    return vBranchName;
  }
  //返回分区地图名
  public Vector getAllBranchPin(){
    return vBranchPin;
  }
  public Vector getAllBranchDes(){
    return vBranchDes;
  }
  /*
  //返回分区描述
  public Vector getAllAreaDes(){
    return vAreaDes;
  }
  public Vector getAllAreaPower(){
    return vAreaPower;
  }*/
  //测试主程序
  public static void main(String[] args){
    BranchCodeInfo ai = new BranchCodeInfo();
    //ai.getAllArea("1111111111111111111");
    //Vector vArName = ai.getAllAreaPower();
    ai.BranchCodeInfo("32") ;
    System.out.print(ai.getBranchName()) ;
    //System.out.println(vArName.toString());
  }
}