后端增删改查源码-实现增加-删除-修改-查询功能

package com.bank.idinfor_secu_sys_serv.controller; import com.bank.idinfor_secu_sys_serv.entity.Idinfor_secu_sys; import com.bank.idinfor_secu_sys_serv.repository.Idinfor_secu_sysRepository; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.web.bind.annotation.*; import org.springframework.data.domain.Pageable; import java.util.List; import java.util.Optional; /** * @Auther： lifang * @Description * @Date: $ $ * $ * $ **/ @RestController @RequestMapping("/idinfor_secu_sys") public class Idinfor_secu_sysHandler { @Autowired private Idinfor_secu_sysRepository idinfor_secu_sysRepository; @GetMapping("/findAll") public List<Idinfor_secu_sys>findAll() { return idinfor_secu_sysRepository.findAll(); } //新增数据 @PostMapping("/save") public String save(@RequestBody Idinfor_secu_sys idinfor_secu_sys) { Optional<Idinfor_secu_sys>optional=idinfor_secu_sysRepository.findById(idinfor_secu_sys.getId_num()); if(optional!=null && optional.isPresent()) { return "重复信息录入，请重新输入"; } else { //由于数据库是身份信息，我们需要判断失效日期是否大于当前日期，如果是，才能执行报错，否则报错 if (idinfor_secu_sys.getVali_date().before(idinfor_secu_sys.getBirth_date())) { return "失效日期需大于起始日期,请确认！"; } Idinfor_secu_sys result = idinfor_secu_sysRepository.save(idinfor_secu_sys); if (result != null) { return "居民信息新增成功"; } else { return "交易失败，系统处理异常！"; } } } //修改数据库信息 @PutMapping("/update") public String update(@RequestBody Idinfor_secu_sys idinfor_secu_sys) { Idinfor_secu_sys result=idinfor_secu_sysRepository.save(idinfor_secu_sys); if(result!=null) { return "居民信息修改成功"; } else { return "交易失败，系统处理异常！"; } } //根据身份证号查找居民身份信息 @GetMapping("/findById/{id_num}") public Idinfor_secu_sys findById(@PathVariable("id_num") String id_num) { Optional<Idinfor_secu_sys>optional=idinfor_secu_sysRepository.findById(id_num); if(optional!=null && optional.isPresent()) { return idinfor_secu_sysRepository.findById(id_num).get(); } else { return null; } } //分页查询 @GetMapping("/findAll/{page}/{size}") public Page<Idinfor_secu_sys> findAll(@PathVariable("page") Integer page, @PathVariable("size") Integer size) { Pageable pageable= PageRequest.of(page-1,size); /*分页查询*/ return idinfor_secu_sysRepository.findAll(pageable); } //删除信息 @DeleteMapping("/deleteById/{id_num}") public String deleteById(@PathVariable("id_num") String id_num) { idinfor_secu_sysRepository.deleteById(id_num); return "信息删除成功"; } }