2024/2/5日 日志 期末考试案例回顾与分析---》综合案例（9）

功能6：统计日报
DailyReportMapper

点击查看代码

@Select("SELECT * FROM ft_dailyreport WHERE publishDate BETWEEN #{startDate} AND #{endDate}")
@ResultMap("DailyReportResultMap")
List<DailyReport> getSubmittedReportsBetweenDates(@Param("startDate") String startDate, @Param("endDate") String endDate);

TeacherService

点击查看代码

public List<DailyReport> getSubmittedReportsBetweenDates(String startDate, String endDate) {
    try(SqlSession sqlSession = factory.openSession()) {
        DailyReportMapper dailyReportMapper = sqlSession.getMapper(DailyReportMapper.class);
        return dailyReportMapper.getSubmittedReportsBetweenDates(startDate, endDate);
    }
}

TeacherServlet

点击查看代码

else if("statistics".equals(action)){
    String startDate = request.getParameter("startDate");
    String endDate = request.getParameter("endDate");
    List<DailyReport> reports = teacherService.getSubmittedReportsBetweenDates(startDate, endDate);
    request.setAttribute("reports", reports);
    request.setAttribute("message", "统计成功");
    request.getRequestDispatcher("/statisticsDR.jsp").forward(request, response);
}