accountchecked.java

是一个用VB编写得银行ATM机交易的程序

package com.myapp.struts.forvenus;

import com.myapp.struts.*;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;



import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;

/**
 *
 * @author Administrator
 */
public class AccountChecked extends Action {
     public ArrayList al = new ArrayList();
    /** Creates a new instance of AccountChecked */
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        String action = request.getParameter("action");
        String userName = request.getParameter("uname");
        
        if(action.equals("pass")){
            doPass(userName);
        }else if(action.equals("unpass")){
            doUnpass(userName);
        }
        al = getList();
        if(al==null){
            return mapping.findForward("Error");
        }else{
            request.getSession().setAttribute("AccountList",al);
            return mapping.findForward("AccountList");
        }
    }
    
    
    private void doPass(String userName){
        DB conn=new DB();
        
        String sql_1 = "update cardinfo set CardState = 1 where UserName = '"+ userName +"'";
        try{
            conn.ExcuteSql(sql_1);
        } catch(Exception e) {
        }
        
        String letterNum = getRand(10);
        String letterKey = getRand2(10);
        String sql_2 = "update Reginfo set LetterNum = '" + letterNum + "', LetterKey = '" + letterKey + "' where UserName = '"+ userName +"'";
        try{
            conn.ExcuteSql(sql_2);
        } catch(Exception e) {
        }
    }
    
    private void doUnpass(String userName){
        String sql = "update cardinfo set CardState = 4 where UserName = '"+ userName +"'";
        DB conn=new DB();
        try{
            conn.ExcuteSql(sql);
        } catch(Exception e) {
        }
    }
    
    
    private ArrayList getList(){
        String sql = "select * from Reginfo where Reginfo.UserName in " +
                " (select cardinfo.UserName from cardinfo where cardinfo.CardState = 0)";
             
        DB conn=new DB();
        
       
        try{
            ResultSet rs=(ResultSet)conn.Select(sql);            
            while(rs.next()) {
                UserinfoBean ub = new UserinfoBean(
                        rs.getString("UserName"),
                        rs.getString("ULogPass"),
                        rs.getString("UPayPass"),
                        rs.getString("UserGroups"),
                        rs.getString("URealName"),
                        rs.getString("UCardID"),
                        rs.getString("PKI"),
                        rs.getString("Skey"),
                        rs.getString("email"),
                        rs.getString("UPhone"),
                        rs.getDouble("Account"),
                        rs.getString("LetterNum"),
                        rs.getString("LetterKey")
                        );
                al.add(ub);
            }
            return al;
        } catch(Exception e) {
            return null;
        }
    }
    
    
    public static String getRand(int len) {
       java.util.Random random = new java.util.Random();
       
       long randNumber = random.nextLong();
       randNumber=Math.abs(randNumber);
       String result=java.lang.Long.toString(randNumber).substring(0, len);
       
       return result;
    }
    
    public static String getRand2(int len) {
       java.util.Random random = new java.util.Random(100);

       long randNumber = random.nextLong();
       randNumber=Math.abs(randNumber);
       String result=java.lang.Long.toString(randNumber).substring(0, len);
       
       return result;
    }
    
}