src/servlet/CaXiaosouServlet.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 CaXiaosouServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public CaXiaosouServlet() {
		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 name = vd.getUnicode(request.getParameter("name"));
		String summax = vd.getUnicode(request.getParameter("summax"));
		String summin = vd.getUnicode(request.getParameter("summin"));
		String sql = "select a.id as sid,b.id as xid,name,danjia,sums from shangpin a,xiaosou b where a.id=b.shangpinid ";
		String args[] = {"sid","xid","name","danjia","sums"};
		if(name != null && !name.equals("")){
			sql += "and name like '%"+name+"%'";
		}
		if(summax != null && !summax.equals("")){
			sql += "and sums>"+summax;
		}
		if(summin != null && !summin.equals("")){
			sql += "and sums<"+summin;
		}
		SelectBean sb = new SelectBean();
		ArrayList al = sb.select(sql, args);
		request.setAttribute("xiaolist", al);
		RequestDispatcher rd=request.getRequestDispatcher("/caxiaosou.jsp");
        rd.forward(request,response);
	}

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