ynksinfoaction.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 ynksinfoAction extends LookupDispatchAction {
    public ActionForward insert(ActionMapping mapping, ActionForm form,
                                    HttpServletRequest request,
                                    HttpServletResponse response)throws Exception{
           ynksinfoForm sf= (ynksinfoForm) form;
           DataSource ds=this.getDataSource(request,"DS");
           checkBean sc=new checkBean(ds);
           String yid=sf.getYid();
           String classname=sf.getClassname();
           String subject=sf.getSubject();
           String peocount=sf.getPeocount();
           String addr=sf.getAddr();
           String examdate=sf.getExamdate();
           String examtime=sf.getExamtime();
           String inv=sf.getInvigilation();
           String teacher=sf.getTeacher();
           String week=sf.getWeek();
           String sql="insert into ynksinfo values('"+yid+"','"+classname+"','"+subject+"','"+peocount+"','"+addr+"','"+examdate+"','"+examtime+"','"+inv+"','"+teacher+"','"+week+"')";
           boolean flag=sc.insert(sql);
           if(flag){
               return mapping.findForward("chaynksinfo");
           }
           else{
               return mapping.findForward("Error");
           }
       }
       public ActionForward delete(ActionMapping mapping, ActionForm form,
                                    HttpServletRequest request,
                                    HttpServletResponse response)throws Exception{
                 ynksinfoForm sf=(ynksinfoForm)form;
                 DataSource ds=this.getDataSource(request,"DS");
                 checkBean dl=new checkBean(ds);
                 String yid=sf.getYid();
                 String sql="delete from ynksinfo where yid='"+yid+"'";
                 boolean flag=dl.delete(sql);
                 if(flag){
                 Statement stmt=dl.stmt;
                 ResultSet rst=stmt.executeQuery("select * from ynksinfo");
                 HttpSession session=request.getSession();
                 session.setAttribute("rst",rst);
                 return mapping.findForward("delynksinfo");
                }else{
                    return mapping.findForward("Error");
                }
         }
           protected Map getKeyMethodMap(){
           Map map=new HashMap();
           map.put("button.insert","insert");
           map.put("button.delete","delete");
           return map;
       }
   }