atmsetting.java

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

package boco.javabean.atmsettle;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
import java.util.*;
import java.sql.*;
import com.sybase.jdbc2.jdbc.SybDriver;
import java.io.*;

public class atmsetting {
    //定义变量
    String url;
    Connection conn;
    Statement stmt;
    Vector vBand    = new Vector();
    Vector vType    = new Vector();
    Vector vDevNo   = new Vector();
    Vector vAppSoft = new Vector();
    String sBand  = "";
    String sType  = "";
    String sFlag  = "";
    String sRes   = "";
    String sAtm   = "";
    public atmsetting() {
		//修改后程序（从属性文件当中读取连接数据库信息）
	InputStream is=getClass().getResourceAsStream("/db.properties") ;
        Properties dbProps = new Properties();
        try{
	    dbProps.load(is) ;
        }
        catch(Exception e){
	    System.err.println("不能读取属性文件") ;
        }
	String urlXml=dbProps.getProperty("atm.monitor") ;
        url=dbProps.getProperty("aibsconn.url") ;
	String drivers=dbProps.getProperty("aibsconn.drivers") ;
	String user = dbProps.getProperty("aibsconn.user") ;
	String password = dbProps.getProperty("aibsconn.password") ;
	try{

            Class.forName(drivers).newInstance() ;
            Properties SysProps = System.getProperties();
            SysProps.put("user",user);
            SysProps.put("password",password);
            conn= DriverManager.getConnection(url, SysProps);
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        }
	/*原程序
        url =" jdbc:sybase:Tds:196.168.1.32:9999/apdb";
        try{
            Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance() ;
            Properties SysProps = System.getProperties();
            SysProps.put("user","apdbo");
            SysProps.put("password","apdbop");
            conn= DriverManager.getConnection(url, SysProps);
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        }*/
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void band(){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select distinct DevLogo from DevBaseInfo ";
            //System.out.println(sql);
            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));
                vBand.addElement(rs.getString(1));
            }
          //rs.close();

        }
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void appsoft(){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select distinct appsoft from DevSoftInfo ";
            //System.out.println(sql);
            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));
                vAppSoft.addElement(rs.getString(1));
            }
          //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 void type(String band){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  distinct DevType from DevBaseInfo where DevLogo ='"+band+"'";
            //System.out.println(sql);
            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));
                vType.addElement(rs.getString(1));
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void devno(String band,String type){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DevNo from DevBaseInfo where DevLogo ='"+band+"' and DevType = '"+type+"'";
            //System.out.println(sql);
            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));
                vDevNo.addElement(rs.getString(1));
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void branch(String branch){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DevLogo,DevType,DevNo from DevBaseInfo where Branch ='"+branch+"'";
            //System.out.println(sql);
            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));
                vBand.addElement(rs.getString(1));
                vType.addElement(rs.getString(2));
                vDevNo.addElement(rs.getString(3));
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void getappsoft(String appsoft){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  devno from DevSoftInfo where appsoft ='"+appsoft+"'";
            //System.out.println(sql);
            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));
                vDevNo.addElement(rs.getString(1));
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage()) ;
        }
    }
    public void bandtype(String DevNo){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DevLogo,DevType from DevBaseInfo where DevNo='"+DevNo+"'";
            //System.out.println(sql);
            ResultSet rs=stmt.executeQuery(sql);
            if(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));
                sBand  = rs.getString(1);
                sType  = rs.getString(2);
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage());
        }
    }
    public void bandandtype(String starthere,String endhere){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DevLogo,DevType,DevNo from DevBaseInfo where DevNo >='"+starthere+"' and DevNo <= '"+endhere+"'";
            //System.out.println(sql);
            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));
                vBand.addElement(rs.getString(1));
                vType.addElement(rs.getString(2));
                vDevNo.addElement(rs.getString(3));
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage());
        }
    }
    public String result1(String devno){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DownProgRes from DevBaseInfo where DevNo ='"+devno+"'";
            //System.out.println(sql);
            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));
                sRes = rs.getString(1);
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage());
        }
        return sRes;
    }
    public String result2(String devno){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  AtmCommand from DevBaseInfo where DevNo ='"+devno+"'";
            //System.out.println(sql);
            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));
                sAtm = rs.getString(1);
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage());
        }
        return sAtm;
    }
    public String result3(String devno){
        try{
            //"select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
            String sql="select  DownProgFlag from DevBaseInfo where DevNo ='"+devno+"'";
            //System.out.println(sql);
            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));
                sFlag = rs.getString(1);
            }
            //rs.close();
        }
        catch(Exception ex){
            System.out.print(ex.getMessage());
        }
        return sFlag;
    }
    public boolean update1(String devno,String flag){
      String sql = "UPDATE  DevBaseInfo SET DownProgFlag = '"+flag+"' WHERE DevNo = '"+devno+"'";
      //System.out.println(sql);
      try{
            int i =stmt.executeUpdate(sql);
            if(i < 0){
                System.out.println("设置标志不成功" + i);
                return false;
            }
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
            return false;
        }
        return true;
    }
    public boolean update2(String devno,String command){
      String sql = "UPDATE  DevBaseInfo SET AtmCommand = '"+command+"' WHERE DevNo = '"+devno+"'";
      //System.out.println(sql);
      try{
            int i =stmt.executeUpdate(sql);
            if(i < 0){
                System.out.println("设置命令不成功" + i);
                return false;
            }
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
            return false;
        }
        return true;
    }
    public Vector getBand(){
        return vBand;
    }
    public Vector getType(){
        return vType;
    }
    public Vector getDevNo(){
        return vDevNo;
    }
    public String getsBand(){
        return sBand;
    }
    public String getsType(){
        return sType;
    }
    public String getRes(){
        return sRes;
    }
    public String getAtm(){
        return sAtm;
    }
    public String getFlag(){
        return sFlag;
    }
    public Vector getAppSoft(){
        return vAppSoft;
    }
    public static void main(String [] args){
        /*atmsetting atm = new atmsetting();
        Vector vBand = new Vector();
        Vector vType = new Vector();
        String sBand ="";
        String sType="";
        atm.bandtype("0300Y006");
        sBand = atm.getsBand();
        System.out.println(sBand);
        sType = atm.getsType();
        System.out.println(sType);*/
        /*for(int i = 0;i < vBand.size();i++){
          System.out.println("品牌"+vBand.elementAt(i).toString());
          atm.type(vBand.elementAt(i).toString());
          vType = atm.getType();
          for(int j = 0;j < vType.size();j++)
          System.out.println("类型"+vType.elementAt(j).toString());
        }*/
          //atm.closecon();
    }
}