使用两种类型的Kotlin JPA查询内连接

@Repository
interface UserRepository : JpaRepository<User, Long> {
    fun findByOrdersProductName(productName: String): List<User>
}

@Repository
interface UserRepository : JpaRepository<User, Long> {
    @Query("SELECT u FROM User u JOIN u.orders o WHERE o.productName = :productName")
    fun findByOrdersProductName(@Param("productName") productName: String): List<User>
}

@Repository
interface UserRepository : JpaRepository<User, Long> {
    fun findByOrdersProductName(productName: String): List<User> {
        val criteriaBuilder = entityManager.criteriaBuilder
        val criteriaQuery = criteriaBuilder.createQuery(User::class.java)
        val root = criteriaQuery.from(User::class.java)
        val join = root.join<User, Order>("orders")
        criteriaQuery.select(root).where(criteriaBuilder.equal(join.get<String>("productName"), productName))
        return entityManager.createQuery(criteriaQuery).resultList
    }
}