kotlin+JPA+hibernate使用@query查询

Question

（HQL，JPQL,原生SQL等）这是什么查询语句？希望能提供个网址详细学习

package com.umh.doctorreferral.core.model.doctorreferralcase

import org.springframework.data.domain.Page
import org.springframework.data.domain.Pageable
import org.springframework.data.jpa.repository.JpaRepository
import org.springframework.data.jpa.repository.Query
import org.springframework.data.repository.query.Param
import java.util.*

interface DoctorReferralCaseRepository : JpaRepository<DoctorReferralCase, UUID> {

    @Query(value = """
        select t
            from DoctorReferralCase t
            where (t.status <> 'DRAFT' or t.status is null)
            and 
            ( :#{ #referralCase.referralDate} is null or t.referralDate >= to_date(:#{ #referralCase.referralDate }, 'yyyy-mm-dd')   )
            and 
            ( :#{ #referralCase.fromDoctor} is null or t.fromDoctor = :#{ #referralCase.fromDoctor } )
            and 
            ( :#{ #referralCase.toDoctor} is null or  t.toDoctor = :#{ #referralCase.toDoctor })
            and 
            ( :#{ #referralCase.referralType} is null or t.referralType = :#{ #referralCase.referralType }  )
            and 
            ( :#{ #referralCase.status} is null or t.status = :#{ #referralCase.status } )
    """)
    fun pageReferralCase(@Param("referralCase") param : ReferralCasesSearchParam, pageable: Pageable) : Page<DoctorReferralCase>

}

Answer 1

你这个query查询，表就是对应的实体类，字段名对应的就是属性，如果你想用原生的sql，在query里面添加nativeQuery = true，就可以了，你可去B站进行相关的jpa学习