局部刷新（数据库查询是否存在该信息）

局部刷新（数据库中查询是否存在该信息）

图片：

代码实现

html

<tr>
  <td>分类名</td>
  <td>
      <input type="text" onblur="catecheck()"  placeholder="请输入分类名" class="form-control" name="catename" id="catename">
  </td>
</tr>
<link href="css/bootstrap.min.css" rel="stylesheet">

ajax

function catecheck() {
  var catename=document.getElementById("catename").value;
  $.ajax({
            url:"/checkcate",
            data:{"catename":catename},
            success:function (data) {
              if(data=="true"){
                alert("分类已存在，请重新输入");
                document.getElementById("catename").value=" ";
              }
            }
          }
  )
}

后台

实体类（pojo）

package sunjobs81.s81.model.vo;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

/*商品分类*/
public class Cate {
    /*cateid,catename,catestatus*/
    //分类ID
    private Integer cateid;
    //分类名称
    private  String catename;
    //分类状态
    private  Integer catestatus;
    //创建时间
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date catetime;

    public Date getCatetime() {
        return catetime;
    }

    public void setCatetime(Date catetime) {
        this.catetime = catetime;
    }

    public Integer getCateid() {
        return cateid;
    }

    public void setCateid(Integer cateid) {
        this.cateid = cateid;
    }

    public String getCatename() {
        return catename;
    }

    public void setCatename(String catename) {
        this.catename = catename;
    }

    public Integer getCatestatus() {
        return catestatus;
    }

    public void setCatestatus(Integer catestatus) {
        this.catestatus = catestatus;
    }
}

Controller

//通过AJAX判断分类名称是否存在数据库中
@RequestMapping("/checkcate")
@ResponseBody
public String checkcate(String catename, HttpServletResponse response){
    String flag="false";
    //根据分类名去分类服务查询分类信息
    Cate dbcate=cateService.getCateInfoByName(catename);
    //验证该分类名称是否在数据库中已经存在
    if(dbcate!=null){
        if (dbcate.getCatename().equals(catename))
        {
            flag="true";
            return flag;
        }
        return flag;
    }
    //如果查询不到，说明可以添加
    return flag;
}

Service

import sunjobs81.s81.model.vo.Cate;

public interface CateService  {
    Cate getCateInfoByName(String catename);
}

Service Implement

package sunjobs81.s81.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import sunjobs81.s81.model.dao.mapper.CateMapper;
import sunjobs81.s81.model.vo.Cate;
import sunjobs81.s81.service.CateService;

@Service
public class CateServiceimpl implements CateService {
    @Autowired
    CateMapper cateMapper;

    @Override
    public Cate getCateInfoByName(String catename) {
        return cateMapper.getCateInfoByName(catename);
    }
}

Mapping

package sunjobs81.s81.model.dao.mapper;

import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;
import org.springframework.stereotype.Repository;
import sunjobs81.s81.model.vo.Cate;

import java.util.Date;
import java.util.List;

@Repository
@Mapper
public interface CateMapper {
    @Select("select * from cate where catename=#{catename}")
    @Results(
            {
                    @Result(column="cateid",property="cateid",
                            javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                    @Result(column="catename",property="catename"),
                    @Result(column="catestatus",property="catestatus"),
                    @Result(column="catetime",property="catetime",
                            jdbcType = JdbcType.TIMESTAMP,javaType = Date.class)
            }
    )
    Cate getCateInfoByName(String catename);
}