mybatis 一对一 一对多 多对一 多对多

<?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.superr.powerful.progect.user.dao.FornowUserInfoMapper" >
  <resultMap id="BaseResultMap" type="com.superr.powerful.progect.user.entity.FornowUserInfo" >
    <id column="fnuser_id" property="fnuserId" jdbcType="BIGINT" />
    <result column="createDateTime" property="createdatetime" jdbcType="TIMESTAMP" />
    <result column="lastModifyDateTime" property="lastmodifydatetime" jdbcType="TIMESTAMP" />
    <result column="nickname" property="nickname" jdbcType="VARCHAR" />
    <result column="position" property="position" jdbcType="VARCHAR" />
    <result column="sex" property="sex" jdbcType="INTEGER" />
    <result column="status" property="status" jdbcType="INTEGER" />
    <result column="user_id" property="userId" jdbcType="BIGINT" />
    <result column="parent_id" property="parentId" jdbcType="BIGINT" />
    <result column="type" property="type" jdbcType="INTEGER" />
    <result column="is_parent" property="isParent" jdbcType="INTEGER" />
    <result column="userNum" property="usernum" jdbcType="VARCHAR" />
    <result column="createDate" property="createdate" jdbcType="BIGINT" />
    <result column="lastModifyDate" property="lastmodifydate" jdbcType="BIGINT" />
    <result column="version" property="version" jdbcType="INTEGER" />
         < association property="user" javaType="com.superr.powerful.progect.user.entity.User">
             <!-- id:关联查询用户的唯一标识 
                 column:指定唯一标识用户信息的列
                 property:映射到user的那个属性
             -->
              <!--  private User user; -->
             <id column="user_id" property="userId"/>
            <result column="createDateTime" property="createdatetime" jdbcType="TIMESTAMP" />
   <result column="lastModifyDateTime" property="lastmodifydatetime" jdbcType="TIMESTAMP" />
   <result column="email" property="email" jdbcType="VARCHAR" />
   <result column="password" property="password" jdbcType="VARCHAR" />
   <result column="phone" property="phone" jdbcType="VARCHAR" />
   <result column="type" property="type" jdbcType="INTEGER" />
   <result column="username" property="username" jdbcType="VARCHAR" />
   <result column="validDateTime" property="validdatetime" jdbcType="TIMESTAMP" />
   <result column="email_kf" property="emailKf" jdbcType="VARCHAR" />
   <result column="createDate" property="createdate" jdbcType="BIGINT" />
   <result column="lastModifyDate" property="lastmodifydate" jdbcType="BIGINT" />
   <result column="point" property="point" jdbcType="INTEGER" />
   <result column="status" property="status" jdbcType="INTEGER" />
   <result column="roles" property="roles" jdbcType="VARCHAR" />
   <result column="company_id" property="companyId" jdbcType="BIGINT" />
   <result column="dept_id" property="deptId" jdbcType="BIGINT" />
   <result column="birthday_time" property="birthdayTime" jdbcType="VARCHAR" />
   <result column="sex" property="sex" jdbcType="INTEGER" />
   <result column="balance" property="balance" jdbcType="DECIMAL" />
   <result column="ease_name" property="easeName" jdbcType="VARCHAR" />
   <result column="ease_password" property="easePassword" jdbcType="VARCHAR" />
   <result column="age" property="age" jdbcType="INTEGER" />
   <result column="version" property="version" jdbcType="INTEGER" />
   <result column="isfirst" property="isfirst" jdbcType="INTEGER" />
         </association>
         <association property="parentUser" javaType="com.superr.powerful.progect.user.entity.FornowUserInfo">   
            <id column="fnuser_id" property="fnuserId" jdbcType="BIGINT" />
   <result column="createDateTime" property="createdatetime" jdbcType="TIMESTAMP" />
   <result column="lastModifyDateTime" property="lastmodifydatetime" jdbcType="TIMESTAMP" />
   <result column="nickname" property="nickname" jdbcType="VARCHAR" />
   <result column="position" property="position" jdbcType="VARCHAR" />
   <result column="sex" property="sex" jdbcType="INTEGER" />
   <result column="status" property="status" jdbcType="INTEGER" />
   <result column="user_id" property="userId" jdbcType="BIGINT" />
   <result column="parent_id" property="parentId" jdbcType="BIGINT" />
   <result column="type" property="type" jdbcType="INTEGER" />
   <result column="is_parent" property="isParent" jdbcType="INTEGER" />
   <result column="userNum" property="usernum" jdbcType="VARCHAR" />
   <result column="createDate" property="createdate" jdbcType="BIGINT" />
   <result column="lastModifyDate" property="lastmodifydate" jdbcType="BIGINT" />
   <result column="version" property="version" jdbcType="INTEGER" />
         </association>
  </resultMap>
  
  <!-- private List<OrderDetail> orderdetails; -->
  <!--  
  < collection property="orderdetails" ofType="com.mybatis.entity.OrderDetail">
