一个学生可以选多门课,一个课也可以由多个学生选。
准备数据库表:
create table tb_student(
s_id int primary key auto_increment,
s_name varchar(20),
s_sex varchar(10),
s_age int);
insert into tb_student(s_name,s_sex,s_age) values('Tom','male',18);
insert into tb_student(s_name,s_sex,s_age) values('Jack','male',19);
create table tb_course(
c_id int primary key auto_increment,
c_name varchar(20),
c_credit int);
insert into tb_course(c_name,c_credit) values('Math',5);
insert into tb_course(c_name,c_credit) values('Computer',4);
准备两个实体类:
Student.java
package xyz.fengqing11.hellomybatis.domain;
import java.util.List;
public class Student {
private Integer id;
private String name;
private String sex;
private Integer age;
private List<Course> courses;
public Student() {
}
public Student(Integer id, String name, String sex, Integer age, List<Course> courses) {
this.id = id;
this.name = name;
this.sex = sex;
this.age = age;
this.courses = courses;
}
public Integer getId() {
return id;
}
public void setId(Integer id)