queryaction.java

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

package exambk;

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.DynaActionForm;
import org.apache.struts.action.Action;
import javax.servlet.http.HttpSession;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.sql.ResultSet;
import java.util.HashMap;
import java.util.Map;

public class queryAction extends Action{
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                HttpServletRequest request,
                                HttpServletResponse response) {
        DynaActionForm qy=(DynaActionForm) form;
        baokaoActionForm bf =new baokaoActionForm();
        ServletContext context=servlet.getServletContext();
        DataSource ds=(DataSource)context.getAttribute("myDs");
        bkdispose dis=new bkdispose(ds);
        HttpSession session=request.getSession();
        String result="none";
        ResultSet rs=dis.queryinfo(qy.getString("stuno"));
        try {
            if(rs.next()){
                bf.setStuno(rs.getString(1));
                bf.setStuname(rs.getString(2));
                bf.setSex(rs.getString(3));
                bf.setIdnum(rs.getString(4));
                bf.setSubject(rs.getString(5));
                bf.setPhone(rs.getString(6));
                bf.setPhoto(rs.getString(7));
                result="exits";
            }
            }catch(Exception e){}

        session.setAttribute("stuinfo",bf);
        session.setAttribute("rs",result);
        return mapping.findForward("queryinfo");
    }

    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;
    }

}