最近刚刚在看mybatis的复杂查询 写了个分布查询的demo 有错请指正
项目结构很简单:
数据库:tid 是外键关联
student 表
teacher 表
首先创建Student 和Teacher 实体类
package entity;
public class Student {
private Integer sid;
private String sName;
private String Ssex;
private Integer Sagenum;
private Integer tid;
private Teacher teacher;
public Student() {
}
public Student(Integer sid, String sName, String ssex, Integer sagenum, Integer tid) {
this.sid = sid;
this.sName = sName;
Ssex = ssex;
Sagenum = sagenum;
this.tid = tid;
}
public Student(Integer sid, String sName, String ssex, Teacher teacher, Integer sagenum, Integer tid) {
this.sid = sid;
this.sName = sName;
Ssex = ssex;
this.teacher = teacher;
Sagenum = sagenum;
this.tid = tid;
}
public Integer getSid() {
return sid;
}
public void setSid(Integer sid) {
this.sid = sid;
}
public String getsName() {
return sName;
}
public void setsName(String sName) {
this.sName = sName;