powermanager.java~1~

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

package boco.PowerManager;
import java.util.*;
import java.sql.*;
import boco.DBManager.Tree.*;
public class PowerManager {
    //用户组向量
    protected Vector vGrpId;
    protected Vector vGrpName;
    protected Vector vGrpPower;
    protected Vector vGrpDes;
    //用户向量
    protected Vector vUsrId;
    protected Vector vUsrName;
    protected Vector vUsrPin;
    protected Vector vUsrMail;
    protected Vector vUsrPhone;
    protected Vector vUsrAddress;
    protected Vector vUsrDes;
    protected Vector vUsrGrpId;
    //权限块向量
    protected Vector vPowerId;
    protected Vector vPowerPath;
    protected Vector vPowerName;
    protected Vector vPowerDes;
    protected String sql="";
    DBConnectionManager objDBConnection;
    Connection m_Connection;
    ResultSet rs=null;
    DBAccess db; 
    public PowerManager() {
        //初始化用户组向量
       vGrpId=new Vector();
       vGrpName=new Vector();
       vGrpPower=new Vector();
       vGrpDes=new Vector();
       //初始化用户向量
       vUsrId=new Vector();
       vUsrName=new Vector();
       vUsrPin=new Vector();
       vUsrMail=new Vector();
       vUsrPhone=new Vector();
       vUsrAddress=new Vector();
       vUsrDes=new Vector();
       vUsrGrpId=new Vector();
       //初始化权限块向量
       vPowerId=new Vector();
       vPowerPath=new Vector();
       vPowerName=new Vector();
       vPowerDes=new Vector();
       vPowerId=new Vector();
       //数据连接
       //objDBConnection.getInstance();
       //db=new DBAccess();       
    }
    //用户属性向量付值
    public void getAllPowerUser(){
	sql="select * from poweruser";
        db=new DBAccess();
        try{
	    objDBConnection=objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = db.executeQuery(m_Connection,sql) ;
            //:test:System.out.println(sql);
            while(rs.next()){
		vUsrId.addElement(rs.getString(1)) ;
                vUsrName.addElement(rs.getString(2));
                vUsrPin.addElement(rs.getString(3));
                vUsrMail.addElement(rs.getString(4));
                vUsrPhone.addElement(rs.getString(5));
                vUsrAddress.addElement(rs.getString(6));
                vUsrDes.addElement(rs.getString(7));
                vUsrGrpId.addElement(rs.getString(8));
            }
	    rs.close() ;
	    objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
	    System.out.print(e.getMessage()) ;
        }
    }
    //用户组属性向量付值
    public void getAllPowerGroup(){
	sql="select * from powergroup";
        db=new DBAccess();
        try{
	    objDBConnection=objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = db.executeQuery(m_Connection,sql) ;
            //:test:System.out.println(sql);
            while(rs.next()){
		vGrpId.addElement(rs.getString(1)) ;
                vGrpName.addElement(rs.getString(2));
                vGrpPower.addElement(rs.getString(3));
                vGrpDes.addElement(rs.getString(4));
            }
	    rs.close() ;
	    objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
	    System.out.print(e.getMessage()) ;
        }
    }
    //权限模块属性向量付值
    public void getAllPowerMod(){
	sql="select * from powermod";
        db=new DBAccess();
        try{
	    objDBConnection=objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = db.executeQuery(m_Connection,sql) ;
            //:test:System.out.println(sql);
            while(rs.next()){
		vPowerId.addElement(rs.getString(1)) ;
                vPowerPath.addElement(rs.getString(2));
                vPowerName.addElement(rs.getString(3));
                vPowerDes.addElement(rs.getString(4));
            }
	    rs.close() ;
	    objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
	    System.out.print(e.getMessage()) ;
        }
    }
    /**************************************************************
    取用户属性 
    ***************************************************************/
    public Vector vGetUsrId(){
	return vUsrId;
    }
    public Vector vGetUsrName(){
	return vUsrName;
    }
    public Vector vGetUsrPin(){
	return vUsrPin;
    }
    public Vector vGetUsrMail(){
	return vUsrMail;
    }
    public Vector vGetUsrPhone(){
	return vUsrPhone;
    }
    public Vector vGetUsrAddress(){
	return vUsrAddress;
    }
    public Vector vGetUsrDes(){
	return vUsrDes;
    }
    public Vector vGetUsrGrpId(){
	return vUsrGrpId;
    }
    //取用户属性结束*************************************************** 
    /****************************************************************
     *取用户组信息 
    *****************************************************************/
    public Vector vGetGrpId(){
	return vGrpId;        
    }
    public Vector vGetGrpName(){
	return vGrpName;        
    }
    public Vector vGetGrpPower(){
	return vGrpPower;        
    }
    public Vector vGetGrpDes(){
	return vGrpDes;        
    }
    //取用户组属性结束***************************************************
    /**************************************************************
    *取权限块属性
    ***************************************************************/
   public Vector vGetPowerId(){
       return vPowerId; 
   }
   public Vector vGetPowerPath(){
       return vPowerPath; 
   }
   public Vector vGetPowerName(){
       return vPowerName; 
   }
   public Vector vGetPowerDes(){
       return vPowerDes; 
   }
}