MyBatis的一对多查询

在这里我贴出我的对象类

public class UserClass {
private int classId;
private String className;
//增加用户属性，让Usercalss和user建立联系
private List<User> users;
public List<User> getUsers() {
	return users;
}
public void setUsers(List<User> users) {
	this.users = users;
}
@Override
public String toString() {
	return "UserClass [classId=" + classId + ", className=" + className + ", users=" + users + "]";
}
public int getClassId() {
	return classId;
}
public String getClassName() {
	return className;
}
public void setClassId(int classId) {
	this.classId = classId;
}
public void setClassName(String className) {
	this.className = className;
}
public UserClass(int classId, String className) {
	super();
	this.classId = classId;
	this.className = className;
}
public UserClass() {
	super();
}
}

public class User {

	private int id;
	private String name;
	private int age;
	private boolean sex;
	private UserCard userCard;
	
	public UserCard getUserCard() {
		return userCard;
	}
	public void setUserCard(UserCard userCard) {
		this.userCard = userCard;
	}
	public User(int id, String name, int age,boolean sex) {
		super();
		this.id = id;
		this.name = name;
		this.setAge(age);
		this.sex = sex;
	}
	public User() {
		super();
	}
	public int getId() {
		return id;
	}
	public String getName() {
		return name;
	}
	
	public void setId(int id) {
		this.id = id;
	}

public void setName(String name) {
	this.name = name;
}
	
	@Override
	public String toString() {
		// TODO Auto-generated method stub
		return name+","+id+","+age;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
}

下面的是我xxxMapper.xml的设置

<select id="queryUsersByClassid" resultMap="class_user1_map"
		parameterType="int">
		select u.*,c.* from user u
		inner join userclass c
		on
		u.classid = c.classid
		where u.classid = #{classId}
	</select>

	<resultMap type="UserClass" id="class_user1_map">
		<id property="classId" column="classid" />
		<result property="className" column="classname" />
		<!-- 配置User属性 属性类型用：javatype，属性的元素类型ofType -->
		<collection property="users" ofType="User">
			<id property="id" column="id" />
			<result property="name" column="name" />
			<result property="age" column="age" />
		</collection>
	</resultMap>

xml中<resultMap>
想要了解的人可以在CSDN搜索javaType和ofType具体的区别，我在视频中总结到就是<collection property="users" ofType="User"> ，<association property="userCard" javaType="UserCard">，collection就是用oftype，association就是用javaType。（association用于一对一的查询 个人觉得没啥难度）。

以上内容均来自bilibili颜群老师的视频