selectaction.java

sql+struts+jsp 提供考试的一般需求

package users;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import javax.sql.DataSource;
import java.sql.ResultSet;
import javax.servlet.http.HttpSession;

public class selectAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) throws Exception{
        selectActionForm chooseForm = (selectActionForm) form;
        String examtype=getStr(chooseForm.getExamtype().trim());
        String claorsub=getStr(chooseForm.getClaorsub().trim());
        DataSource ds=this.getDataSource(request,"DS");
        selectbean bean=new selectbean(ds);
        ResultSet rs=bean.select(examtype,claorsub);
        HttpSession se=request.getSession();
        se.setAttribute("res",rs);
        if(examtype.equals("gxkz")){
          return mapping.findForward("gxkz");
        }
        if(examtype.equals("ynks")){
            return mapping.findForward("ynks");
        }
        return null;
    }

    public String getStr(String str){
        if(str==null){str="";}
        try{
            byte b[]=str.getBytes("ISO-8859-1");
            str=new String(b);
        }catch(Exception e){}
        return str;
    }

}