getadvandnewservlet.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuServlet;


import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import ynuBean.AdviceReportBean;
import ynuBean.SearchInfoBean;

public class GetAdvandNewServlet extends HttpServlet {
	public void init()throws ServletException
    {
    	
    }
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
    	sendsql(request,response);
    }
    
    public void sendsql(HttpServletRequest request, HttpServletResponse response)
    throws ServletException,IOException
    {  	  	
    	executeSql(request,response);
    }
	
    public void executeSql(HttpServletRequest request, HttpServletResponse response)
                  throws ServletException,IOException 
    {
    	HttpSession session = request.getSession();
        String toJsp = "/advice.jsp";
        String way = request.getParameter("way");
        AdviceReportBean aBean = new AdviceReportBean();
        
        if(way.equals("getadvice"))
        {
            ArrayList allList = aBean.getAdvices();
        	session.setAttribute("AdviceList", allList);
        	toJsp="/advice.jsp";
        }
        else if(way.equals("getnews"))
        {
            ArrayList allList = aBean.getReports();
        	session.setAttribute("ReportList", allList);
        	toJsp="/report.jsp";
        }
    	
    	RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
    	//dispatcher = request.getRequestDispatcher(toJsp);   	
    	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
    	dispatcher.forward(request, response);
    }	
    
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
        doGet(request, response);
    }
}