JavaEE企業(yè)級項目開發(fā)（第3版）課件 微課9-5：任務(wù)9.2 修改入校報備信息

主講人：蔣衛(wèi)祥延遲符任務(wù)9.2修改入校報備信息JSON交互與RESTful支持修改入校報備信息設(shè)計步驟3．服務(wù)層4．控制層5．視圖層2.Mapper映射文件1．Mapper接口延遲符修改入校報備信息延遲符1.Mapper接口//根據(jù)id查詢?nèi)胄髠淙诵畔ublicEnrollmentregistrationselectEnrollmentregistrationById(intid);//修改報備人信息publicvoidupdateEnrollmentregistrationById(Enrollmentregistrationenrollmentregistration);入校報備信息Mapper接口：EnrollmentregistrationMapper.java校外人員信息Mapper接口：EnrollmentregistrationMapper.java//根據(jù)報備人id查詢校外人員信息publicOffcampusinfoselectOffcampusinfoByEnrollmentId(intenroollmentId);

//修改校外人員信息publicvoidupdateOffcampusinfoById(Offcampusinfooffcampusinfo);修改入校報備信息延遲符2.Mapper映射文件<selectid="selectAllEnrollmentregistration"resultMap="enrollmentregistrationMap">select*fromtb_enrollmentregistration</select><updateid="updateEnrollmentregistrationById"parameterType="cn.js.ccit.pojo.Enrollmentregistration">updatetb_enrollmentregistrationset

reporter=#{reporter},department=#{department},admissionTime=#{admissionTime},departureTime=#{departureTime},is_Driving=#{is_Driving},numberPlate=#{numberPlate},reson=#{reson}whereid=#{id}</update>（1）入校報備映射文件：Enrollmentregistration.xml修改入校報備信息延遲符2.Mapper映射文件<selectid="selectOffcampusinfoByEnrollmentId"parameterType="int"resultMap="offcampusinfoResultMapper">select*fromtb_offcampusinfoo,tb_enrollmentregistrationewhereo.enrollmentId=e.idande.id=#{id}</select><updateid="updateOffcampusinfoById"parameterType="cn.js.ccit.pojo.Offcampusinfo">

updatetb_offcampusinfosetname=#{name},unit=#{unit},idNumber=#{idNumber},phone=#{phone},enrollmentId=#{enrollmentId}whereid=#{id}</update>（2）校外人員映射文件：Offcampusinfo.xml新增入校報備信息延遲符3.服務(wù)層接口實現(xiàn)類IEnrollmentregistrationService.javapublicEnrollmentregistrationselectEnrollmentregistrationById(intid);publicvoidupdateEnrollmentregistrationById(Enrollmentregistrationenrollmentregistration);EnrollmentregistrationService.java//根據(jù)id查詢?nèi)胄髠湫畔ublicEnrollmentregistrationselectEnrollmentregistrationById(intid){returnenrollmentregistrationMapper.selectEnrollmentregistrationById(id);}//修改入校報備信息publicvoidupdateEnrollmentregistrationById(Enrollmentregistrationenrollmentregistration){

enrollmentregistrationMapper.updateEnrollmentregistrationById(enrollmentregistration);}(1)入校報備信息服務(wù)層接口與實現(xiàn)類修改入校報備信息延遲符3.服務(wù)層接口實現(xiàn)類IOffcampusinfoService.java//根據(jù)id修改校外人員信息publicOffcampusinfoselectOffcampusinfoByEnrollmentId(intenroollmentId);//修改校外人員信息publicvoidupdateOffcampusinfoById(Offcampusinfooffcampusinfo);OffcampusinfoService.javapublicOffcampusinfoselectOffcampusinfoByEnrollmentId(intenroollmentId){returnoffcampusinfoMapper.selectOffcampusinfoByEnrollmentId(enroollmentId);

}

publicvoidupdateOffcampusinfoById(Offcampusinfooffcampusinfo){offcampusinfoMapper.updateOffcampusinfoById(offcampusinfo);}(2)校外人員信息服務(wù)層接口與實現(xiàn)類修改入校報備信息延遲符4.控制層

@GetMapping("/findById")publicStringfindEnrollmentregistrationById

(@RequestParam("id")Integerid,Modelmodel){if(enrollmentregistrationList==null

||enrollmentregistrationList.size()==0){

enrollmentregistrationList=enrollmentregistrationService

.selectAllEnrollmentregistration();}Enrollmentregistrationenrollmentregistration=

enrollmentregistrationService

.selectEnrollmentregistrationById(id);model.addAttribute("enrollmentregistration“

,enrollmentregistration);return"enrollmentregistrationInfo";}

@PutMapping(value="/update",produces="application/json;charset=utf-8")publicStringupdate(EnrollmentregistrationenrollmentRegistration,Modelmodel){if(enrollmentregistrationList==null

||enrollmentregistrationList.size()==0){

enrollmentregistrationList=enrollmentregistrationService

.selectAllEnrollmentregistration();

}

enrollmentregistrationService

.updateEnrollmentregistrationById(enrollmentRegistration);for(Offcampusinfooffcampusinfo:

enrollmentRegistration.getOffcampusinfoList()){

offcampusinfo.setEnrollmentId(enrollmentRegistration.getId());

offcampusinfoService.updateOffcampusinfoById