日期筛选与查询功能实现-优快云博客

本文链接：https://blog.youkuaiyun.com/haining711/article/details/8586754

</head>
<%
     String startdate3="";
       if(request.getParameter("startdate3")!=null){
         startdate3=request.getParameter("startdate3");
       }
    String enddate3="";
    if(request.getParameter("enddate3")!=null){
      enddate3=request.getParameter("enddate3");
    }
%>

<body>

<tr>
                    <td >开始日期:
                                             <input type="text" size='10' name="startdate3" id="startdate3" value="" οnfοcus="c.showMoreDay = false;c.show(this);" /> 
                             结束日期:

</body>

//结合查询方法进行处理

   RizhiDao rizhiDao = new RizhiDaoImpl();//实现类实现接口
   List list = new ArrayList();//定义集合
   String startdate="";
   String enddate="";
Rizhi pborder=new Rizhi();//实例化对象

startdate = request.getParameter("startdate3");//得到页面日期的值
enddate = request.getParameter("enddate3");

      if(startdate!="" && enddate!=""){
      String sql = "select * from EB_VisitingLogs where Date>='"+startdate+"' and Date<= '"+enddate+"'";
      list = rizhiDao.SelectSql(sql);
      request.getSession().setAttribute("rizhi_manager", list);
      }else if(startdate!="" || enddate!=""){
      String sql = "select * from EB_VisitingLogs";
      list = rizhiDao.SelectSql(sql);
      request.getSession().setAttribute("rizhi_manager", list);
      }else{
      String sql = "select * from EB_VisitingLogs";
      list = rizhiDao.SelectSql(sql);
      request.getSession().setAttribute("rizhi_manager", list);
      }

   request.getSession().setAttribute("startdate3", startdate);
   request.getSession().setAttribute("enddate3", enddate);

   RequestDispatcher requsetDispatcher = request.getRequestDispatcher("../rizhi_manger.jsp");//页面跳转

requsetDispatcher.forward(request, response);

通过日期控件查询