多条件查询数据库，将查询结果返回页面（ajax/servlet）

多条件查询数据库，将查询结果返回页面（ajax/servlet）

• SearchReportServlet

package SERVLET;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

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 org.apache.taglibs.standard.lang.jstl.AndOperator;
import org.json.JSONException;
import org.json.JSONObject;

import DAO.DesignReportDAO;

public class SearchReportServlet extends HttpServlet {

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

	}


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		request.setCharacterEncoding("utf-8");
	    
		HttpSession session = request.getSession();
		
		String name=request.getParameter("name");
		String enterprise_code=request.getParameter("enterprise_code");
		String elevator_type=request.getParameter("elevator_type");
		String date1=request.getParameter("date1");
		String date2=request.getParameter("date2");
		
	    DesignReportDAO dao=new DesignReportDAO();
	    ArrayList<JSONObject> array = null;
	    	try {
	    		//获取数据库数据
				array = dao.select_part_reports(name, enterprise_code, elevator_type, date1, date2);
				System.out.println(array);
			} catch (JSONException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			     response.setContentType("text/html;charset=utf-8");
			     PrintWriter pw = response.getWriter();	
			     pw.print(array.toString());   

	}
}

• DesignReportDAO

package DAO;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import org.json.JSONException;
import org.json.JSONObject;
public class DesignReportDAO extends DataSourceConfig {
		private static String SELECT_ALL_Design_Report = "SELECT * FROM design_report_view";
		private Connection conn = null;
		private Statement statement = null;
		
		//按条件查询设计报告
		public ArrayList<JSONObject