areainfo.java

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

package boco.atmmonitor.docmonitor;

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

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class AreaInfo {
  //定义全局变量
  ResultSet rs=null;
  String AreaId;
  String AreaName;
  String AreaMap;
  String AreaDes;
  String sql;
  Vector vAreaId;
  Vector vAreaName;
  Vector vAreaMap;
  Vector vAreaDes;
  Vector vAreaPower;
  Vector vJudge;
  int judge;
  DBConnectionManager objDBConnection;
  Connection m_Connection;
  DBAccess db;
  ChineseTransfer A2C;
  //构造函数，初始化变量
  public AreaInfo() {
    objDBConnection=objDBConnection.getInstance() ;
    AreaId = "";
    AreaName = "";
    AreaMap = "";
    AreaDes = "";
    sql="";
    judge=0;
    vAreaId=new Vector();
    vAreaName=new Vector();
    vAreaMap=new Vector();
    vAreaDes=new Vector();
    vAreaPower=new Vector();
    A2C = new ChineseTransfer();
  }
  //返回所有分区信息,并由权限值判数返回内容
  public void getAllArea(String thePower){
    sql="select * from areainfo order by areaid";
    db =new DBAccess();
    try{
      objDBConnection = objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      while(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")){
          vAreaId.addElement(rs.getString(1));
          vAreaName.addElement(A2C.AsciiToChineseString(rs.getString(2)));
          vAreaMap.addElement(rs.getString(3));
          vAreaDes.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()) ;
    }
  }
  //返回分区ID
  public Vector getAllAreaId(){
    return vAreaId;
  }
  //返回分区名称
  public Vector getAllAreaName(){
    return vAreaName;
  }
  //返回分区地图名
  public Vector getAllAreaMap(){
    return vAreaMap;
  }
  //返回分区描述
  public Vector getAllAreaDes(){
    return vAreaDes;
  }
  public Vector getAllAreaPower(){
    return vAreaPower;
  }
  //测试主程序
  public static void main(String[] args){
    AreaInfo ai = new AreaInfo();
    ai.getAllArea("1111111111111111111");
    Vector vArName = ai.getAllAreaPower();
    System.out.println(vArName.toString());
  }
}