1.实体类中需要有相应字段
public class Student{
private String studentName;
private String studentId;
private String age;
private String course;
private String teacherId;
@TableField( exist = false )
private String teacherName;
}
public class Teacher{
private String teacherId;
private String teacherName;
private String teacherClass;
}
//SQL语句
select t.teacherName from student s,teacher t where s.teacherId = t.teacherId;
2.在数据库中没有teacherName字段的情况下,动态获取teacherName,展示给前端页面上
//studentPage.getRecords是Mybatis-Plus自带的分页,在前端页面展示数据
List<Student> Students = studentPage.getRecords();
for (Student student : Students) {
//todo 通过Student类里的teacherId,再调接口(或者使用上面的sql语句)获取到teacherName
student.setTeacherName(teacherName);
}
这样就可以在不写入数据库的情况下,动态获取到数据.
一般用于当用户修改自己的名字后,一些功能中包含创建者或其他包含用户名的字段中时,需要一起修改.