项目实训——第三周第二次日志

继续完成归国变更的后端编写，并完成归国信息的提交和撤销功能。
1）回国变更
接口：localhost:8081//student//commitReturnChange
controller层：

/**
     * 提交一个回国变更
     *
     * @param request
     * @return
     * @throws ParseException
     */
    @RequestMapping(value = "/commitReturnChange")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result commitReturnChange(HttpServletRequest request) {
        ReturnChange rc = new ReturnChange();
        rc.setReturnChangeId(Integer.parseInt(request.getParameter("return_change_id")));
        int i = StuService.commitReturnChange(rc);

        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {

            return Result.succ(1);
        }

    }

service层：

 //提交一个归国变更申请
    public int commitReturnChange(ReturnChange rc) {
        return returnChangeDao.commitReturnChange(rc);
    }

dao层：

   int commitReturnChange(ReturnChange rc);

mapper：

<update id="updateReturnChange" parameterType="com.sdu.postgraduate.entity.ReturnChange">
    update return_change  <set>
    <if test="countryNow != null" >
        country_now= #{countryNow,jdbcType=VARCHAR},
        </if>
    <if test="abroadCompany != null" >
        abroad_company= #{abroadCompany,jdbcType=VARCHAR},
        </if>
    <if test="lastDate != null" >
    last_date=#{lastDate,jdbcType=TIMESTAMP},
    </if>
    <if test="nowDate != null" >
    now_date=#{nowDate,jdbcType=TIMESTAMP},
    </if>
    <if test="delayReason!= null" >
        delay_reason=#{delayReason,jdbcType=VARCHAR}
    </if>

  </set>
        where return_change_id=#{returnChangeId,jdbcType=INTEGER}
  </update>

postman测试：

2）撤销一个归国变更申请
接口：localhost:8081//student//deleteReturnChange
controller层：

/**
     * 撤销一个归国变更申请
     *
     * @param request
     * @return
     */
    @RequestMapping(value = "/deleteReturnChange")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result deleteReturnChange(HttpServletRequest request) {
        ReturnChange rc = new ReturnChange();
        rc.setReturnChangeId(Integer.parseInt(request.getParameter("return_change_id")));
        int i = StuService.deleteReturnChange(rc);

        InOutRelationship ior = new InOutRelationship();

        ior.setReturnChangeId(Integer.parseInt(request.getParameter("return_change_id")));
        int j = StuService.iorUpdateReturnApply5(ior);

        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {

            return Result.succ(1);
        }
    }

service层：

//撤销一个归国变更申请
    public int deleteReturnChange(ReturnChange rc) {
        return returnChangeDao.deleteReturnChange(rc);
    }
     public int iorUpdateReturnApply5(InOutRelationship ior) {
        return inOutRelationshipDao.UpdateReturnApply5(ior);
    }

dao层：

 int UpdateReturnApply5(InOutRelationship ior);
 int deleteReturnChange(ReturnChange rc);

mapper：

  <delete id="deleteReturnChange">
    delete from return_change where return_change_id=#{returnChangeId,jdbcType=INTEGER}
  </delete>
  
  <update id="UpdateReturnApply5">
    update in_out_relationship  set return_change_id=-1 where return_change_id=#{returnChangeId,jdbcType=INTEGER}
  </update>

3）提交一个回国申请
接口：localhost:8081//student//commitReturnApply
controller层：

 /**
     * 提交一个回国申请
     *
     * @param request
     * @return
     */
    @RequestMapping(value = "/commitReturnApply")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result commitReturnApply(HttpServletRequest request) {
        ReturnApply ra = new ReturnApply();
        ra.setReturnApplyId(Integer.parseInt(request.getParameter("return_apply_id")));
        int i = StuService.commitReturnApply(ra);

        InOutRelationship ior = new InOutRelationship();
        ior.setReturnApplyId(Integer.parseInt(request.getParameter("return_apply_id")));
        int j = StuService.iorUpdateReturnApply2(ior);
        if (i + j == 2) {
            i = 1;
        } else {
            i = 0;
        }
        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {

            return Result.succ(1);
        }
    }

service层：

// 提交一个归国申请
    public int commitReturnApply(ReturnApply ra) {
        return returnApplyDao.commitReturnApply(ra);
    }

dao层：

 int commitReturnApply(ReturnApply ra);

mapper：

 <update id="commitReturnApply">
    update return_apply  set state="审核中" where return_apply_id=#{returnApplyId,jdbcType=INTEGER}
  </update>

postman测试：

4）撤销一个回国申请
接口：localhost:8081//student//deleteReturnApply
controller层：

/**
     * 撤销一个回国申请
     *
     * @param request
     * @return
     */
    @RequestMapping(value = "/deleteReturnApply")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result deleteReturnApply(HttpServletRequest request) {
        ReturnApply ra = new ReturnApply();
        ra.setReturnApplyId(Integer.parseInt(request.getParameter("return_apply_id")));
        int i = StuService.deleteReturnApply(ra);

        InOutRelationship ior = new InOutRelationship();
        ior.setReturnApplyId(Integer.parseInt(request.getParameter("return_apply_id")));
        int j = StuService.iorUpdateReturnApply4(ior);
        if (i + j == 2) {
            i = 1;
        } else {
            i = 0;
        }
        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {

            return Result.succ(1);
        }

service层：

//撤销一个归国申请
    public int deleteReturnApply(ReturnApply ra) {
        return returnApplyDao.deleteReturnApply(ra);
    }

dao层：

    int deleteReturnApply(ReturnApply ra);

mapper：

  <delete id="deleteReturnApply">
    delete from return_apply where return_apply_id=#{returnApplyId,jdbcType=INTEGER}
  </delete>