jpa多表自定义sql查询，返回自定义vo实体类(一)

比如来看一下这样的一条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 extends JpaRepository<ProductInfo, String > {

    @Query(
            value = "select \n" +
                    "t1.id as chapterId ,t1.name