questionsaction.java

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

package manage;

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.servlet.http.HttpSession;
import javax.sql.DataSource;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Map;
import java.util.HashMap;
import org.apache.struts.actions.LookupDispatchAction;

public class questionsAction extends LookupDispatchAction {
    public ActionForward insert(ActionMapping mapping, ActionForm form,
                                     HttpServletRequest request,
                                     HttpServletResponse response)throws Exception{
            questionsForm sf= (questionsForm) form;
            DataSource ds=this.getDataSource(request,"DS");
            checkBean sc=new checkBean(ds);
            String id=sf.getId();
            String s_id=sf.getS_id();
            String topic=sf.getTopic();
            String question=sf.getQuestion();
            String q_time=sf.getQ_time();
            String reply=sf.getReply();
            String r_time=sf.getR_time();
            String sql="insert into questions values('"+id+"','"+s_id+"','"+topic+"','"+question+"','"+q_time+"','"+reply+"','"+r_time+"')";
            boolean flag=sc.insert(sql);
            if(flag){
                return mapping.findForward("chaquestions");
            }
            else{
                return mapping.findForward("Error");
            }
        }
        public ActionForward delete(ActionMapping mapping, ActionForm form,
                                     HttpServletRequest request,
                                     HttpServletResponse response)throws Exception{
                  questionsForm sf= (questionsForm) form;
                  DataSource ds=this.getDataSource(request,"DS");
                  checkBean dl=new checkBean(ds);
                  String id=sf.getId();
                  String sql="delete from questions where id='"+id+"'";
                  boolean flag=dl.delete(sql);
                  if(flag){
                  Statement stmt=dl.stmt;
                  ResultSet rst=stmt.executeQuery("select * from questions");
                  HttpSession session=request.getSession();
                  session.setAttribute("rst",rst);
                  return mapping.findForward("delquestions");
                 }else{
                     return mapping.findForward("Error");
                 }
          }
            protected Map getKeyMethodMap(){
            Map map=new HashMap();
            map.put("button.insert","insert");
            map.put("button.delete","delete");
            return map;
        }
    }