[TOC] # 用戶-角色  Role ~~~ public class Role implements Serializable { private Integer roleId; private String roleName; private String roleDesc; private List<User> users; private static final long serialVersionUID = 7247714661111L; ~~~ 接口文件 ~~~ <!-- 定義role表的ResultMap --> <resultMap id="roleMap" type="com.jdxia.domain.Role"> <!-- 角色id重命名了 --> <id property="roleId" column="id" /> <result property="roleName" column="role_name" /> <result property="roleDesc" column="role_desc" /> <collection property="users" ofType="com.jdxia.domain.User"> <id column="uid" property="id" /> <result column="username" property="username" /> <result column="address" property="address" /> <result column="sex" property="sex" /> <result column="birthday" property="birthday" /> </collection> </resultMap> <!-- 查詢所有 --> <select id="findAll" resultMap="roleMap"> SELECT r.*, u.id uid, u.username username, u.birthday birthday, u.sex sex, u.address address FROM ROLE r INNER JOIN USER_ROLE ur ON ( r.id = ur.rid) INNER JOIN USER u ON (ur.uid = u.id); </select> ~~~ 執行 ~~~ List<Role> res = roleDao.findAll(); for (Role role : res) { System.out.println(role); System.out.println(role.getUsers()); System.out.println("---"); } ~~~