questionaction.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.actions.DispatchAction;
import javax.sql.DataSource;
import java.sql.*;
import java.util.Map;
import java.util.HashMap;
import java.util.ArrayList;
import javax.servlet.http.HttpSession;

public class questionAction extends DispatchAction {
    public ActionForward search(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)throws Exception {
        questionForm questionForm = (questionForm) form;
        DataSource ds=this.getDataSource(request,"DS");
        consultationBean consult=new consultationBean(ds);
        HttpSession session=request.getSession();
        session.setAttribute("rst",consult.secrch());
        return mapping.findForward("result");
    }
    public ActionForward insert(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)throws Exception {
        questionForm questionForm = (questionForm) form;
        DataSource ds=this.getDataSource(request,"DS");
        consultationBean consult=new consultationBean(ds);
        String topic=questionForm.getTopic();
        String question=questionForm.getQuestion();
        String stuno;
        HttpSession session=request.getSession();
        String sess=(String)session.getAttribute("stuno");
        if(sess==null){
            stuno="1111111111";
        }else{
            stuno = sess;
        }
        consult.insert(stuno,topic,question);
        return search(mapping, form,request,response);
    }
    public ActionForward qsearch(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)throws Exception {
        questionForm questionForm = (questionForm) form;
        String qid=request.getParameter("qid");
//        byte[] b=qid.getBytes("ISO-8859-1");
//        qid=new String(b);
        DataSource ds=this.getDataSource(request,"DS");
        consultationBean consult=new consultationBean(ds);
        HttpSession session=request.getSession();
        session.setAttribute("consult",consult.qsecrch(qid));
        return mapping.findForward("question");
    }

//    public ActionForward reply(ActionMapping mapping, ActionForm form,
//                                 HttpServletRequest request,
//                                 HttpServletResponse response)throws Exception {
//        questionForm questionForm = (questionForm) form;
//        DataSource ds=this.getDataSource(request,"DS");
//        consultationBean consult=new consultationBean(ds);
//        String topic=questionForm.getTopic();
//        String question=questionForm.getQuestion();
//        String reply=questionForm.getReply();
//        HttpSession session=request.getSession();
//        consult.reply(id,reply);
//
//        return search(mapping, form,request,response);
//    }

//    protected Map getKeyMethodMap(){
//        Map map=new HashMap();
//        map.put("question.search","search");
//        map.put("question.insert","insert");
//        map.put("question.reply","reply");
//        map.put("question.qsearch","qsearch");
//        return map;
//    }


}