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);
}
posted @   Moonbeamsc  阅读(4)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· DeepSeek在M芯片Mac上本地化部署
返回顶端
点击右上角即可分享
微信分享提示