Mybatis自定义SQL的关系映射、分页、排序功能的实现

public class Student {
 @TableId
 private int id;
 private String name;
 private int tid;
 @TableField(exist = false)
 private Teacher teacher;
}

public class Teacher {
 @TableId
 private int id;
 private String name;
}

// teacherMapper.xml
<&＃63;xml version="1.0" encoding="UTF-8" &＃63;>


 
 select * from teacher where id = #{id};
 


// studentMapper.xml
<&＃63;xml version="1.0" encoding="UTF-8" &＃63;>


 
 select * from student where id =#{id};
 

 
 
 
 
 
  
  
 
 

<&＃63;xml version="1.0" encoding="UTF-8" &＃63;>


 
  SELECT a.*,b.id as cid,b.name as cname FROM `student` as a,teacher as b WHERE a.id =#{id} and a.tid = b.id;
 
 
 
 
 
 
  
  
 
 

public class Teacher {
 @TableId
 private int id;
 private String name;
 @TableField(exist = false)
 private List students;
}

// teacherMapper.xml
	
 SELECT a.*,b.id as cid,b.name as cname,b.tid
 from teacher as a , student as b
 where b.tid = a.id and a.id =#{id};
 

 
 
 
 
  
  
  
 
 

// teacherMapper.xml
	
 select * from teacher as a where a.id = #{id}

 
 
 
 
 
 
 

	// studentMapper.xml
 
 select * from student as a where a.tid = #{id}
 

public interface UserMapper{
 IPage selectPageVo(Page page);
}

 SELECT * FROM user 

 SELECT * FROM user order by ${sortColumn} ${sortOrder}

select id,name,age from student where id =#{id}

select id,name,age from student where id ="1"

select id,name,age from student where id =${id}

select id,name,age from student where id =1