getpower.java

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

package boco.atmmonitor.docmonitor;

//******************************************************************************
//:功能:取得权限值
//:时间:2002-08
//:作者:王建宾
//:特殊描述::test:为DEBUG时启用
//:程序描述:
//
//******************************************************************************
import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class getPower {
  String sql = "";
  DBAccess db = null;
  DBConnectionManager objDBConnection = null;
  Connection m_Connection=null;
  ResultSet rs = null;
  ChineseTransfer ct = null;
  public getPower() {
  }
  public String getUserPower(String usrsign){
    sql="select grpid from poweruser where usrsign='"+usrsign+"'";
    String grpid="";
    String strPower="";
    try{
      db=new DBAccess();
      objDBConnection=objDBConnection.getInstance() ;
      m_Connection = objDBConnection.getConnection("access") ;
      rs = db.executeQuery(m_Connection,sql) ;
      ct = new ChineseTransfer();
      if(rs.next()){
        grpid=rs.getString(1);
      }
      Object[] arrGrpId = ct.toArray(grpid,"@");//用户组id数组
      //Object[][] arrTempPower;
      Vector vTempPower=new Vector();
      for(int i=0;i<200;i++)
        vTempPower.addElement("0") ;//初始化向量
      for(int i=0;i<arrGrpId.length ;i++){
        Object[] tmpPower = getGroupPowerforGrpid(arrGrpId[i].toString());//组权限数组
        for(int j=0;j<tmpPower.length ;j++){
          //多组权限的并集
          int iPower1 = Integer.parseInt(vTempPower.elementAt(j).toString());
          int iPower2 = Integer.parseInt(tmpPower[j].toString());
          if(iPower2>iPower1){
            vTempPower.setElementAt(Integer.toString(iPower2),j); ;
          }
        }
      }
      for(int i=0;i<vTempPower.size();i++){
        strPower = strPower+vTempPower.elementAt(i).toString() ;
      }
      //test:System.out.println("length1="+strPower) ;
      objDBConnection.freeConnection("access",m_Connection) ;
    }
    catch(Exception e){
    }
    return strPower;
  }
  //根据用户组ID取用户组权限编码
    public Object[] getGroupPowerforGrpid(String grpid){
        sql="select grppower from powergroup where grpid="+grpid;
        String grouppower = "";
        try{
            db=new DBAccess();
            objDBConnection=objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = db.executeQuery(m_Connection,sql) ;
            if(rs.next())
                grouppower = rs.getString(1);
            rs.close() ;
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
             System.out.println(e.getMessage()) ;
        }
        Vector vPower=new Vector();
        for(int i=0;i<grouppower.length();i++){
            vPower.addElement(grouppower.substring(i,i+1));
        }
        return vPower.toArray();
    }
  public static void main(String[] args){
          getPower pw = new getPower();
          System.out.println("PowerClass:"+pw.getUserPower("0002"));
    }
}