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

功能1：发表日报
DailyReportMapper

点击查看代码

/**
 * 发表日报
 * @param dailyReport
 */
@Insert("insert ft_dailyreport values (null,#{publishDate},#{stuno},#{name},#{spentTime},#{codeamount},#{blogsnumber},#{knowledgePoints},#{state},#{dailyScore},#{stateReason})")
@ResultMap("DailyReportResultMap")
void addDailyReport(DailyReport dailyReport);

StudentService

点击查看代码

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

StudentServlet

点击查看代码

if ("addDR".equals(action)) {
    int id = Integer.parseInt(request.getParameter("id"));
    String publishDate = request.getParameter("publishDate");

    UserInfo userInfo = service.selectUserInfoById(Integer.parseInt(currentUser.getUsername()));
    int stuno = userInfo.getUserID();
    String name = currentUser.getUsername();
    int spentTime = Integer.parseInt(request.getParameter("spentTime"));
    int codeamount= Integer.parseInt(request.getParameter("codeamount"));
    int blogsNumber = Integer.parseInt(request.getParameter("blogsNumber"));
    String knowledgePoints = request.getParameter("knowledgePoints");
    String state ="待审批";
    int dailyScore = 0;
    String stateReason = "空";

    DailyReport dailyReport = new DailyReport();
    dailyReport.setId(id);
    dailyReport.setPublishDate(publishDate);
    dailyReport.setStuno(stuno);
    dailyReport.setName(name);
    dailyReport.setSpentTime(spentTime);
    dailyReport.setCodeamount(codeamount);
    dailyReport.setBlogsnumber(blogsNumber);
    dailyReport.setKnowledgePoints(knowledgePoints);
    dailyReport.setState(state);
    dailyReport.setDailyScore(dailyScore);
    dailyReport.setStateReason(stateReason);

    service.addDailyReport(dailyReport);

    request.setAttribute("message", "新日报添加成功");
    request.getRequestDispatcher("/personalHome.jsp").forward(request, response);
}