表之间的关系:一对多,多对一,多对多,一对一
一对一:
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>