validaction.java

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

/*
 * validAction.java
 *
 * Created on 2008年2月23日, 下午3:26
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.myapp.struts;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.*;
import com.myapp.struts.DataStore;

/**
 *
 * @author Administrator
 */
public class validAction extends Action{
    
    public ResultSet st1=null;
    public ResultSet st2=null;
    public DataStore ds1 = null;
    public DataStore ds2 = null;
    public ActionForward execute ( ActionMapping mapping ,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse response) throws IOException,ServletException, SQLException{
            
            if (ds1 == null)
	    ds1 = DataStore.getInstance();
            
	    String Uname;
            int Count;

  //          String sql2 = "select * from cardinfo where CardState= 1 ";
            String sql2 = "select UserName,URealName,UCardID,email from Reginfo where UserName in(select UserName  from cardinfo where CardState=2)";

	    st1 = (ResultSet)ds1.read(sql2);
            request.setAttribute("resultset",st1);
	    return(mapping.findForward("valid1"));
}
}