adviceservlet.java

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

package ynuServlet;

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

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
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.AdvicesBean;

public class AdviceServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public AdviceServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		sendsql(request,response);
	}
	
	public void sendsql(HttpServletRequest request, HttpServletResponse response)
    throws ServletException,IOException
    {
    	//HttpSession session = request.getSession();
    	executeSql(request,response);

    }
	
	public void executeSql(HttpServletRequest request, HttpServletResponse response
			)throws ServletException,IOException 
    {
    	response.setContentType("text/html");
    	HttpSession session = request.getSession();
    	ServletContext servletContext = getServletContext();
    	AdvicesBean aBean = new AdvicesBean();
    	ArrayList adviceList = new ArrayList();//存放属性名
    	
    	adviceList = aBean.getAdvices();
    	session.setAttribute("adviceList",adviceList);
    	
    	RequestDispatcher requestDispatcher = 
    	servletContext.getRequestDispatcher("/index.jsp");
    	requestDispatcher.forward(request, response);    	
  	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);

	}

}