Mybatis实现联表查询并且分页功能

@Data
public class Person implements Serializable {
 private static final long serialVersiOnUID= -70682701290685641L;
 private Integer personid;
 private String firstname;
 private String lastname;
 private List cats;
}

@Data
public class Cat implements Serializable {
 private static final long serialVersiOnUID= -39783356260765568L;
 private Integer id;
 private String name;
 /**
  * 猫的历史
  */
 private String history;
 /**
  * 猫的特征
  */
 private String features;
 /**
  * 大概的样子
  */
 private String imgurl;
 private Integer personId;
}

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



 
  
  
  
  
   
   
   
   
   
   
  
 

 
 
  select personid, firstname, lastname, id, name, history, features, imgurl, person_id
  from mybatis.person p inner join mybatis.cat c on p.PersOnId= c.person_id
  and PersOnId= #{PersonId}
 

 select personid, firstname, lastname, id, name, history, features, imgurl, person_id
 from mybatis.person p inner join mybatis.cat c on p.PersOnId= c.person_id
 limit #{page},#{step}

select personid, firstname, lastname, id, name, history, features, imgurl, person_id
from mybatis.person p left join mybatis.cat c on p.PersOnId= c.person_id
where PersonId in (select pp.PersonId from (select person.PersonId from person limit 2,2) as pp);