allinfo.java

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

            tmp=rs.getString(i);
            if(tmp.equals("01"))
              tmp = "逻辑开机";
            else if(tmp.equals("02"))
              tmp = "逻辑关机";
            else{}
            vDevInfo.addElement(tmp);
            vStatu.addElement("") ;
          }
          else{
            vDevInfo.addElement(rs.getString(i));
            vStatu.addElement("") ;
          }
        }
      }
      rs.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage());
    }
  }
  //取得ATM的硬件信息
  public void getHardInfo(String devno){
    try{
      String sql="select  * from DevHardInfo where devno ='"+devno+"'";
      ResultSet rs=stmt.executeQuery(sql);
      String tmp="";
      while(rs.next()) {
        //:test:System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5)+rs.getString(6)+rs.getString(7)+rs.getString(8)+rs.getString(9)+rs.getString(10)+"p"+rs.getString(11));
        //for(int i= 1;i<14;i++)
        //   vHardInfo.addElement(rs.getString(i));
        for(int i= 1;i<14;i++){
          if(i==10){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "R1,2,3/W3";
            else if(tmp.equals("2"))
              tmp = "Dip Carder";
            else if(tmp.equals("3"))
              tmp = "Smart Card";
            else if(tmp.equals("4"))
              tmp = "Swipe Card";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==2||i==3||i==4){
            tmp=rs.getString(i);
            if(tmp.equals("0"))
              tmp = "普通纸";
            else if(tmp.equals("1"))
              tmp = "热敏纸";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==5){
            tmp=rs.getString(i);
            if(tmp.equals("0"))
              tmp = "单张";
            else if(tmp.equals("1"))
              tmp = "多张";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==6){
            tmp=rs.getString(i);
            if(tmp.equals("0"))
              tmp = "两通道吐钞机";
            else if(tmp.equals("1"))
              tmp = "四通道吐钞机";
            else if(tmp.equals("2"))
              tmp = "八通道吐钞机";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==7){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "9寸";
            else if(tmp.equals("2"))
              tmp = "15寸";
            else if(tmp.equals("3"))
              tmp = "15寸触摸屏";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==8){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "STP";
            else if(tmp.equals("2"))
              tmp = "ATP";
            else if(tmp.equals("3"))
              tmp = "BTP";
            else if(tmp.equals("4"))
              tmp = "CTP";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==11){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "已经安装";
            else if(tmp.equals("0"))
              tmp = "未安装";
            else{}
            vHardInfo.addElement(tmp);
          }
          else if(i==12){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "穿墙";
            else if(tmp.equals("2"))
              tmp = "大堂";
            else{}
            vHardInfo.addElement(tmp);

          }
          else if(i==13){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "离行";
            else if(tmp.equals("0"))
              tmp = "非离行";
            else{}
            vHardInfo.addElement(tmp);
          }
          else{
            vHardInfo.addElement(rs.getString(i));
          }
        }
      }
      rs.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage());
    }
  }
  //取得ATM的软件信息
  public void getSoftInfo(String devno){
    try{
      String sql="select  * from DevSoftInfo where devno ='"+devno+"'";
      ResultSet rs=stmt.executeQuery(sql);
      while(rs.next()) {
        //:test:System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5)+rs.getString(6)+rs.getString(7)+rs.getString(8)+rs.getString(9)+rs.getString(10)+"p"+rs.getString(11));
        for(int i= 1;i<5;i++)
          vSoftInfo.addElement(rs.getString(i));
      }
      rs.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage());
    }
  }
  //取得ATM的通讯信息
  public void getComInfo(String devno){
    try{
      String sql="select  * from DevComInfo where devno ='"+devno+"'";
      ResultSet rs=stmt.executeQuery(sql);
      String tmp="";
      while(rs.next()) {
        //:test:System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5)+rs.getString(6)+rs.getString(7)+rs.getString(8)+rs.getString(9)+rs.getString(10)+"p"+rs.getString(11));
        //for(int i= 1;i<10;i++)
        // vComInfo.addElement(rs.getString(i));
        for(int i= 1;i<10;i++){
          if(i==2){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "SNA";
            else if(tmp.equals("2"))
              tmp = "TCP/IP";
            else if(tmp.equals("3"))
              tmp = "X.25";
            else if(tmp.equals("4"))
              tmp = "RS232";
            else{}
            vComInfo.addElement(tmp);
          }
          else if(i==3){
            tmp=rs.getString(i);
            if(tmp.equals("1"))
              tmp = "DDN";
            else if(tmp.equals("2"))
              tmp = "拨号";
            else if(tmp.equals("3"))
              tmp = "直连";
            else{}
            vComInfo.addElement(tmp);
          }
          else {
            vComInfo.addElement(rs.getString(i));
          }
        }
      }
      rs.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage());
    }
  }
  //取得ATM的其它信息
  public void getOthInfo(String devno){
    try{
      String sql="select * from DevOthInfo where devno ='"+devno+"'";
      ResultSet rs=stmt.executeQuery(sql);
      while(rs.next()) {
        //:test:System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5)+rs.getString(6)+rs.getString(7)+rs.getString(8)+rs.getString(9)+rs.getString(10)+"p"+rs.getString(11));
        for(int i= 1;i<11;i++)
          vOthInfo.addElement(rs.getString(i));
      }
      rs.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage());
    }
  }
  //关闭连接
  public void closecon(){
    try{
      stmt.close();
      conn.close();
    }catch(Exception ex){
      System.out.print(ex.getMessage()) ;
    }
  }
  //返回基本信息
  public Vector getvDevInfo(){
    return vDevInfo;
  }
  //返加硬件信息
  public Vector getvHardInfo(){
    return vHardInfo;
  }
  //返回软件信息
  public Vector getvSoftInfo(){
    return vSoftInfo;
  }
  //返回通讯信息
  public Vector getvComInfo(){
    return vComInfo;
  }
  //返回其它信息
  public Vector getvOthInfo(){
    return vOthInfo;
  }
  public Vector getStatus(){
    return vStatu;
  }
  //测试主程序
  public static void main(String [] args){
    AllInfo di = new AllInfo();
    Vector vv = new Vector();
    di.getDevInfo("0300Y002");
    vv = di.getvHardInfo();
    System.out.println("The size:"+vv.size());
    for(int i =0;i<vv.size();i++){
      System.out.println(vv.elementAt(i)+"|"+i);
    }
  }
}