<!-- 關(guān)聯(lián)屬性延遲加載 -->
	<select id="queryOrderAndUser" resultMap="orderAndUser">
		select
		o.id oids,o.orderid,o.createtime,o.note,o.userid
		from orders o,t_user u
		where o.userid=u.id
	</select>
	<resultMap type="orders" id="orderAndUser">
		<id property="id" column="oids"></id>
		<result property="orderId" column="orderid"></result>
		<result property="createtime" column="createtime" />
		<result property="note" column="note" />
		<association property="user" javaType="users" 
		select="net.neuedu.mybatis.mapper.UserMapper.queryUserById" column="userid">
			<!-- 
				這里不查詢用戶的信息，而是將用的信息放在另外一個查詢中
				column是order表中的userid字段
			 -->
		</association>
	</resultMap>

 //根據(jù)ID查詢用戶
 public Users queryUserById(Integer id);

 <!-- public Users queryUserById(Integer id); -->
 <select id="queryUserById" parameterType="int" resultType="users">
  select * from t_user where id=#{id}
 </select>

<!-- 查詢時，關(guān)閉關(guān)聯(lián)對象即時加載以提高性能 -->
<setting name="lazyLoadingEnabled" value="true" />
<!-- 設(shè)置關(guān)聯(lián)對象加載的形態(tài)，此處為按需加載字段(加載字段由SQL指 定)，不會加載關(guān)聯(lián)表的所有字段，以提高性能 -->
<setting name="aggressiveLazyLoading" value="false" />

@Select("select * from user_main where username=#{username}")
 @Results({
       @Result(property = "roleNames", column = "id", many = @Many(fetchType=FetchType.LAZY,select = "getRoleNamesByUserId")),
       @Result(property = "permissionNames", column = "id", many = @Many(fetchType=FetchType.LAZY,select = "getPermissionsByUserId"))
   })
public UserPO getUserByUsername(@Param("username")String username);

 @Test
   public void testGetUserByUsername() throws Exception {
     SqlSession session = sqlSessionFactory.openSession();
     try {
       UserMapper userMapper = session.getMapper(UserMapper.class);
       UserPO userPo = userMapper.getUserByUsername("zhangsan");
       System.out.println(userPo);
       System.out.println(userPo.getPermissionNames());
//       List<String> map = userMapper.getRoleMain();
//       System.out.println(map);
       session.close();
     } finally {
       session.close();
     }
   }

protected Set<String> lazyLoadTriggerMethods = new HashSet<String>(Arrays.asList(new String[] { "equals", "clone", "hashCode", "toString" }));

configuration.setLazyLoadTriggerMethods(new HashSet<String>());