<? xml version="1.0" encoding="UTF-8" ? >
<! DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.youmeek.ssm.manage.mapper. SysUserMapper" >
  <resultMap id="BaseResultMap" type="com.youmeek.ssm.manage.pojo. SysUser" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    <id column="`sys_user_id`" property="sysUserId" jdbcType="BIGINT" />
    <result column="`sys_user_login_name`" property="sysUserLoginName" jdbcType="VARCHAR" />
    <result column="`sys_user_login_password`" property="sysUserLoginPassword" jdbcType="VARCHAR" />
    <result column="`sys_user_status`" property="sysUserStatus" jdbcType="VARCHAR" />
    <result column="`sys_user_is_delete`" property="sysUserIsDelete" jdbcType="VARCHAR" />
    <result column="`sys_user_register_datetime`" property="sysUserRegisterDatetime" jdbcType="TIMESTAMP" />
    <result column="`sys_user_register_source`" property="sysUserRegisterSource" jdbcType="VARCHAR" />
    <result column="`sys_user_type`" property="sysUserType" jdbcType="VARCHAR" />
    <result column="`sys_user_sex`" property="sysUserSex" jdbcType="VARCHAR" />
    <result column="`sys_user_is_email_active`" property="sysUserIsEmailActive" jdbcType="VARCHAR" />
    <result column="`sys_user_is_mobile_active`" property="sysUserIsMobileActive" jdbcType="VARCHAR" />
    <result column="`sys_user_register_type`" property="sysUserRegisterType" jdbcType="VARCHAR" />
    <result column="`sys_user_pay_passwrod`" property="sysUserPayPasswrod" jdbcType="VARCHAR" />
    <result column="`sys_user_icon`" property="sysUserIcon" jdbcType="VARCHAR" />
    <result column="`sys_user_real_name`" property="sysUserRealName" jdbcType="VARCHAR" />
    <result column="`sys_user_email`" property="sysUserEmail" jdbcType="VARCHAR" />
    <result column="`sys_user_mobile`" property="sysUserMobile" jdbcType="VARCHAR" />
    <result column="`sys_user_weibo_id`" property="sysUserWeiboId" jdbcType="VARCHAR" />
    <result column="`sys_user_qq_id`" property="sysUserQqId" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    `sys_user_id`, `sys_user_login_name`, `sys_user_login_password`, `sys_user_status`, 
    `sys_user_is_delete`, `sys_user_register_datetime`, `sys_user_register_source`, `sys_user_type`, 
    `sys_user_sex`, `sys_user_is_email_active`, `sys_user_is_mobile_active`, `sys_user_register_type`, 
    `sys_user_pay_passwrod`, `sys_user_icon`, `sys_user_real_name`, `sys_user_email`, 
    `sys_user_mobile`, `sys_user_weibo_id`, `sys_user_qq_id`
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang. Long" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    select 
    <include refid="Base_Column_List" />
    from sys_user
    where `sys_user_id` = #{sysUserId,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang. Long" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    delete from sys_user
    where `sys_user_id` = #{sysUserId,jdbcType=BIGINT}
  </delete>
  <insert id="insert" parameterType="com.youmeek.ssm.manage.pojo. SysUser" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    insert into sys_user (`sys_user_id`, `sys_user_login_name`, `sys_user_login_password`, 
      `sys_user_status`, `sys_user_is_delete`, `sys_user_register_datetime`, 
      `sys_user_register_source`, `sys_user_type`, `sys_user_sex`, 
      `sys_user_is_email_active`, `sys_user_is_mobile_active`, 
      `sys_user_register_type`, `sys_user_pay_passwrod`, 
      `sys_user_icon`, `sys_user_real_name`, `sys_user_email`, 
      `sys_user_mobile`, `sys_user_weibo_id`, `sys_user_qq_id`
      )
    values (#{sysUserId,jdbcType=BIGINT}, #{sysUserLoginName,jdbcType=VARCHAR}, #{sysUserLoginPassword,jdbcType=VARCHAR}, 
      #{sysUserStatus,jdbcType=VARCHAR}, #{sysUserIsDelete,jdbcType=VARCHAR}, #{sysUserRegisterDatetime,jdbcType=TIMESTAMP}, 
      #{sysUserRegisterSource,jdbcType=VARCHAR}, #{sysUserType,jdbcType=VARCHAR}, #{sysUserSex,jdbcType=VARCHAR}, 
      #{sysUserIsEmailActive,jdbcType=VARCHAR}, #{sysUserIsMobileActive,jdbcType=VARCHAR}, 
      #{sysUserRegisterType,jdbcType=VARCHAR}, #{sysUserPayPasswrod,jdbcType=VARCHAR}, 
      #{sysUserIcon,jdbcType=VARCHAR}, #{sysUserRealName,jdbcType=VARCHAR}, #{sysUserEmail,jdbcType=VARCHAR}, 
      #{sysUserMobile,jdbcType=VARCHAR}, #{sysUserWeiboId,jdbcType=VARCHAR}, #{sysUserQqId,jdbcType=VARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.youmeek.ssm.manage.pojo. SysUser" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    insert into sys_user
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="sysUserId ! = null" >
        `sys_user_id`,
      </if>
      <if test="sysUserLoginName ! = null" >
        `sys_user_login_name`,
      </if>
      <if test="sysUserLoginPassword ! = null" >
        `sys_user_login_password`,
      </if>
      <if test="sysUserStatus ! = null" >
        `sys_user_status`,
      </if>
      <if test="sysUserIsDelete ! = null" >
        `sys_user_is_delete`,
      </if>
      <if test="sysUserRegisterDatetime ! = null" >
        `sys_user_register_datetime`,
      </if>
      <if test="sysUserRegisterSource ! = null" >
        `sys_user_register_source`,
      </if>
      <if test="sysUserType ! = null" >
        `sys_user_type`,
      </if>
      <if test="sysUserSex ! = null" >
        `sys_user_sex`,
      </if>
      <if test="sysUserIsEmailActive ! = null" >
        `sys_user_is_email_active`,
      </if>
      <if test="sysUserIsMobileActive ! = null" >
        `sys_user_is_mobile_active`,
      </if>
      <if test="sysUserRegisterType ! = null" >
        `sys_user_register_type`,
      </if>
      <if test="sysUserPayPasswrod ! = null" >
        `sys_user_pay_passwrod`,
      </if>
      <if test="sysUserIcon ! = null" >
        `sys_user_icon`,
      </if>
      <if test="sysUserRealName ! = null" >
        `sys_user_real_name`,
      </if>
      <if test="sysUserEmail ! = null" >
        `sys_user_email`,
      </if>
      <if test="sysUserMobile ! = null" >
        `sys_user_mobile`,
      </if>
      <if test="sysUserWeiboId ! = null" >
        `sys_user_weibo_id`,
      </if>
      <if test="sysUserQqId ! = null" >
        `sys_user_qq_id`,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="sysUserId ! = null" >
        #{sysUserId,jdbcType=BIGINT},
      </if>
      <if test="sysUserLoginName ! = null" >
        #{sysUserLoginName,jdbcType=VARCHAR},
      </if>
      <if test="sysUserLoginPassword ! = null" >
        #{sysUserLoginPassword,jdbcType=VARCHAR},
      </if>
      <if test="sysUserStatus ! = null" >
        #{sysUserStatus,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsDelete ! = null" >
        #{sysUserIsDelete,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRegisterDatetime ! = null" >
        #{sysUserRegisterDatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="sysUserRegisterSource ! = null" >
        #{sysUserRegisterSource,jdbcType=VARCHAR},
      </if>
      <if test="sysUserType ! = null" >
        #{sysUserType,jdbcType=VARCHAR},
      </if>
      <if test="sysUserSex ! = null" >
        #{sysUserSex,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsEmailActive ! = null" >
        #{sysUserIsEmailActive,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsMobileActive ! = null" >
        #{sysUserIsMobileActive,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRegisterType ! = null" >
        #{sysUserRegisterType,jdbcType=VARCHAR},
      </if>
      <if test="sysUserPayPasswrod ! = null" >
        #{sysUserPayPasswrod,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIcon ! = null" >
        #{sysUserIcon,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRealName ! = null" >
        #{sysUserRealName,jdbcType=VARCHAR},
      </if>
      <if test="sysUserEmail ! = null" >
        #{sysUserEmail,jdbcType=VARCHAR},
      </if>
      <if test="sysUserMobile ! = null" >
        #{sysUserMobile,jdbcType=VARCHAR},
      </if>
      <if test="sysUserWeiboId ! = null" >
        #{sysUserWeiboId,jdbcType=VARCHAR},
      </if>
      <if test="sysUserQqId ! = null" >
        #{sysUserQqId,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.youmeek.ssm.manage.pojo. SysUser" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    update sys_user
    <set >
      <if test="sysUserLoginName ! = null" >
        `sys_user_login_name` = #{sysUserLoginName,jdbcType=VARCHAR},
      </if>
      <if test="sysUserLoginPassword ! = null" >
        `sys_user_login_password` = #{sysUserLoginPassword,jdbcType=VARCHAR},
      </if>
      <if test="sysUserStatus ! = null" >
        `sys_user_status` = #{sysUserStatus,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsDelete ! = null" >
        `sys_user_is_delete` = #{sysUserIsDelete,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRegisterDatetime ! = null" >
        `sys_user_register_datetime` = #{sysUserRegisterDatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="sysUserRegisterSource ! = null" >
        `sys_user_register_source` = #{sysUserRegisterSource,jdbcType=VARCHAR},
      </if>
      <if test="sysUserType ! = null" >
        `sys_user_type` = #{sysUserType,jdbcType=VARCHAR},
      </if>
      <if test="sysUserSex ! = null" >
        `sys_user_sex` = #{sysUserSex,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsEmailActive ! = null" >
        `sys_user_is_email_active` = #{sysUserIsEmailActive,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIsMobileActive ! = null" >
        `sys_user_is_mobile_active` = #{sysUserIsMobileActive,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRegisterType ! = null" >
        `sys_user_register_type` = #{sysUserRegisterType,jdbcType=VARCHAR},
      </if>
      <if test="sysUserPayPasswrod ! = null" >
        `sys_user_pay_passwrod` = #{sysUserPayPasswrod,jdbcType=VARCHAR},
      </if>
      <if test="sysUserIcon ! = null" >
        `sys_user_icon` = #{sysUserIcon,jdbcType=VARCHAR},
      </if>
      <if test="sysUserRealName ! = null" >
        `sys_user_real_name` = #{sysUserRealName,jdbcType=VARCHAR},
      </if>
      <if test="sysUserEmail ! = null" >
        `sys_user_email` = #{sysUserEmail,jdbcType=VARCHAR},
      </if>
      <if test="sysUserMobile ! = null" >
        `sys_user_mobile` = #{sysUserMobile,jdbcType=VARCHAR},
      </if>
      <if test="sysUserWeiboId ! = null" >
        `sys_user_weibo_id` = #{sysUserWeiboId,jdbcType=VARCHAR},
      </if>
      <if test="sysUserQqId ! = null" >
        `sys_user_qq_id` = #{sysUserQqId,jdbcType=VARCHAR},
      </if>
    </set>
    where `sys_user_id` = #{sysUserId,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.youmeek.ssm.manage.pojo. SysUser" >
    <!-- 
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify. 
    -->
    update sys_user
    set `sys_user_login_name` = #{sysUserLoginName,jdbcType=VARCHAR},
      `sys_user_login_password` = #{sysUserLoginPassword,jdbcType=VARCHAR},
      `sys_user_status` = #{sysUserStatus,jdbcType=VARCHAR},
      `sys_user_is_delete` = #{sysUserIsDelete,jdbcType=VARCHAR},
      `sys_user_register_datetime` = #{sysUserRegisterDatetime,jdbcType=TIMESTAMP},
      `sys_user_register_source` = #{sysUserRegisterSource,jdbcType=VARCHAR},
      `sys_user_type` = #{sysUserType,jdbcType=VARCHAR},
      `sys_user_sex` = #{sysUserSex,jdbcType=VARCHAR},
      `sys_user_is_email_active` = #{sysUserIsEmailActive,jdbcType=VARCHAR},
      `sys_user_is_mobile_active` = #{sysUserIsMobileActive,jdbcType=VARCHAR},
      `sys_user_register_type` = #{sysUserRegisterType,jdbcType=VARCHAR},
      `sys_user_pay_passwrod` = #{sysUserPayPasswrod,jdbcType=VARCHAR},
      `sys_user_icon` = #{sysUserIcon,jdbcType=VARCHAR},
      `sys_user_real_name` = #{sysUserRealName,jdbcType=VARCHAR},
      `sys_user_email` = #{sysUserEmail,jdbcType=VARCHAR},
      `sys_user_mobile` = #{sysUserMobile,jdbcType=VARCHAR},
      `sys_user_weibo_id` = #{sysUserWeiboId,jdbcType=VARCHAR},
      `sys_user_qq_id` = #{sysUserQqId,jdbcType=VARCHAR}
    where `sys_user_id` = #{sysUserId,jdbcType=BIGINT}
  </update>
</mapper>