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

功能5：评分日报

DailyReportMapper

点击查看代码

@Update("update ft_dailyreport set dailyScore=#{dailyScore},state=#{state},stateReason=#{stateReason} where id=#{id}")
@ResultMap("DailyReportResultMap")
void modifyDailyReportScore(DailyReport dailyReport);

StudentService

点击查看代码

public void modifyDailyReportScore(DailyReport dailyReport){
    try (SqlSession session = factory.openSession()) {
        DailyReportMapper dailyReportMapper = session.getMapper(DailyReportMapper.class);
        dailyReportMapper.modifyDailyReportScore(dailyReport);
        session.commit();
    }
}

TeacherServlet

点击查看代码

else if ("scoreDR".equals(action)) {
    int id = Integer.parseInt(request.getParameter("id"));
    int score = Integer.parseInt(request.getParameter("score"));
    String reason = request.getParameter("reason");
    DailyReport dailyReport = service.getDailyReportById(id);
    dailyReport.setDailyScore(score);
    dailyReport.setState("评分");
    dailyReport.setStateReason(reason);
    service.modifyDailyReportScore(dailyReport);
    request.setAttribute("message", "评分成功");
    request.getRequestDispatcher("/personalHome.jsp").forward(request, response);
}