MyBatis多表查询

表之间的关系：一对多，多对一，多对多，一对一
一对一：

private class Account{
	private Integer id;
	private Integer uid;
	private double money;
	private User user;
	/**setter方法**/
	........
	/**getter方法**/
}

public interface AccountDao{
	List<Account> findAll();
}
/**AccountDao.xml**/
<resultMap type="account" id="accountMap">	
	<id column="aid" property="id"/>
	<result column="uid" property="uid" />
	<result column="money" property="money"/>
	<association property="user" javaType="user">
		<id column="id" property="id"/>
		<result column="username" property="username"/>
	</association>
</resultMap>
<select id="findAll" resultMap="accountMap">
	select u.*,a.id as aid,a.uid,a.money from account a user u where a.uid = u.id
</select>	

一对多：

public class User{
	private Integer id;
	private String username;
	private List<Account> accountList;
	 /**setter方法**/
	 ........
	 /**getter方法**/
}
public interface UserDao{
	List<User> findAll();
}
/**UserDao.xml**/
<resultMap type="user" id="userMap">
	<id column="id" property="id"/>
	<result column="username" property="username"/>
	<!--collection:是用于建立一对多中集合属性的对应关系
	    ofType:用于指定集合元素的数据类型-->
	<collection property="accountList" ofType="Account">
		<id column="aid" property="id"/>
		<result column="uid" property="uid"/>
		<result column="money" property="money"/>
	</collection>
</resultMap>
<select id="findAll" resultMap="userMap">
	select u.*,a.id as aid,a.uid,a.money from user u left join account a on u.id = a.uid 
</select>