@Select("select * from authority")
 @Results(id="au",
 value=@Result(column="uid",
      property="user",
      one=@One(select="findUserByid",
           fetchType=FetchType.LAZY)))
 List<Authority> findAll();

@Select("select * from user where id = #{id}")
 User findUserByid(int id);

<resultMap type="com.jt.mybatis.entity.Authority" id="au">
    <association property="user" column="uid" javaType="com.jt.mybatis.entity.User"      select="findByUserId">
    </association>
</resultMap>

<select id="findAll" resultMap="au">
  select * from authority
</select>

<select id="findUserByid" resultType="com.jt.mybatis.entity.User">
  select * from user where id= #{id}
</select>

@Test
 public void testA(){
  AuthorityMapper mapper = session.getMapper(AuthorityMapper.class);
  mapper.findAll().get(0).getUser();
 }

    <resultMap type="com.jt.mybatis.entity.User" id="user">
      <id column="id" property="id" />
      <collection property="authoritieList" column="id"
       fetchType="lazy" select="findAuthorityByUid">
       <id column="id" property="id" />
      </collection>
    </resultMap>

 <select id="findUserByUserName" resultMap="user">
  select * from user
  where username = #{username}
 </select>
 
 <select id="findAuthorityByUid" resultType="com.jt.mybatis.entity.Authority">
  select * from
  authority where uid = #{uid}
 </select>

@Select("select * from user where username = #{username}")
@Results(id="user",
value=@Result(column="id",
property="authoritieList",
many=@Many(fetchType=FetchType.LAZY,
select="findAuthorityByUid")))
User findUserByUserName(String username);

@Select("select * from authority where uid = #{uid}")
List<Authority> findAuthorityByUid(int uid);

@Test
public void testB(){
 AuthorityMapper mapper = session.getMapper(AuthorityMapper.class);
 mapper.findUserByUserName("admin").getAuthoritieList();
}

@SelectProvider(type=AuthorityProvider.class,method="returnSelectSQL")
 List<Authority> findByIdAndUid(Authority authority);
 class AuthorityProvider{
  public String returnSelectSQL(Authority authority){
   SQL sql = new SQL(){{
    SELECT("*");
    FROM("authority");
    if(authority.getId() != 0){
     WHERE("id = " + authority.getId());
    }
    if(authority.getUid() != 0){
     WHERE("uid = " + authority.getUid());
    }
   }};
   return sql.toString();
  }
 }
 //用XXXProvider的注解是動(dòng)態(tài)生成sql語句的，
 //type=AuthorityProvider.class為生成動(dòng)態(tài)語句的具體類
 //method="returnSelectSQL"為生成動(dòng)態(tài)語句的方法
 //SQL類為動(dòng)態(tài)生成sql的類

@Test
 public void testC(){
  AuthorityMapper mapper = session.getMapper(AuthorityMapper.class);
  Authority authority = new Authority();
  mapper.findByIdAndUid(authority);
  //執(zhí)行此語句返回的sql語句為DEBUG [main] - ==>  Preparing: SELECT * FROM authority
  authority.setId(1);
  mapper.findByIdAndUid(authority);
  //執(zhí)行此語句返回的sql語句為DEBUG [main] - ==>  Preparing: SELECT * FROM authority WHERE (id = 1)
  authority.setUid(2);
  mapper.findByIdAndUid(authority);
  //執(zhí)行此語句返回的sql語句為DEBUG [main] - ==>  Preparing: SELECT * FROM authority WHERE (id = 1 AND uid = 2) 
 }