Spring Boot Jpa 自定义SQL

自定义查询语句的几种方式

1. 使用@Query注解

   public interface UserRepository extends JpaRepository<User, Long> { 
   	@Query("select u from User u where u.emailAddress = ?1")
   	User findByEmailAddress(String emailAddress);
   }
   

2. 模糊查询

   public interface UserRepository extends JpaRepository<User, Long> {
   	@Query("select u from User u where u.firstname like %?1")
   	List<User> findByFirstnameEndsWith(String firstname);
   }
   

3. 修改操作

   public interface UserRepository extends JpaRepository<User, Long> {
   	@Modifying
   	@Query("update User u set u.firstname = ?1 where u.lastname = ?2")
   	int setFixedFirstnameFor(String firstname, String lastname);
   }
   

4. 删除操作

   interface UserRepository extends Repository<User, Long> {
   	void deleteByRoleId(long roleId);
   	@Modifying
   	@Query("delete from User u where u.role.id = ?1")
   	void deleteInBulkByRoleId(long roleId);
   }
   

以上