SSM 增删改查代码规范

1.增加 ：Body Form-Data格式 直接用POJO对象Doorlock

  URL:    /addLock

----------------------------------Controller层----------------------------------------
addLockC(Doorlock doorlock)

----------------Service层: 判断设备id，判断 设备是否已存在，防止重复添加------------------
if(StringUitl.isEmpty(locknum)){
      return   2:lockNum不得为空
}else{
     doorlock=mapper.selectById(lockNum);

     if(doorlock.isEmpty(doorlock)){
         mapper.insert(doorlock);  //逆向工程默认的insert方法

        return 1:新增成功
     }
        return 3:锁已存在
}

--------------Mapper 层：--------------------------------------------------------
<insert id="insert" parameterType="com.kexin.common.pojo.Doorlock" >
    insert into doorlock  ......

    2.删除:JSON 格式请求参数   ids[0]=28495&ids[1]=28496

     URL:  /deleteLock  删除单个

          

     URL:  /deleteLocks 批量删除

----------------------------------Controller层----------------------------------------
deleteC(@RequestBody String ids)  //vue.js 序列化问题

----------------Service层: 判断设备id，判断 设备是否已存在，防止重复添加------------------
String xxx= URLDecoder.decode(ids,"UTF-8");
            List list = HttpUtil.decoderIds(xxx);  //变为id数组
            int i = doorlockMapper.deleteLocks(list); //批量删除

--------------Mapper 层：--------------------------------------------------------
<delete id="deleteLocks" parameterType="java.util.List">
    delete from  doorlock where id in
    <foreach collection="list" item="id" separator="," open="(" close=")">
      #{id}
    </foreach>
 </delete>

3.修改

 

4.查询:   /selectLocks       
    查一个，查多个都可以用这个接口

----------------------------------Controller层----------------------------------------
 selectLocksC(@RequestParam Map map)  // map 采用动态参数sql

----------------Service层: 判断设备id，判断 设备是否已存在，防止重复添加------------------
selectLocksS(Map map){

   Page<Object> page = PageHelper.startPage(Integer.valueOf((String) map.get("currentPage")), Integer.valueOf((String) map.get("pageSize")));

  List<Doorlock> list = doorlockMapper.selectLocks(map); //如果查询数据为0条，那么list不是null，size==0

--------------Mapper 层：--------------------------------------------------------
动态sql 查询
 <select id="selectLocks" resultMap="BaseResultMap">
    select *  from doorlock

    <trim prefix="where" suffixOverrides="and">

      <if test="lockName!=null and lockName!=''" >
        lock_name  like  '%${lockName}%'   and
      </if>
      <if test="lockNum!=null and lockNum!=''" >
        lock_num  like  '%${lockNum}%'   and
      </if>
      <if test="installState!=null and installState!=''" >
        install_state=#{installState} and
      </if>