多条件查询数据库,将查询结果返回页面(ajax/servlet)
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());
}
}
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;
//按条件查询设计报告
pub