求助，关于spring data jpa的@query的传入参数是对象怎么匹配参数

[November22]

@Modifying
@Query("update HsAlbum album set album.albumName = 此处参数 ,album.description = 此处参数 ")
public int update(HsAlbum hsAlbum);

[一个治疗术]

其实这种官网有的，不过帮你找了

/**
 * Specifies methods used to obtain and modify person related information
 * which is stored in the database.
 * @author Petri Kainulainen
 */
public interface PersonRepository extends JpaRepository<Person, Long> {
 
    /**
     * Finds a person by using the last name as a search criteria.
     * @param lastName
     * @return  A list of persons whose last name is an exact match with the given last name.
     *          If no persons is found, this method returns an empty list.
     */
    @Query("SELECT p FROM Person p WHERE LOWER(p.lastName) = LOWER(:lastName)")
    public List<Person> find(@Param("lastName") String lastName);
}

[一个治疗术]

地址： https://www.petrikainulainen.net/programming/spring-framework/spring-data-jpa-tutorial-three-custom-queries-with-query-methods/

[November22]

不是这个，我指的是，参数是一个对象，如果 User 对象，那么我在query的参数是user对象的属性，如name ,age等，这个怎么匹配？？？

[梦醒执着]

@Query("update HsAlbum album set album.albumName = #{#hsAlbum.albumName} ,album.description = #{#hsAlbum.description } ")
public int update(HsAlbum hsAlbum);
完美解决！！！

[码农~三少]

实体类
@Data
public class LogQuery {

private String startDate;
private String endDate;

}

dao层
@Query(nativeQuery = true,
value = "SELECT count(DISTINCT(id)) visit,url,replace(substring(log_time,1,10),'-','') ltime FROM sys_log" +
" WHERE replace(substring(log_time,1,10),'-','') BETWEEN :#{#log.startDate} AND :#{#log.endDate} GROUP BY url")
List<Map<String, Object>> findLogRanking(@Param("log") LogQuery logQuery);

正好解决了

[春卷要炸着吃]

引用 4 楼 Z446136354 的回复:

@Query("update HsAlbum album set album.albumName = #{#hsAlbum.albumName} ,album.description = #{#hsAlbum.description } ") public int update(HsAlbum hsAlbum); 完美解决！！！

请问spring data什么版本，为什么我的不支持这么写

[我欠阳光一个约会]

引用 4 楼 Z446136354 的回复:

@Query("update HsAlbum album set album.albumName = #{#hsAlbum.albumName} ,album.description = #{#hsAlbum.description } ") public int update(HsAlbum hsAlbum); 完美解决！！！

不用 @Param？就可以？

[我欠阳光一个约会]

参考最下面回复 https://stackoverflow.com/questions/10802798/spring-data-jpa-query-with-parameter-properties#

[java干货]

最新的貌似要如下：

@Query("select u from User u where u.firstname = :#{#customer.firstname}")
List<User> findUsersByCustomersFirstname(@Param("customer") Customer customer);

[java干货]

https://spring.io/blog/2014/07/15/spel-support-in-spring-data-jpa-query-definitions

[dawntop111]

最新版本的JPA中 #{#hsAlbum.albumName} 已经失效。 请用下面方法：

@Query("select u from User u where u.age = ?#{[0]}")
List<User> findUsersByAge(int age);

@Query("select u from User u where u.firstname = :#{#customer.firstname}")
List<User> findUsersByCustomersFirstname(@Param("customer") Customer customer);