校验页面输入的数据在数据库中是否存在

一、在页面中国保留原来的值，跟修改之后的做比较

     1、要校验的字段

<div class="form-group"> <div class="row"> <div class="col-sm-12"> <label class="col-sm-3 control-label">分类名称</label> <div class="col-sm-6"> <input type="text" name="name" id="name" value="${courseClassify.name}" class="form-control" maxlength="200" placeholder="请输入" /> </div> </div> </div> </div>

      2、原来的值

<input type="hidden" id="oldName" value="${courseClassify.name}">

   3、使用validate进行校验

$("#inputForm").validate({ rules: { name:{ remote: { type: "get", dataType: "json", url: "${base}/admin/course_classify/check_name.jhtml", data: { name: function () { return $("#name").val(); }, oldname:function () { return $("#oldName").attr(); }, } } } }, messages: { name:{ remote: "该分类名称已经存在" }} } );

    4、controller处理

/** * 检查分类名称是否存在 */ @RequestMapping(value = "/check_name", method = {RequestMethod.GET}) @ResponseBody public boolean checkAccount(String name,String oldname) { if(oldname != null){ if (StringUtils.isEmpty(name)) { return true; } if (StringUtils.isEmpty(oldname)) { return true; } if (name.equals(oldname)) { return true; } } Long count = this.courseClassifyService.count(Paramap.create().put("name", name)); if (null != count && count > 0) { return false; } else { return true; } }

二、在前端直接把id值携带到controller层，在根据id排除数据本身       

        1、验证的字段

<div class="form-group"> <div class="row"> <div class="col-sm-12"> <label class="col-sm-3 control-label">手机号</label> <div class="col-sm-6"> <input type="text" name="phone" id="phone" data-id="${appUser.id}" value="${appUser.phone}" class="form-control" required maxlength="200" oninput = "value=value.replace(/1[34578]\\d{9}/g,'')"/> </div> </div> </div> </div>

      2、获取id

<input type="hidden" value="${appUser.id}" name="id" id="userId"/>

      3、ajax传值

rules: { phone: { remote: { type: "get", dataType: "json", url: "${base}/admin/app_user/check_phone.jhtml", data: { phone: function () { return $("#phone").val(); }, userId: function () { return $("#userId").val(); }, } } } }, messages: { phone: { required: "请输入账号", maxlength: "账号最多11个字符", remote: "账号已经存在" } }

        4、controller层处理    

/** * 检查手机号是否存在 */ @RequestMapping(value = "/check_phone", method = {RequestMethod.GET}) @ResponseBody public boolean checkAccount(String phone,Long userId) { Long count=null; if (userId != null){//编辑 count = this.appUserService.countAppUser(phone,userId); }else if(userId==null) { count = this.appUserService.count(Paramap.create().put("phone", phone)); } if (null != count && count > 0) { return false; } else { return true; } }

        5、除去数据本身，来进行比较 

SELECT COUNT(*) FROM t_app_user WHERE phone=#{phone} AND id NOT IN (#{id})