• [Java Spring data] @Query @Param


    package com.example.university.repo;
    
    import com.example.university.domain.Staff;
    import com.example.university.domain.Student;
    import com.example.university.view.CourseView;
    import com.example.university.domain.Course;
    import org.springframework.data.domain.Page;
    import org.springframework.data.domain.Pageable;
    import org.springframework.data.jpa.repository.Query;
    import org.springframework.data.repository.CrudRepository;
    import org.springframework.data.repository.query.Param;
    
    import java.util.List;
    
    /**
     * DataSource Management for the Courses at the University.
     *
     * Created by maryellenbowman
     */
    public interface CourseRepository extends CrudRepository<Course,Integer>{
    
        Course findByName(String name);
    
        List<Course> findByDepartmentChairMemberLastName(String chair);
        // or
        @Query("Select c from Course c where c.department.chair.member.lastName=:chair")
        List<Course> findByChairLastName(@Param("chair")String chairLastName);
        // or
        @Query("Select c from Course c where c.department.chair.member.lastname = ?1")
        List<Course> findByChairLastName(String chairLastName);
    
        @Query("Select c from Course c join c.prerequisites p where p.id = ?1")
        List<Course> findCourseByPrerequisite(int id);
    
        @Query("Select new com.example.university.view.CourseView" +
                "(c.name, c.instructor.member.lastName, c.department.name) from Course c where c.id=?1")
        CourseView getCourseView(int courseId) ;
    
        List<Course> findByCredits(@Param("credits") int credits);
    
        Page<Course> findByCredits(@Param("credits") int credits, Pageable pageable);
    
    //      Common Querying Mistake
    //      Uncomment to Debug.
    //
    //    Course findByDeptName(String deptName);
    //
    //    @Query("Select new com.example.university.view.CourseView" +
    //            "(c.name, c.instructor.member.lastName, c.department.name) from course c where c.name=?1")
    //    Course getCourseViewByName(String name);
    
    }
    

      

  • 相关阅读:
    [转]使用WIndows的BAT来延时执行某程序
    Xamarin.Forms之ListView探究笔记
    常用SQL语句集合
    Xamarin.Forms之探索笔记
    (持续更新)Xamarin.Forms之常见的问题
    (持续更新)Xamarin.Forms之DevExpress GridControl的使用技巧
    Xamarin.Forms之Effects的使用
    Xamarin.Android之添加.so文件
    from psycopg2._psycopg import ( ortError: DLL load failed: 找不到指定的模块。的一种解决方案
    ODOO中创建website Part-1 创建模块
  • 原文地址:https://www.cnblogs.com/Answer1215/p/14153045.html
Copyright © 2020-2023  润新知