crud

?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
<mapper namespace="com.sunsoft.service.admin.dao.VipUserFansDao" >
  <resultMap id="BaseResultMap" type="com.sunsoft.sys.entity.VipUserFans" >
    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="user_id" property="userId" jdbcType="VARCHAR" />
    <result column="fans_id" property="fansId" jdbcType="VARCHAR" />
    <result column="invite_time" property="inviteTime" jdbcType="TIMESTAMP" />
  </resultMap>
  <sql id="Base_Column_List" >
    id, user_id, fans_id, invite_time
  </sql>

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from vip_user_fans
    where id = #{id,jdbcType=VARCHAR}
  </select>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from vip_user_fans
    where id = #{id,jdbcType=VARCHAR}
  </delete>

 /**
     * 插入，空属性也会插入
     * 参数:pojo对象
     * 返回:删除个数
     * @author: lying
     * @time: 2018-10-17 13:16:03
     */
  <insert id="insert" parameterType="com.sunsoft.sys.entity.VipUserFans" >
    insert into vip_user_fans (id, user_id, fans_id, 
      invite_time)
    values (#{id,jdbcType=VARCHAR}, #{userId,jdbcType=VARCHAR}, #{fansId,jdbcType=VARCHAR}, 
      #{inviteTime,jdbcType=TIMESTAMP})
  </insert>

 /**
     * 插入，空属性不会插入
     * 参数:pojo对象
     * 返回:删除个数
     * @author: lying
     * @time: 2018-10-17 13:16:03
     */
  <insert id="insertSelective" parameterType="com.sunsoft.sys.entity.VipUserFans" >
    insert into vip_user_fans
    <trim prefix="(" suffix=")" suffixOverrides="," >
      id,
      user_id,
      fans_id,
      invite_time,
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      #{id,jdbcType=VARCHAR},
      #{userId,jdbcType=VARCHAR},
      #{fansId,jdbcType=VARCHAR},
      #{inviteTime,jdbcType=TIMESTAMP},
    </trim>
  </insert>

 /**
     * 根据主键修改，空值条件不会修改成null
     * 参数:1.要修改成的值
     * 返回:成功修改个数
     * @author: lying
     * @time: 2018-10-17 13:16:03
     */
  <update id="updateByPrimaryKeySelective" parameterType="com.sunsoft.sys.entity.VipUserFans" >
    update vip_user_fans
    <set >
      <if test="userId != null" >
        user_id = #{userId,jdbcType=VARCHAR},
      </if>
      <if test="fansId != null" >
        fans_id = #{fansId,jdbcType=VARCHAR},
      </if>
      <if test="inviteTime != null" >
        invite_time = #{inviteTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    where id = #{id,jdbcType=VARCHAR}
  </update>

 /**
     * 根据主键修改，空值条件会修改成null
     * 参数:1.要修改成的值
     * 返回:成功修改个数
     * @author: lying
     * @time: 2018-10-17 13:16:03
     */
  <update id="updateByPrimaryKey" parameterType="com.sunsoft.sys.entity.VipUserFans" >
    update vip_user_fans
    set user_id = #{userId,jdbcType=VARCHAR},
      fans_id = #{fansId,jdbcType=VARCHAR},
      invite_time = #{inviteTime,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=VARCHAR}
  </update>