id:唯一标识
property：要将订单明细的唯一标识映射到com.mybatis.entity.OrderDetail的那个属性
 
<id column="orderdetail_id" property="id"/>
<result column="items_id" property="itemsId"/>
<result column="items_num" property="itemsNum"/>
<result column="orders_id" property="ordersId"/>
</collection>
-->
  <sql id="Base_Column_List" >
    fnuser_id, createDateTime, lastModifyDateTime, nickname, position, sex, status, user_id, 
    parent_id, type, is_parent, userNum, createDate, lastModifyDate, version
  </sql>
   <sql id="User_Column_List" >
    user_id, createDateTime, lastModifyDateTime, email, password, phone, type, username, 
    validDateTime, email_kf, createDate, lastModifyDate, point, status, roles, company_id, 
    dept_id, birthday_time, sex, balance, ease_name, ease_password, age, version, isfirst
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
    select 
    <include refid="Base_Column_List" />,
    <include refid="User_Column_List"/>
    from fornow_fnuser f inner join fornow_user u
    on f.user_id=u.user_id 
    where fnuser_id = #{fnuserId,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >
    delete from fornow_fnuser
    where fnuser_id = #{fnuserId,jdbcType=BIGINT}
  </delete>
  <insert id="insert" parameterType="com.superr.powerful.progect.user.entity.FornowUserInfo" >
    insert into fornow_fnuser (fnuser_id, createDateTime, lastModifyDateTime, 
      nickname, position, sex, 
      status, user_id, parent_id, 
      type, is_parent, userNum, 
      createDate, lastModifyDate, version
      )
    values (#{fnuserId,jdbcType=BIGINT}, #{createdatetime,jdbcType=TIMESTAMP}, #{lastmodifydatetime,jdbcType=TIMESTAMP}, 
      #{nickname,jdbcType=VARCHAR}, #{position,jdbcType=VARCHAR}, #{sex,jdbcType=INTEGER}, 
      #{status,jdbcType=INTEGER}, #{userId,jdbcType=BIGINT}, #{parentId,jdbcType=BIGINT}, 
      #{type,jdbcType=INTEGER}, #{isParent,jdbcType=INTEGER}, #{usernum,jdbcType=VARCHAR}, 
      #{createdate,jdbcType=BIGINT}, #{lastmodifydate,jdbcType=BIGINT}, #{version,jdbcType=INTEGER}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.superr.powerful.progect.user.entity.FornowUserInfo" >
    insert into fornow_fnuser
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="fnuserId != null" >
        fnuser_id,
      </if>
      <if test="createdatetime != null" >
        createDateTime,
      </if>
      <if test="lastmodifydatetime != null" >
        lastModifyDateTime,
      </if>
      <if test="nickname != null" >
        nickname,
      </if>
      <if test="position != null" >
        position,
      </if>
      <if test="sex != null" >
        sex,
      </if>
      <if test="status != null" >
        status,
      </if>
      <if test="userId != null" >
        user_id,
      </if>
      <if test="parentId != null" >
        parent_id,
      </if>
      <if test="type != null" >
        type,
      </if>
      <if test="isParent != null" >
        is_parent,
      </if>
      <if test="usernum != null" >
        userNum,
      </if>
      <if test="createdate != null" >
        createDate,
      </if>
      <if test="lastmodifydate != null" >
        lastModifyDate,
      </if>
      <if test="version != null" >
        version,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="fnuserId != null" >
        #{fnuserId,jdbcType=BIGINT},
      </if>
      <if test="createdatetime != null" >
        #{createdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="lastmodifydatetime != null" >
        #{lastmodifydatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="nickname != null" >
        #{nickname,jdbcType=VARCHAR},
      </if>
      <if test="position != null" >
        #{position,jdbcType=VARCHAR},
      </if>
      <if test="sex != null" >
        #{sex,jdbcType=INTEGER},
      </if>
      <if test="status != null" >
        #{status,jdbcType=INTEGER},
      </if>
      <if test="userId != null" >
        #{userId,jdbcType=BIGINT},
      </if>
      <if test="parentId != null" >
        #{parentId,jdbcType=BIGINT},
      </if>
      <if test="type != null" >
        #{type,jdbcType=INTEGER},
      </if>
      <if test="isParent != null" >
        #{isParent,jdbcType=INTEGER},
      </if>
      <if test="usernum != null" >
        #{usernum,jdbcType=VARCHAR},
      </if>
      <if test="createdate != null" >
        #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmodifydate != null" >
        #{lastmodifydate,jdbcType=BIGINT},
      </if>
      <if test="version != null" >
        #{version,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.superr.powerful.progect.user.entity.FornowUserInfo" >
    update fornow_fnuser
    <set >
      <if test="createdatetime != null" >
        createDateTime = #{createdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="lastmodifydatetime != null" >
        lastModifyDateTime = #{lastmodifydatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="nickname != null" >
        nickname = #{nickname,jdbcType=VARCHAR},
      </if>
      <if test="position != null" >
        position = #{position,jdbcType=VARCHAR},
      </if>
      <if test="sex != null" >
        sex = #{sex,jdbcType=INTEGER},
      </if>
      <if test="status != null" >
        status = #{status,jdbcType=INTEGER},
      </if>
      <if test="userId != null" >
        user_id = #{userId,jdbcType=BIGINT},
      </if>
      <if test="parentId != null" >
        parent_id = #{parentId,jdbcType=BIGINT},
      </if>
      <if test="type != null" >
        type = #{type,jdbcType=INTEGER},
      </if>
      <if test="isParent != null" >
        is_parent = #{isParent,jdbcType=INTEGER},
      </if>
      <if test="usernum != null" >
        userNum = #{usernum,jdbcType=VARCHAR},
      </if>
      <if test="createdate != null" >
        createDate = #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmodifydate != null" >
        lastModifyDate = #{lastmodifydate,jdbcType=BIGINT},
      </if>
      <if test="version != null" >
        version = #{version,jdbcType=INTEGER},
      </if>
    </set>
    where fnuser_id = #{fnuserId,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.superr.powerful.progect.user.entity.FornowUserInfo" >
    update fornow_fnuser
    set createDateTime = #{createdatetime,jdbcType=TIMESTAMP},
      lastModifyDateTime = #{lastmodifydatetime,jdbcType=TIMESTAMP},
      nickname = #{nickname,jdbcType=VARCHAR},
      position = #{position,jdbcType=VARCHAR},
      sex = #{sex,jdbcType=INTEGER},
      status = #{status,jdbcType=INTEGER},
      user_id = #{userId,jdbcType=BIGINT},
      parent_id = #{parentId,jdbcType=BIGINT},
      type = #{type,jdbcType=INTEGER},
      is_parent = #{isParent,jdbcType=INTEGER},
      userNum = #{usernum,jdbcType=VARCHAR},
      createDate = #{createdate,jdbcType=BIGINT},
      lastModifyDate = #{lastmodifydate,jdbcType=BIGINT},
      version = #{version,jdbcType=INTEGER}
    where fnuser_id = #{fnuserId,jdbcType=BIGINT}
  </update>
</mapper>