如题,在使用@Query()注解时
1.不知道里边的句子是什么?
2.@Query()里边的句子可以有通配符,类似标准sql 语句的 % ,-
2:通配符
[code="java"]
@Query("select u from User u where username like :un")
public List findByUsername(@Param("un") String username);
List users = userDao.findByUsername("%a");
[/code]
也可以这么写:
[code="java"]
public List findByUsernameLike(String username);
List users = userDao.findByUsernameLike("%a");
[/code]
可以写HQL语句.
[code="java"]
@Query("select u from User u where username = ?1")
public List findByUsername(String username);
[/code]
[code="java"]
@Query("select u from User u where username = :un")
public List findByUsername(@Param("un") String username);
[/code]
springdata代码下载:[url]http://www.zuidaima.com/share/search.htm?key=springdata[/url]