在Spring数据JPA场误差中使用投影

Question

@Repository
public interface UserRepositoty extends CrudRepository<tbl_user, Integer> {
// search by username
@Query(value = "select (select l.state from tbl_request_love l where l.senderid = u.userid) as state, u.userid as userid,u.username as username,u.nickname as nickname,u.avatar as avatar"
        + " from tbl_user u"
        + " where u.username LIKE CONCAT('%',:username,'%') and u.coupleid is null" , nativeQuery = true)
List<tbl_user_search> findByUsernameEndWith(@Param("username") String username);
}

public interface tbl_user_search {
int getUserid();
String getUsername();
String getNickname();
String getAvatar();
String getState();
}

{
    "state": "Hi",
    "username": "https://forumhumgeduvn.000webhostapp.com/5skay/man.png",
    "userid": "Hi Hi",
    "avatar": "Pending",
    "nickname": "3"
}

Answer 1

试着像这样使用:

" where u.username LIKE %:username% and u.coupleid is null"

或：

" where u.username LIKE %?1% and u.coupleid is null"

使用高级类似表达式阅读本文