getorderbyadminservlet.java

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

package ynuServlet;


import java.io.IOException;
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.OrderListBean;

public class GetOrderByAdminServlet 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 {
		HttpSession session = request.getSession();
		
		String start = request.getParameter("start");
		String end = request.getParameter("end");

		if (start != null && end != null) {
			//username = new String(username.getBytes("ISO-8859-1"), "UTF-8");
			executeSql(request,response,start,end);
		} else {
			session.invalidate();
		}
	}

	public void executeSql(HttpServletRequest request, HttpServletResponse response,
        	String start,String end)
                      throws ServletException,IOException 
    {
		response.setContentType("text/html");
		HttpSession session = request.getSession();
		ServletContext servletContext = getServletContext();
		OrderListBean aOrderListBean = new OrderListBean();
		ArrayList aOrderList = aOrderListBean.GetOrderByAdmin(start, end);
		
		session.setAttribute("OrderListByAdmin", aOrderList);
		 
		
	    String toJsp="/watchlist.jsp";
		RequestDispatcher dispatcher = servletContext.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);
	}
}