SSSP项目-CRUD的实现

  • A+
所属分类：JAVA

CRUD的实现

1.新增，编辑，修改员工信息

基本可以通过一个模板ModelAttribute的来实现新增，修改，和保存

Service层实现

  1. /**
  2.      * 保存员工
  3.      * @param employee
  4.      */
  5.     @Transactional(readOnly = false)
  6.     public void saveEmployee(Employee employee) {
  8.         //新增员工的情况
  9.         if(employee.getId() == null) {
  10.             employee.setCreateTime(new Date());
  11.         }
  12.         employeeRepository.saveAndFlush(employee);
  13.     }
  15.     /**
  16.      * 获取员工
  17.      * @param id
  18.      * @return
  19.      */
  20.     @Transactional(readOnly = true)
  21.     public Employee getEmployee(int id) {
  22.         return employeeRepository.findOne(id);
  23.     }

Controller层实现

  1. /**
  2.      * 员工编辑
  3.      * @return
  4.      */
  5.     @RequestMapping(value="/empedit/{id}",method=RequestMethod.GET)
  6.     public String empedit(@PathVariable("id") Integer id,Map<String, Object> map) {
  7.         Employee employee = new Employee();
  8.         if(id != null) {
  9.             employee = employeeService.getEmployee(id);
  10.         }
  11.         map.put("employee", employee);
  12.         //所有员工
  13.         map.put("employees", employeeService.getAll());
  14.         //所有部门
  15.         map.put("depts", deptService.getAll());
  16.         return "employee/edit";
  17.     }
  19.     /**
  20.      * 员工保存
  21.      * @param map
  22.      * @return
  23.      */
  24.     @RequestMapping(value="/empsave",method=RequestMethod.POST)
  25.     public String empsave(Employee employee) {
  26.         //保存员工信息
  27.         employeeService.saveEmployee(employee);
  28.         //跳转到员工列表
  29.         return "redirect:/emplistpage";
  30.     }
  32.     /**
  33.      * 新增员工
  34.      * @param map
  35.      * @return
  36.      */
  37.     @RequestMapping("/empadd")
  38.     public String empadd(Map<String, Object> map) {
  39.         //放置空的employee
  40.         map.put("employee", new Employee());
  41.         //所有员工
  42.         map.put("employees", employeeService.getAll());
  43.         //所有部门
  44.         map.put("depts", deptService.getAll());
  46.         return "employee/edit";
  47.     }
  1. /**
  2.      * 模板方法
  3.      * @param id
  4.      * @param map
  5.      */
  6.     @ModelAttribute
  7.     public void getEmployee(@RequestParam(value="id",required=false)Integer id,Map<String, Object> map) {
  8.         if(id != null) {
  9.             Employee employee = employeeService.getEmployee(id);
  10.             employee.setDept(null);
  11.             map.put("employee", employee);
  12.         }
  13.     }

jsp页面

  1. <div class="container">
  2.         <!-- 路径导航 -->
  3.         <ol class="breadcrumb">
  4.           <li><a href="<%=path %>">首页</a></li>
  5.           <li><a href="<%=path %>/emplistpage">员工列表</a></li>
  6.           <li class="active">员工信息编辑</li>
  7.         </ol>
  9.         <h3>员工信息</h3>
  10.         <form:form action="${pageContext.request.contextPath }/empsave" method="POST" modelAttribute="employee" >
  11.           <div class="form-group">
  12.             <label for="">序号：</label>
  13.             <input class="form-control" name="id" value="${employee.id }" readonly="readonly">
  14.           </div>
  15.           <div class="form-group">
  16.             <label for="">姓名</label>
  17.             <form:input class="form-control" path="name" placeholder="姓名" />
  18.           </div>
  19.           <div class="form-group">
  20.             <label for="">电子邮箱</label>
  21.             <form:input class="form-control" path="email" placeholder="电子邮箱" />
  22.           </div>
  23.           <div class="form-group">
  24.             <label for="">出生日期</label>
  25.             <input type="date" class="form-control" name="birth" value="${employee.birth }" data-date-format="YYYY-MM-DD"/>
  26.           </div>
  27.           <div class="form-group">
  28.             <label for="">进入公司时间</label>
  29.             <input type="date" class="form-control" name="entryTime" value="${employee.entryTime }" data-date-format="YYYY-MM-DD"/>
  30.           </div>
  31.           <div class="form-group">
  32.             <label for="">直接主管</label>
  33.             <form:select class="form-control" path="supervisor.id" items="${employees }" itemLabel="name" itemValue="id"></form:select>
  34.           </div>
  35.           <div class="form-group">
  36.             <label for="">薪水</label>
  37.             <form:input class="form-control" path="salary"/>
  38.           </div>
  39.           <div class="form-group">
  40.             <label for="">所属部门</label>
  41.             <form:select class="form-control" path="dept.id" items="${depts }" itemLabel="deptName" itemValue="id"></form:select>
  42.           </div>
  44.           <button type="submit" class="btn btn-default">Submit</button>
  45.         </form:form>
  46.     </div>

