cacheckaction.java

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

/*
 * CACheckAction.java
 *
 * Created on 2008年2月23日, 下午9:18
 */

package BankCheck.bean;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
import com.mysql.jdbc.Driver;
import java.sql.*;

import java.sql.ResultSet;
import com.myapp.struts.DataStore;
import BankCheck.bean.CACheckActionForm;
/**
 *
 * @author Penny
 * @version
 */

public class CACheckAction extends Action {
    
    /* forward name="success" path="" */
    private final static String SUCCESS = "CACheck_success";
    private final static String ERROR = "CACheck_error";
    private final static String WAIT = "CACheck_wait";
    //private final static String tt="NULL";
    /**
     * This is the action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     * @throws java.lang.Exception
     * @return
     */
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        ActionErrors errors=new ActionErrors();
        HttpSession s=request.getSession();
        CACheckActionForm caCheckActionForm=(CACheckActionForm)form;
        String username;
        String userpsw;
        
       // UserName=(String)caCheckActionForm.getUserName();
       // UserPassWord=(String)caCheckActionForm.getUserPassWord();
        username=(String)((CACheckActionForm)form).getUserName();
       
       //处理字符格式
        username=new String(username.getBytes("ISO-8859-1"),"GB2312");
        String sql="select ui.UserName,ui.PKI,ci.CardState from Reginfo ui,Cardinfo ci where (ui.UserName='"+username+"' or ui.UCardID='"+username+"') and ui.UserName=ci.UserName";
        boolean result=false;
        try{
            DataStore db=DataStore.getInstance();
            ResultSet rs = db.read(sql);           
            if(rs.next())
            {   
                 s.setAttribute("UserName", rs.getString(1));  
                 String pki=rs.getString(2).toString();
                // s.setAttribute("PKI",rs.getString(2));
                if(pki.equals("NULL")||pki.equals("")){
                     return mapping.findForward(WAIT);
                }                                   
                 s.setAttribute("PKI",pki);
                 int cardState;
                 cardState=rs.getInt(3);
                 if(cardState==0)
                 {
                     s.setAttribute("CardState","未审核");
                 }
                 else if(cardState==1)
                 {
                     s.setAttribute("CardState","已审核");
                 }
                 else if(cardState==2)
                 {
                     s.setAttribute("CardState","有效");
                 }
                 else if(cardState==3)
                 {
                     s.setAttribute("CardState","冻结");
                 }
                 else if(cardState==4)
                 {
                     s.setAttribute("CardState","未通过");
                 }
                     
            else
            {
                return mapping.findForward(ERROR);
            }
            rs.close();
             }          
        }
        catch(Exception e){
            e.printStackTrace();
            return mapping.findForward(ERROR);
        }
       
        return mapping.findForward(SUCCESS);        
    }
}