小组团队项目个人博客7.0

今天实现了“2.7.2 安全风险维护此模块支持风险项历史版本追溯与对比，详细记录更新人、更新时间、原值/新值）等。”这样一个历史记录的功能


在编辑修改信息后，原信息可以保存到历史记录表中，不过今天还没做出来历史记录页面，但后端数据库显示确确实实是有历史记录的
@Insert("INSERT INTO risk_history (id, responsibleDepartment, riskCode, professionalSystem, riskCategory, " +
"riskProject, riskPoint, riskLevel, harmDegree, controlMeasures, controlPosition, " +
"controlPerson, quantitativeRequirements, entryDate, auditStatus, auditDate) " +
"VALUES (#{id}, #{responsibleDepartment}, #{riskCode}, #{professionalSystem}, #{riskCategory}, " +
"#{riskProject}, #{riskPoint}, #{riskLevel}, #{harmDegree}, #{controlMeasures}, #{controlPosition}, " +
"#{controlPerson}, #{quantitativeRequirements}, #{entryDate}, #{auditStatus}, #{auditDate})")
public void inserthistory(String id, String responsibleDepartment, String riskCode, String professionalSystem, String riskCategory, String riskProject, String riskPoint, String riskLevel, String harmDegree, String controlMeasures, String controlPosition, String controlPerson, String quantitativeRequirements, Date entryDate, String auditStatus, Date auditDate);

@Select("select *from risk_history")
public List<RiskMangement> selectallhistory();

public void inserthistory(String id, String responsibleDepartment, String riskCode, String professionalSystem, String riskCategory, String riskProject, String riskPoint, String riskLevel, String harmDegree, String controlMeasures, String controlPosition, String controlPerson, String quantitativeRequirements, Date entryDate, String auditStatus, Date auditDate){
riskMapper.inserthistory( id, responsibleDepartment, riskCode, professionalSystem, riskCategory, riskProject, riskPoint, riskLevel, harmDegree, controlMeasures, controlPosition, controlPerson, quantitativeRequirements, entryDate, auditStatus, auditDate);
}

public List<RiskMangement> selectallhistory(){
    return riskMapper.selectallhistory();
}

//查询历史记录

@GetMapping("/inserthistory")
public void inserthistory(HttpServletResponse resp, HttpServletRequest request) throws Exception{
    BufferedReader br=request.getReader();
    String param=br.readLine();
    RiskMangement RiskMangement=JSON.parseObject(param,RiskMangement.class);
    riskservice.inserthistory(RiskMangement.getId(),RiskMangement.getResponsibleDepartment(),RiskMangement.getRiskCode(),RiskMangement.getProfessionalSystem(),RiskMangement.getRiskCategory(),RiskMangement.getRiskProject(),RiskMangement.getRiskPoint(),RiskMangement.getRiskLevel(),RiskMangement.getHarmDegree(),RiskMangement.getControlMeasures(),RiskMangement.getControlPosition(),RiskMangement.getControlPerson(),RiskMangement.getQuantitativeRequirements(),RiskMangement.getEntryDate(),RiskMangement.getAuditStatus(),RiskMangement.getAuditDate());
}
@PostMapping("/inserthistory")
public void inserthistory1(HttpServletResponse resp, HttpServletRequest request) throws Exception{
    this.inserthistory(resp, request);
}


@GetMapping("/selectallhistory")
public void selectallhistory(HttpServletResponse resp, HttpServletRequest request) throws Exception{
    List<RiskMangement> list=riskservice.selectallhistory();
    String json= JSON.toJSONString(list);
    resp.setContentType("text/json;charset=utf-8");
    resp.getWriter().write(json);
}
@PostMapping("/selectallhistory")
public void selectallhistory1(HttpServletResponse resp, HttpServletRequest request) throws Exception{
    this.selectallhistory(resp, request);
}