| | |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | |
| | | <mapper namespace="com.yeshi.fanli.dao.mybatis.common.JumpDetailV2Mapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.yeshi.fanli.entity.common.JumpDetailV2"> |
| | | <id column="jp_id" property="id" jdbcType="BIGINT"/> |
| | | <result column="jp_name" property="name" jdbcType="VARCHAR"/> |
| | | <result column="jp_activity" property="activity" jdbcType="VARCHAR"/> |
| | | <result column="jp_controller" property="controller" jdbcType="VARCHAR"/> |
| | | <result column="jp_type" property="type" jdbcType="VARCHAR"/> |
| | | </resultMap> |
| | | |
| | | <sql id="Base_Column_List">jp_id,jp_name,jp_activity,jp_controller,jp_type</sql> |
| | | |
| | | <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long">select |
| | | <include refid="Base_Column_List"/>from yeshi_ec_action_jumpdetail_v2 where jp_id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from yeshi_ec_action_jumpdetail_v2 where jp_id = #{id,jdbcType=BIGINT}</delete> |
| | | |
| | | <insert id="insert" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_action_jumpdetail_v2 (jp_id,jp_name,jp_activity,jp_controller,jp_type) values (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{activity,jdbcType=VARCHAR},#{controller,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR})</insert> |
| | | |
| | | <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_action_jumpdetail_v2 |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">jp_id,</if> |
| | | <if test="name != null">jp_name,</if> |
| | | <if test="activity != null">jp_activity,</if> |
| | | <if test="controller != null">jp_controller,</if> |
| | | <if test="type != null">jp_type,</if> |
| | | </trim>values |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id,jdbcType=BIGINT},</if> |
| | | <if test="name != null">#{name,jdbcType=VARCHAR},</if> |
| | | <if test="activity != null">#{activity,jdbcType=VARCHAR},</if> |
| | | <if test="controller != null">#{controller,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">#{type,jdbcType=VARCHAR},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2">update yeshi_ec_action_jumpdetail_v2 set jp_name = #{name,jdbcType=VARCHAR},jp_activity = #{activity,jdbcType=VARCHAR},jp_controller = #{controller,jdbcType=VARCHAR},jp_type = #{type,jdbcType=VARCHAR} where jp_id = #{id,jdbcType=BIGINT}</update> |
| | | |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2">update yeshi_ec_action_jumpdetail_v2 |
| | | <set> |
| | | <if test="name != null">jp_name=#{name,jdbcType=VARCHAR},</if> |
| | | <if test="activity != null">jp_activity=#{activity,jdbcType=VARCHAR},</if> |
| | | <if test="controller != null">jp_controller=#{controller,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">jp_type=#{type,jdbcType=VARCHAR},</if> |
| | | </set> where jp_id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | |
| | | <select id="listByType" resultMap="BaseResultMap"> |
| | | select <include refid="Base_Column_List"/> from yeshi_ec_action_jumpdetail_v2 |
| | | where jp_type = #{type,jdbcType=VARCHAR} |
| | | </select> |
| | | |
| | | <select id="listJump" resultMap="BaseResultMap"> |
| | | 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> |
| | | <resultMap id="BaseResultMap" type="com.yeshi.fanli.entity.common.JumpDetailV2"> |
| | | <id column="jp_id" property="id" jdbcType="BIGINT" /> |
| | | <result column="jp_name" property="name" jdbcType="VARCHAR" /> |
| | | <result column="jp_activity" property="activity" jdbcType="VARCHAR" /> |
| | | <result column="jp_controller" property="controller" jdbcType="VARCHAR" /> |
| | | <result column="jp_type" property="type" jdbcType="VARCHAR" /> |
| | | <result column="jp_need_login" property="needLogin" jdbcType="BOOLEAN" /> |
| | | </resultMap> |
| | | |
| | | <sql id="Base_Column_List">jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login |
| | | </sql> |
| | | |
| | | <select id="selectByPrimaryKey" resultMap="BaseResultMap" |
| | | parameterType="java.lang.Long"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from yeshi_ec_action_jumpdetail_v2 where jp_id = #{id,jdbcType=BIGINT} |
| | | </select> |
| | | |
| | | <delete id="deleteBatchByPrimaryKey" parameterType="java.util.List"> |
| | | |
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from |
| | | yeshi_ec_action_jumpdetail_v2 where jp_id = #{id,jdbcType=BIGINT} |
| | | </delete> |
| | | |
| | | <insert id="insert" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2" |
| | | useGeneratedKeys="true" keyProperty="id">insert into |
| | | yeshi_ec_action_jumpdetail_v2 |
| | | (jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login) values |
| | | (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{activity,jdbcType=VARCHAR},#{controller,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR},#{needLogin,jdbcType=BOOLEAN}) |
| | | </insert> |
| | | |
| | | <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2" |
| | | useGeneratedKeys="true" keyProperty="id"> |
| | | insert into yeshi_ec_action_jumpdetail_v2 |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">jp_id,</if> |
| | | <if test="name != null">jp_name,</if> |
| | | <if test="activity != null">jp_activity,</if> |
| | | <if test="controller != null">jp_controller,</if> |
| | | <if test="type != null">jp_type,</if> |
| | | <if test="needLogin != null">jp_need_login,</if> |
| | | </trim> |
| | | values |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id,jdbcType=BIGINT},</if> |
| | | <if test="name != null">#{name,jdbcType=VARCHAR},</if> |
| | | <if test="activity != null">#{activity,jdbcType=VARCHAR},</if> |
| | | <if test="controller != null">#{controller,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">#{type,jdbcType=VARCHAR},</if> |
| | | <if test="needLogin != null">#{jp_need_login,jdbcType=BOOLEAN},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2">update |
| | | yeshi_ec_action_jumpdetail_v2 set jp_name = |
| | | #{name,jdbcType=VARCHAR},jp_activity = |
| | | #{activity,jdbcType=VARCHAR},jp_controller = |
| | | #{controller,jdbcType=VARCHAR},jp_type = |
| | | #{type,jdbcType=VARCHAR},jp_need_login = #{needLogin,jdbcType=BOOLEAN} |
| | | where jp_id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2"> |
| | | update yeshi_ec_action_jumpdetail_v2 |
| | | <set> |
| | | <if test="name != null">jp_name=#{name,jdbcType=VARCHAR},</if> |
| | | <if test="activity != null">jp_activity=#{activity,jdbcType=VARCHAR},</if> |
| | | <if test="controller != null">jp_controller=#{controller,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">jp_type=#{type,jdbcType=VARCHAR},</if> |
| | | <if test="needLogin != null">jp_need_login=#{needLogin,jdbcType=BOOLEAN},</if> |
| | | </set> |
| | | where jp_id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | |
| | | <select id="listByType" resultMap="BaseResultMap"> |
| | | select |
| | | <include refid="Base_Column_List" /> |
| | | from yeshi_ec_action_jumpdetail_v2 |
| | | where jp_type = |
| | | #{type,jdbcType=VARCHAR} |
| | | </select> |
| | | |
| | | <select id="listJump" resultMap="BaseResultMap"> |
| | | 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> |
| | | </delete> |
| | | </mapper> |