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

public class scoreAction extends LookupDispatchAction {
   public ActionForward insert(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)throws Exception{
        ScoreActionForm sf= (ScoreActionForm) form;
        DataSource ds=this.getDataSource(request,"DS");
        checkBean sc=new checkBean(ds);
        String stuno=sf.getStuno();
        String name=sf.getName();
        String speciality=sf.getSpeciality();
        String banji=sf.getClassname();
        String kecheng=sf.getKecheng();
        String score=sf.getScore();
        String sql="insert into stuscore values('"+stuno+"','"+name+"','"+speciality+"','"+banji+"','"+score+"','"+kecheng+"')";
        boolean flag=sc.insert(sql);
        if(flag){
            return mapping.findForward("chaxun");
        }
        else{
            return mapping.findForward("Error");
        }
    }
    public ActionForward delete(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response)throws Exception{
              ScoreActionForm sf=(ScoreActionForm)form;
              DataSource ds=this.getDataSource(request,"DS");
              checkBean dl=new checkBean(ds);
              String stuno=sf.getStuno();
              String sql="delete from stuscore where stuno='"+stuno+"'";
              boolean flag=dl.delete(sql);
              if(flag){
              Statement stmt=dl.stmt;
              ResultSet rst=stmt.executeQuery("select * from stuscore");
              HttpSession session=request.getSession();
              session.setAttribute("rst",rst);
              return mapping.findForward("delScore");
             }else{
                 return mapping.findForward("Error");
             }
      }
        protected Map getKeyMethodMap(){
        Map map=new HashMap();
        map.put("button.insert","insert");
        map.put("button.delete","delete");
        return map;
    }
}