uncheckedaccount.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 UnCheckedAccount extends Action {
    public ArrayList al = new ArrayList();
    /** Creates a new instance of UnCheckedAccount */
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        ArrayList al = getList();
        if(al==null){
            return mapping.findForward("Error");
        }else{
            request.getSession().setAttribute("AccountList",al);
            return mapping.findForward("AccountList");
        }
    }
    
    
    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;
        }
    }
    
    
    
}