比如来看一下这样的一条SQL语句,这是一个三张表的多表查询,显然在JPA中用一个实体类是接受不了这些参数的
select
t1.id as chapterId ,
t1.name as chapterName ,
t2.id as unitId,
t2.name as unitName ,
t3.id as lessonId,
t3.name as lessonName
from t_chapter t1
LEFT JOIN t_unit t2 on t1.id =t2.chapter_id
LEFT JOIN t_lession t3 on t3.unit_id =t2.id
where t1.id= '4028b4816305ea91016305eec24f0000'
and t2.id='4028b4816305f1a6016305f423180000'
and t3.id= '4028b4816306007b016306020bb80000';
1
2
3
4
5
6
7
8
9
10
11
12
13
Repository
/**
* Created by ZhuPengWei on 2018/5/11.
*/
public interface TestRepository exten