1.自定义实体写法中@Query 没有使用nativeQuery = true
2.自定义实体写法使用new 实体的方式返回结果,括号中写需要返回的参数,需要有对应参数的构造器
3.查询的字段根据实体字段填写,与普通的fpepc.check_type有别,自定义实体写法fpepc.checkType,实际上对应的是FamilyPlanningEarlyPregnancyCheck实体中的checkType字段(查询某个表中对应的实体中的字段返回封装到自定义实体中,我是这么理解的)
自定义实体
@Query(value = "SELECT new com.lianmed.mchcgen.womenshealthcare.vm.familyplanning.FamilyPlanningEarlyPregnancyCheckVMS(\n" +
" fpepc.id, fpepc.checkType,epcdat.registrationDate,whpe.weight,epcmh.chiefComplaint)\n" +
" FROM FamilyPlanningEarlyPregnancyCheck fpepc LEFT JOIN EarlyPregnancyCheckDiagnosisAndTreatment epcdat\n" +
" ON fpepc.id = epcdat.familyPlanningEarlyPregnancyCheck.id " +
" LEFT JOIN WomenHealthcarePhysicalExamination whpe\n" +
" ON fpepc.id = whpe.familyPlanningEarlyPregnancyCheck.id\n" +
" LEFT JOIN EarlyPregnancyCheckMedicalHistory epcmh\n" +
" ON fpepc.id = epcmh.familyPlanningEarlyPregnancyCheck.id\n" +
" ORDER BY fpepc.createdDate DESC")
自定义实体条件查询