gxkzinfoaction.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 gxkzinfoAction extends LookupDispatchAction {
    public ActionForward insert(ActionMapping mapping, ActionForm form,
                                   HttpServletRequest request,
                                   HttpServletResponse response)throws Exception{
          gxkzinfoForm sf= (gxkzinfoForm) form;
          DataSource ds=this.getDataSource(request,"DS");
          checkBean sc=new checkBean(ds);
          String gid=sf.getGid();
          String subject=sf.getSubject();
          String distin=sf.getDistin();
          String charge=sf.getCharge();
          String operdesk=sf.getOperdesk();
          String bmstart=sf.getBmstart();
          String bmend=sf.getBmend();
          String examdate=sf.getExamdate();
          String examtime=sf.getExamtime();
          String examaddr=sf.getExamaddr();
          String sql="insert into gxkzinfo values('"+gid+"','"+subject+"','"+distin+"','"+charge+"','"+operdesk+"','"+bmstart+"','"+bmend+"','"+examdate+"','"+examtime+"','"+examaddr+"')";
          boolean flag=sc.insert(sql);
          if(flag){
              return mapping.findForward("chagxkzinfo");
          }
          else{
              return mapping.findForward("Error");
          }
      }
      public ActionForward delete(ActionMapping mapping, ActionForm form,
                                   HttpServletRequest request,
                                   HttpServletResponse response)throws Exception{
                gxkzinfoForm sf=(gxkzinfoForm)form;
                DataSource ds=this.getDataSource(request,"DS");
                checkBean dl=new checkBean(ds);
                String gid=sf.getGid();
                String sql="delete from gxkzinfo where gid='"+gid+"'";
                boolean flag=dl.delete(sql);
                if(flag){
                Statement stmt=dl.stmt;
                ResultSet rst=stmt.executeQuery("select * from gxkzinfo");
                HttpSession session=request.getSession();
                session.setAttribute("rst",rst);
                return mapping.findForward("delgxkzinfo");
               }else{
                   return mapping.findForward("Error");
               }
        }
          protected Map getKeyMethodMap(){
          Map map=new HashMap();
          map.put("button.insert","insert");
          map.put("button.delete","delete");
          return map;
      }
  }