后台 跳转参数设置2

Administrator

2018-11-16 51487fb73d81a57eb7ed3ed597e3ee0bb9c15387

后台 跳转参数设置2

 fanli/src/main/java/com/yeshi/fanli/mapping/common/JumpDetailV2Mapper.xml

@@ -58,4 +58,27 @@
      select <include refid="Base_Column_List"/> from yeshi_ec_action_jumpdetail_v2 
  </select>
  
   <select id="listQuery" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" />  FROM yeshi_ec_action_jumpdetail_v2
        WHERE 1=1
           <if test='key != null and key != ""'>
                  AND (jp_name like '%${key}%') 
           </if>
           ORDER BY jp_id 
        LIMIT ${start},${count}
   </select>
   
   <select id="countListQuery" resultType="java.lang.Long">
        SELECT IFNULL(count(jp_id),0)  FROM yeshi_ec_action_jumpdetail_v2 
        WHERE 1=1
           <if test='key != null and key != ""'>
                  AND (jp_name like '%${key}%') 
           </if>
    </select>
  	
      <delete id="deleteBatchByPrimaryKey" parameterType="java.util.List">
        delete from yeshi_ec_action_jumpdetail_v2 WHERE jp_id in
        <foreach collection="list" item="item" open="(" close=")"
            separator=",">#{item}</foreach>
    </delete>
</mapper>