noskeylist.java

来自「是一个用VB编写得银行ATM机交易的程序」· Java 代码 · 共 71 行

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 NoSkeyList extends Action {
    
    /** 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("NoSkeyList");
        }
    }
    
    
    private ArrayList getList(){
        ArrayList al=new ArrayList();
        String sql = "select * from Reginfo where Skey!='' and username in (select ui.UserName from Reginfo ui,cardinfo ci where ui.username=ci.username and ci.cardstate=1) and (PKI is NULL or PKI='')";
             
        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;
        }
    }
    
    
    
}