一、在MyBatis中一对多时使用collection标签;在多对一的时候使用association标签
二、数据库表
2.1、数据查询结果
使用的maven整合,所以jar不需要自己导入 项目的结构
一对多的查询
一对多的嵌套结果
Play javaBean
package com.lzq.oneToMany.domain;
import java.util.List;
//一对多中的一
public class playType {
private Long id;
private String type_name;
// 将一对多中的多表作为属性封装在一中
List<Play> types;
public playType() {
}
public playType(Long id, String type_name, List<Play> types) {
this.id = id;
this.type_name = type_name;
this.types = types;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getType_name() {
return type_name;
}
public void setType_name(String type_name) {
this.type_name = type_name;
}
public List<Play> getTypes() {
return types;
}
public void setTypes(List<Play> types) {
this.types = types;
}
@Override
public String toString() {
return "playType{" +
"id=" + id +
", type_name='" + type_name + '\'' +
", types=" + types +
'}';
}
}
PlayType javaBean
package com.lzq.oneToMany.domain;
public class Play {
private Long id;
private String play_name;
private Long play_type;
public Play() {
}
public Play(Long id, String play_name, Long play_type) {
this.id = id;
this.play_name = play_name;
this.play_type = play_type;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getPlay_name() {
return play_name;
}
public void setPlay_name(String play_name) {
this.play_name = play_name;
}
public Long getPlay_type() {
return play_type;
}
public void setPlay_type(Long play_type) {
this.play_type = play_type;
}
@Override
public String toString() {
return "Type{" +
"id=" + id +
", play_name='" + play_name + '\'' &