src/servlet/SelectServlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package servlet;

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 util.Validate;
import bean.SelectBean;

public class SelectServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public SelectServlet() {
		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 {
		Validate vd = new Validate();
		String zonglei = vd.getUnicode(request.getParameter("zonglei"));
		String name = vd.getUnicode(request.getParameter("name"));
		String candi = vd.getUnicode(request.getParameter("candi"));
		String maxkucun = vd.getUnicode(request.getParameter("maxkucun"));
		String minkucun = vd.getUnicode(request.getParameter("minkucun"));
		String maxjinjia = vd.getUnicode(request.getParameter("maxjinjia"));
		String minjinjia = vd.getUnicode(request.getParameter("minjinjia"));
		String maxdanjia = vd.getUnicode(request.getParameter("maxdanjia"));
		String mindanjia = vd.getUnicode(request.getParameter("mindanjia"));
		String [] args = {"id","name","candi","jinjia","danjia","danwei","zhonglei","kucun"};
		String sql = "select * from shangpin";
		if(zonglei != null && !zonglei.equals("")){
			sql = sql+" where zhonglei='"+zonglei+"'";
		}
		if(name != null && !name.equals("")){
			sql = sql+" where name like '%"+name+"%'";
		}
		if(candi != null && !candi.equals("")){
			sql = sql+" where candi like '%"+candi+"%'";
		}
		if(maxkucun != null && !maxkucun.equals("")){
			sql = sql+" where kucun>'"+maxkucun+"'";
		}
		if(minkucun != null && !minkucun.equals("")){
			sql = sql+" where kucun<'"+minkucun+"'";
		}