loginbean.java

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

package boco.javabean.atmsettle;

import java.util.*;
import java.sql.*;
import boco.shabank.dbconnection.*;
public class loginBean {
    //定义变量
    ResultSet rs=null;
    DBConnectionManager objDBConnection;
    Connection m_Connection;
    DBAccess dba;
    String sql;
    boolean check;
    boolean bLogin;
    Vector vv = new Vector();
    //构造函数，初始化变量
    public loginBean(){
        dba  = new DBAccess();
        sql = "";
        check = false;
        bLogin= false;
    }
    public boolean checkin(String atmid,String oprpin){
        sql = "select * from atmsettle where reqid='"+atmid+"'and pin='"+oprpin+"'";
        try{
            dba=new DBAccess();
            objDBConnection = objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = dba.executeQuery(m_Connection,sql) ;
            while(rs.next()){
                check=true;
            }

            rs.close() ;
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
        }
        return check;
    }
    public boolean bLogin(String branch,String branchpin){
        sql = "select * from branchcodepin where branchcode='"+branch+"'and branchpin='"+branchpin+"'";
        System.out.println(sql);
        try{
            dba=new DBAccess();
            objDBConnection = objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = dba.executeQuery(m_Connection,sql) ;
            while(rs.next()){
                bLogin=true;
            }

            rs.close() ;
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
        }
        return bLogin;
    }
    public boolean changepin(String atmid,String pass){
        sql = "UPDATE  atmsettle SET pin = '"+pass+"' WHERE reqid = '"+atmid+"'";
        System.out.println(sql);
        try{
            dba=new DBAccess();
            objDBConnection = objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            int i = dba.executeUpdate(m_Connection,sql) ;
            if(i < 0){
                System.out.println("改密不成功" + i);

                return false;
            }
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
        }
        return true;
    }
    public boolean chgpin(String branch,String pass){
        sql = "UPDATE  branchcodepin SET branchpin = '"+pass+"' WHERE branchcode = '"+branch+"'";
        //System.out.println(sql);
        try{
            dba=new DBAccess();
            objDBConnection = objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            int i = dba.executeUpdate(m_Connection,sql) ;
            if(i < 0){
                System.out.println("改密不成功" + i);
                return false;
            }
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
        }
        return true;
    }
    public static void main(String[] args){
        loginBean loginbean = new loginBean();
        //System.out.println(loginbean.chgpin("3201","3333")+"***");
        System.out.println(loginbean.bLogin("3201","3333")+"***");
        //settle set1=new settle();
        ////set1.settleatmj("20020619","0300Y101");
        //for(int i = 0;i < set1.vAmt.size();i++)
        //System.out.println(set1.vAmt.elementAt(i).toString());
    }
}