- 表之间的关系(类似于实体之间的关系)
- 一对多
- 一对一
- 多对多
- 多对一
- 一对多
(1)在“一”对应端加入“多”端的集合
public class User implements Serializable { //能够序列化
private Integer id;
private String userName;
private Date birthday;
private String sex;
private String address;
private List<Account> accounts; //建立起一对多的关系
...
}
(2)在xml文档中配置属性的映射,以便mybatis对查询结果进行封装
<resultMap id="userAccountMap" type="com.itheima.domian.User">
<id property="id" column="id"></id>
<result property="userName" column="username"></result>
<result property="address" column="address"></result>
<result property="sex" column="sex"></result>
<result property="birthday" column="birthday"></result>
<collection property="accounts" ofType="com.itheima.domian.Account"> <!--集合的属性映射,property即为类中定义的集合的名字,ofType指的是集合中元素的类型-->
<id property="id" column="aid"></id>
<result property="uid" column="uid"></result>
<result property="money" column="money"></result>
</collection>
</resultMap>
(3)查询操作
<select id="findAll" resultMap="userAccountMap">
select user.*,account.id as aid,account.uid,account.money from user left outer join account on user.id=account.uid;
</select>
- 多对一(一对一也适用)
(1)在“多”端实体类中加入“一”端的引用
public class Account implements Serializable {
private Integer id;
private Integer uid;
private Double money;
private User user;
...
}
(2)在DAO相应的配置文件配置属性映射关系
<resultMap id="accountUserMap" type="com.itheima.domian.Account">
<id property="id" column="aid"></id>
<result property="uid" column="uid"></result>
<result property="money" column="money"></result>
<!-- 一对一的关系映射,配置封装user的内容 -->
<association property="user" column="uid" javaType="com.itheima.domian.User">
<id property="id" column="id"></id>
<result property="userName" column="username"></result>
<result property="address" column="address"></result>
<result property="sex" column="sex"></result>
<result property="birthday" column="birthday"></result>
</association>
</resultMap>
(3)执行操作
<select id="findAll" resultMap="accountUserMap">
select user.*,account.id as aid,account.uid,account.money from account,user where account.uid=user.id
</select>
- 一对一
查询时可以用多对一的方式在某一端加入另一端的引用,也可以将查询结果封装到一个类中,但这种方法不推荐使用。
给出一个例子,封装类为AccountUser,它能封装Account和User两个表联合查询的结果,在xml中配置returnType="AccountUser"即可:
public class AccountUser extends Account {
private String username;
private String address;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return super.toString()+"\tAccountUser{" +
"username='" + username + '\'' +
", address='" + address + '\'' +
'}';
}
}
- 多对多(和一对多的操作差不多,但是sql语句会稍微麻烦一点,当sql过长需要换行时,换行前必须要添加一个空格,否则会出错)
(1)为了体现多对多的关系,两个实体类中分别包含一个对方的集合
public class Role implements Serializable {
private Integer roleId;
private String roleName;
private String roleDesc;
private List<User> users;
...
}
(2)在映射配置文件中配置resultMap
<resultMap id="roleUserMap" type="com.itheima.domian.Role">
<id property="roleId" column="rid"></id>
<result property="roleName" column="role_name"></result>
<result property="roleDesc" column="role_desc"></result>
<collection property="users" ofType="com.itheima.domian.User">
<id property="id" column="id"></id>
<result property="userName" column="username"></result>
<result property="address" column="address"></result>
<result property="sex" column="sex"></result>
<result property="birthday" column="birthday"></result>
</collection>
</resultMap>
(3)执行操作
<select id="findAll" resultMap="roleUserMap">
select user.*,role.id as rid,role.role_name,role.role_desc from role left outer join user_role on role.id=user_role.rid <!--此处需要加一个空格-->
left outer join user on user.id=user_role.uid
</select>