getpesticideinfoservlet.java

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

package ynuServlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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.SearchInfoBean;
import java.util.*;

public class GetPesticideInfoServlet 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 way = request.getParameter("chooseways");
    	SearchInfoBean aBean = new SearchInfoBean();
    	String seacontent = request.getParameter("seacontent");
    	//seacontent = new String(seacontent.getBytes("ISO-8859-1"),"UTF-8");
    	//way = new String(way.getBytes("ISO-8859-1"),"UTF-8");
    	ArrayList resultList = new ArrayList();
    	String toJsp = "/searchbyadmin.jsp";
    	
    	if(way.equals("农药号"))
    	{
    		resultList = aBean.getPesticideInfo("农药号", seacontent);
    	}
    	else if(way.equals("农药名"))
    	{
    		resultList = aBean.getPesticideInfo("农药名", seacontent);
    	}
    	else if(way.equals("价格(以内)"))
    	{
    		resultList = aBean.getPesticideInfo("价格", seacontent);
    	}
    	
    	session.setAttribute("PesticideList", resultList);
    	
    	String rule = request.getParameter("rule");
    	
    	if(rule.equals("user"))
    	{
    		toJsp = "/searchbyuser.jsp";
    	}
    	else if(rule.equals("administor"))
    	{
    		toJsp = "/searchbyadmin.jsp";
    	}
    	else if(rule.equals("anyuser"))
    	{
    		toJsp = "/search.jsp";
    	}
    	RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
    	//dispatcher = request.getRequestDispatcher(toJsp);   	
    	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
    	dispatcher.forward(request, response);
    	//executeSql(request,response);
    }
    
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
        doGet(request, response);
    }
}