一对多,分步查询
1.建立两个javaBean
public class Teacher {
private int id;
private String name;
private List<Student> stus;
public class Student {
private int id;
private String name;
private Teacher teacher;
2.建立数据库表,并插入数据
创建学生表
create table t_student(
`id` int primary key auto_increment,
`name` varchar(50),
`teacher_id` int ,
foreign key(`teacher_id`) references t_teacher(`id`)
);
创建老师表
create table t_teacher(
`id` int primary key