src/servlet/HickeySearchServlet.java

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

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

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
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 HickeySearchServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public HickeySearchServlet() {
		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 flag = vd.getUnicode(request.getParameter("flag"));
		String begintime = vd.getUnicode(request.getParameter("begintime"));
		String endtime = vd.getUnicode(request.getParameter("endtime"));
		String smalltype = vd.getUnicode(request.getParameter("smalltype"));
		SelectBean sb = new SelectBean();
		
		if(flag != null && flag.equals("1")){
			String sql = "select a.id as aid,hickey,sums,times,b.* from hiaddstorage a,hickey b where a.hickey=b.id and datediff(day,'"+begintime+"',times)>0 and datediff(day,'"+endtime+"',times)<0";
			String[] args = {"aid","hickey","sums","times","id","name","spec","yieldly","storage","price","smalltype"};
			ArrayList al = sb.select(sql, args);
			request.setAttribute("leaddstoragetime", al);
			String sql1 = "select b.name,sum(cast(sums as int)) as sums from hiaddstorage a,hickey b where a.hickey=b.id and datediff(day,'"+begintime+"',times)>0 and datediff(day,'"+endtime+"',times)<0 group by b.name";
			String[] args1 = {"name","sums"};
			ArrayList al1 = sb.select(sql1, args1);
			request.setAttribute("statistic", al1);
		}
		if(flag != null && flag.equals("2")){
			String sql = "select a.id as aid,hickey,sums,times,b.* from hireducestorage a,hickey b where a.hickey=b.id and datediff(day,'"+begintime+"',times)>0 and datediff(day,'"+endtime+"',times)<0";
			String[] args = {"aid","hickey","sums","times","id","name","spec","yieldly","storage","price","smalltype"};
			ArrayList al = sb.select(sql, args);
			request.setAttribute("lereducestoragetime", al);
			String sql1 = "select b.name,sum(cast(sums as int)) as sums from hireducestorage a,hickey b where a.hickey=b.id and datediff(day,'"+begintime+"',times)>0 and datediff(day,'"+endtime+"',times)<0 group by b.name";
			String[] args1 = {"name","sums"};
			ArrayList al1 = sb.select(sql1, args1);
			request.setAttribute("statistic", al1);