2.删除员工的处理

删除员工通过JavaScript来实现，在于员工列表同一个页面

service层

  1. /**
  2.      * 删除员工
  3.      * @param id
  4.      */
  5.     @Transactional(readOnly = false)
  6.     public void deleteEmployee(Integer id) {
  7.         employeeRepository.delete(id);
  8.     }

Controller层

  1. /**
  2.      * 员工删除
  3.      * @param id
  4.      * @return
  5.      */
  6.     @ResponseBody
  7.     @RequestMapping(value="/empdel/{id}",method=RequestMethod.POST)
  8.     public String empdel(@PathVariable("id")Integer id) {
  9.         if(id != null) {
  10.             employeeService.deleteEmployee(id);
  11.             //成功
  12.             return "1";
  13.         }
  14.         //失败
  15.         return "0";
  16.     }

jsp页面

  1. <!-- deleteModal删除模块 -->
  2.     <div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  3.       <div class="modal-dialog" role="document">
  4.         <div class="modal-content">
  5.           <div class="modal-header">
  6.             <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  7.             <h4 class="modal-title" id="myModalLabel">删除确认</h4>
  8.           </div>
  9.           <div class="modal-body">
  10.                 <h4 id="deleteText"></h4>
  11.           </div>
  12.           <div class="modal-footer">
  13.             <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  14.             <button type="button" class="btn btn-danger" id="delbutton" >删除</button>
  15.           </div>
  16.         </div>
  17.       </div>
  18.     </div>
  20.     <!-- jQuery (Bootstrap 的所有 JavaScript 插件都依赖 jQuery，所以必须放在前边) -->
  21.     <script src="<%=path %>/jquery/jquery-3.5.1.min.js"></script>
  22.     <!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->
  23.     <script src="<%=path %>/bootstrap/bootstrap.min.js"></script>
  25.     <script type="text/javascript">
  26.         //显示名称
  27.         $('#deleteModal').on('show.bs.modal', function (event) {
  28.           var button = $(event.relatedTarget);
  29.           var name = button.data('name');
  30.           var id = button.data('id');
  31.           var modal = $(this);
  32.           modal.find('#deleteText').text("真的要删除"+name+"吗？");
  34.           //删除事件
  35.           $("#delbutton").click(function (){
  36.                 var url = "${pageContext.request.contextPath }/empdel/"+id;
  37.                 var args = {"date":new Date()};
  38.                 $.post(url,args,function (data){
  39.                     if(data == "1"){
  40.                         modal.find('#deleteText').text("删除成功,2秒后页面自动刷新");
  41.                         setTimeout(function(){
  42.                             window.location.reload();//2秒刷新当前页面.
  43.                             },2000)
  44.                     }else{
  45.                         modal.find('#deleteText').text("删除失败,请稍后再试");
  46.                     }
  47.                 });
  48.           });
  50.         });
  51.     </script>

 

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: