loginbean.java

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

package boco.javabean.login;


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;
    String usrname = "";
    String pin  = "";
    String usrmail = "";
    String usrphone = "";
    String usraddress= "";
    String usrdes = "";
    ChineseTransfer atoc = new ChineseTransfer();
    Vector vv = new Vector();
    //构造函数，初始化变量
    public loginbean(){
        dba  = new DBAccess();
        sql = "";
        check = false;
    }
    public boolean checkin(String usrsign,String usrpin){
        sql = "select * from powerUser where usrsign='"+usrsign+"'and usrpin='"+usrpin+"'";
        try{
            dba=new DBAccess();
            objDBConnection = objDBConnection.getInstance() ;
            m_Connection = objDBConnection.getConnection("access") ;
            rs = dba.executeQuery(m_Connection,sql) ;
            System.out.println("sql:"+sql);
            while(rs.next()){
                usrname = atoc.AsciiToChineseString(rs.getString(2));
                pin =atoc.AsciiToChineseString(rs.getString(3));
                usrmail =atoc.AsciiToChineseString(rs.getString(4));
                usrphone =atoc.AsciiToChineseString(rs.getString(5));
                usraddress =atoc.AsciiToChineseString(rs.getString(6));
                usrdes =atoc.AsciiToChineseString(rs.getString(7));
                /*usrname = rs.getString(2);
                pin = rs.getString(3);
                usrmail = rs.getString(4);
                usrphone = rs.getString(5);
                usraddress = rs.getString(6);
                usrdes = rs.getString(7);*/

                check=true;
            }

            rs.close() ;
            objDBConnection.freeConnection("access",m_Connection) ;
        }
        catch(Exception e){
            System.out.print(e.getMessage()) ;
        }
        return check;
    }
    public boolean chgdetail(String usrsign,String usrname,String pass,String usrmail,String usrphone,String usraddress,String usrdes){
      usrname = atoc.ChineseStringToAscii(usrname);
      pass    = atoc.ChineseStringToAscii(pass);
      usrmail = atoc.ChineseStringToAscii(usrmail);
      usrphone = atoc.ChineseStringToAscii(usrphone);
      usraddress = atoc.ChineseStringToAscii(usraddress);
      usrdes = atoc.ChineseStringToAscii(usrdes);
      sql = "UPDATE  powerUser SET usrname = '"+usrname+"',usrpin = '"+pass+"',usrmail = '"+usrmail+"',usrphone = '"+usrphone+"',usraddress = '"+usraddress+"' ,usrdes ='"+usrdes+"' WHERE usrsign = '"+usrsign+"'";
      //test:
      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 String  getusrname(){
        return usrname;
    }
    public String getusrpin(){
        return pin;
    }
    public String getusrmail(){
        return usrmail;
    }
    public String getusrphone(){
        return usrphone;
    }
    public String getusraddress(){
        return usraddress;
    }
    public String getusrdes(){
        return usrdes;
    }
  public static void main(String[] args){
      /*loginBean loginbean = new loginBean();
      boolean bb = loginbean.checkin("0001","pass");
      if(bb)
          System.out.println("111");
      else
          System.out.println("222");
      boolean bc = loginbean.chgdetail("0001","用户名","pass","[e-mail]","国内12345678","3663号","青浦之行");
      if(bc)
          System.out.println("333");
      else
          System.out.println("555");*/
      //System.out.println(loginbean.changepin("0300Y101","333"));
      //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());
  }
}