/** *******************图书借阅查询********************** */
private void borrowQuery(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String str = null;
String flag[] = request.getParameterValues("flag");
if (flag != null) {
String aa = flag[0];
if ("a".equals(aa)) {
if (request.getParameter("f") != null) {
str = request.getParameter("f") + " like '%" + request.getParameter("key") + "%'";
}
}
if ("b".equals(aa)) {
String sdate = request.getParameter("sdate");
String edate = request.getParameter("edate");
if (sdate != null && edate != null) {
str = "borrowTime between '" + sdate + "' and '" + edate + "'";
}
System.out.println("日期" + str);
}
// 同时选择日期和条件进行查询
if (flag.length == 2) {
if (request.getParameter("f") != null) {
str = request.getParameter("f") + " like '%" + request.getParameter("key") + "%'";
}
System.out.println("日期和条件");
String sdate = request.getParameter("sdate");
String edate = request.getParameter("edate");
String str1 = null;
if (sdate != null && edate != null) {
str1 = "borrowTime between '" + sdate + "' and '" + edate + "'";
}
str = str + " and borr." + str1;
System.out.println("条件和日期：" + str);
}
}
request.setAttribute("borrowQuery", borrowDAO.borrowQuery(str));
System.out.print("条件查询图书借阅信息时的str:" + str);
request.getRequestDispatcher("borrowQuery.jsp").forward(request, response);
}
