examapaction.java

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

package examanpai;

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.servlet.http.HttpSession;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.util.ArrayList;
import java.sql.ResultSet;
import java.io.*;

public class examapAction extends DispatchAction {
    public ActionForward tableInfo(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
        ServletContext context=servlet.getServletContext();
        DataSource ds=(DataSource)context.getAttribute("myDs");
        HttpSession session=request.getSession();
        session.setAttribute("result",null);
        dispose dis=new dispose(ds);
        ResultSet rs=null;
        String bool=request.getParameter("bool");
        if(bool.equals("1")){
            rs=dis.queryInfo("select * from ynksinfo");
        }else if(bool.equals("2")){
            rs=dis.queryInfo("select * from gxkzinfo");
        }else if(bool.equals("3")){
            rs=dis.queryInfo("select * from bukaoinfo");
        }else{rs=null;}
        try{
            if (rs.next()) {
                session.setAttribute("result", rs);  }
        }catch(Exception e){}
        if(bool.equals("1")){
            return mapping.findForward("ynksinfo");
        }else if(bool.equals("2")){
            return mapping.findForward("gxkzinfo");
        }else if(bool.equals("3")){
            return mapping.findForward("bukaoinfo");
        }else{
            return null;
        }
    }

    public ActionForward getDownlist(ActionMapping mapping, ActionForm form,
                                HttpServletRequest request,
                                HttpServletResponse response) {
       ServletContext context=servlet.getServletContext();
       DataSource ds=(DataSource)context.getAttribute("myDs");
       HttpSession session=request.getSession();
       dispose dis=new dispose(ds);
       ArrayList arr=new ArrayList();
       String flag=request.getParameter("flag");
       if(flag.equals("1")){
           arr=dis.ResourceList("select * from yresource");
       }else if(flag.equals("2")){
           arr=dis.ResourceList("select * from gresource");
       }else{arr=null;}
       session.setAttribute("downlist",arr);
       return mapping.findForward("downlist");
   }

   public ActionForward download(ActionMapping mapping, ActionForm form,
                                HttpServletRequest request,
                                HttpServletResponse response) {
       examapActionForm apform=(examapActionForm) form;
       String url=getStr(apform.getUrl().trim());
       File file=new File(url);
       String filename=file.getName();
       long filelong=file.length();
       String filesize=String.valueOf(filelong);

       FileInputStream fin=null;
       BufferedInputStream buffin=null;
       BufferedOutputStream buffout=null;
       try{
           response.setContentType("application/x-msdownload");
           response.setHeader("Content-Disposition","attachment;"+"filename="+new String(filename.getBytes(),"ISO-8859-1"));
           response.setHeader("Context_Length",filesize);
           fin=new FileInputStream(file);
           buffin=new BufferedInputStream(fin);
           OutputStream out=response.getOutputStream();
           buffout=new BufferedOutputStream(out);
           byte buffer[]=new byte[8192];
           int readsize=0;
           while((readsize=buffin.read(buffer,0,8192))!=-1){
               buffout.write(buffer,0,readsize);
           }
           buffout.flush();
           buffout.close();
           buffin.close();
           fin.close();
           out.close();
       }catch(IOException e){}
       return mapping.findForward("downlist");
   }

   public String getStr(String str){
        if(str==null){str="";}
        try{
            byte b[]=str.getBytes("ISO-8859-1");
            str=new String(b);
        }catch(Exception e){}
        return str;
    }
}