//------------------------------------using @Query annotations//queries with no parameters@Query ("Select p from person p where p.id = (select Max (p2.id) from person P2)") person Getmaxidperson ();//Use? And the number represents the incoming parameter @query ("Select p from person p where lastname=?1 and email=?2") person Readpersonbylastnameandemail (String lastname,string email);
Use: Represents the incoming parameter @query ("Select p from person p where email=:email and Lastname=:name") Person Readpersonbylastnameandemailthroughname (@Param ("Name") String LastName, @Param ("email") (String email);//use like@Query ("Select p from person p where lastName like? 1") person Readpersonbylike (String likename);//@Query Annotations Support the use of percent sign@Query ("Select p from person p where lastName like%?1%") person ReadPersonByLike2 (String likename);//@Query Annotations Support the use of percent sign@Query ("Select p from person p where lastName like%:lastname%") Person ReadPersonByLike3 (@Param ("LastName") String name);//using native SQL@Query (value= "select * from Jpa_person p1 where p1.last_name like%:lastname%", nativequery=true) Person Getpersonusingoriginsql (@Param ("LastName") String lastName);
Use of @query annotations for SPRING-DATA-JPA