Layui+ssm修改

我会带着你远行 2022-12-05 04:58 23阅读 0赞

用layui+ssm做一个修改功能，修改包括点击事件、获取行数据、绑定数据到form表单中，修改后点击保存执行保存操作

![20200909101701326.png][]

Mapping代码

<update id="updateByPrimaryKey" parameterType="com.mm.po.User">
        update user
        set user_name = #{userName,jdbcType=VARCHAR},
          phone = #{phone,jdbcType=VARCHAR},
          `password` = #{password,jdbcType=VARCHAR},
          register_time = #{registerTime,jdbcType=TIMESTAMP},
          certificate_type_id = #{certificateTypeId,jdbcType=INTEGER},
          certificate_number = #{certificateNumber,jdbcType=VARCHAR},
          sex = #{sex,jdbcType=BIT},
          photo = #{photo,jdbcType=VARCHAR},
          email = #{email,jdbcType=VARCHAR},
          is_valid = #{isValid,jdbcType=BIT}
        where user_id = #{userId,jdbcType=INTEGER}
      </update>

用的是工具生成好的修改语句

Mapper

/**
    	 * 修改
    	 */
    	 int updateByPrimaryKeySelective(User updUser);

Service和mapper一样

Impl代码

@Override
    	public int updateByPrimaryKeySelective(User updUser) {
    		// TODO Auto-generated method stub
    		return this.userDao.updateByPrimaryKeySelective(updUser);
    	}

控制器

@ResponseBody	  
    	  @RequestMapping(value="/updd",produces="application/json;charset=UTF-8")
    	  public Object updateUser(User updUser) { 
    		  JsonReturn jsonReturn=new JsonReturn(); 
    		  int intU=this.iUserService.updateByPrimaryKeySelective(updUser); 
    		  if(intU>0) {
    		  jsonReturn.setCode(200); 
    		  jsonReturn.setText("修改成功"); 
    	  }else {
    		  jsonReturn.setCode(500); 
    		  jsonReturn.setText("修改失败"); 
    	  } 
    		  return   gson.toJson(jsonReturn); 
    		  
    	  }

页面代码

//获取按钮
     		table.on('tool(test)',function(obj){
     			var data=obj.data;//获取当前行事件
     			var tr=obj.tr;//活动当前行tr的DOM事件
     			if(obj.event==='del'){//删除
     				layer.confirm('确定删除吗？',{title:'删除'},function(index){
     					//向服务端发送删除命令og
     					$.post('${ctx}/user/del.do',{
     						userId:data.userId
     					},function(ret){
     						if(ret.code=="200"){
     							layer.close(index);//关闭弹窗
     							layer.msg("删除成功");
     	 						table.reload('demo',{//重载表格
     	 							page:{curr:1}//重新从第一页开始
     	 							}) 		
     						}else{
     							layer.msg("删除失败");
     						}
     					});
     					layer.close(index);
     				})
     			}else if(obj.event==='edit'){//编辑
     				layer.open({
     					type:1//page层类型
     					,skin:'layui-layer-molv'
     					,area:['43%','47%']
    	 				,title:['修改用户信息','font-size:18px']
    	 				,btn:['确定','取消']
    	 				,shadeClose:true
    	 				,shade:0//遮罩透明度
    	 				,maxmin:true//允许全屏最小化
    	 				,content:$("#add-user")//弹窗路径
    	 				,success:function(layero,index){
     					$('#userName').val(data.userName);
     					$('#password').val(data.password);
     					$('#sex').val(data.sex);
     					$('#userTypeId').val(data.userTypeId);
     					$('#userTypeId').trigger('change');
     					$('#nickName').val(data.nickName);
     					$('#phone').val(data.phone);
     					$('#email').val(data.email);
     				},yes:function(index,layero){
     					userId=data.userId;
     					userName=$('#userName').val();
    					password=$('#password').val();
    					sex=$('#sex').val();
    					userTypeId=$('#userTypeId').val();
    					nickName=$('#nickName').val();
    					phone=$('#phone').val();
    					email=$('#email').val();
    					
    					if(userName==null || userName==""){
    						layer.msg("用户名不能为空");
    						return false;
    					}
    					if(password==null || password==""){
    						layer.msg("密码不能为空");
    						return false;
    					}				
     					$.post('${ctx}/user/updd.do',{
     						userId:userId,
     						userName:userName,
    						password:password,
    						sex:sex,
    						userTypeId:userTypeId,
    						nickName:nickName,
    						phone:phone,
    						email:email
     					},function(data){
     						if(data.code=="200"){
     							layer.msg("修改成功");
     							layer.close(index);//关闭弹出层
     							table.reload('demo',{//重载表格
     	              				  page:{
     	              					  curr:1
     	              				  }
     							})
    							//window.location.reload();
    							//layer.msg("修改成功");
     						}else{
     							layer.msg("修改失败");
     						}
     					})
     				  }
     				})
     			}
     		})

![20200909101959465.png][]

因为编辑按钮在表格里，所以用的是layui的监听事件

[20200909101701326.png]: /images/20221123/5ac3f32851744b2d801f688d2ab2e02c.png
[20200909101959465.png]: /images/20221123/a3821003741247ddaccf32c0df9a0d5c.png