2 回答

TA貢獻(xiàn)1821條經(jīng)驗(yàn) 獲得超5個(gè)贊
public interface MyRepository extends JpaRepository<User, String> {
@Query(value = "select * from User where code like CONCAT(:param,'%')",
nativeQuery= true)
public List<User> findAllUsers(@Param("param") String param);
}

TA貢獻(xiàn)1891條經(jīng)驗(yàn) 獲得超3個(gè)贊
您可以將查詢參數(shù)與索引?1
?查詢創(chuàng)建和Spring Data JPA一起使用
@Query(value = "select * from User where code like ?1%",?
nativeQuery= true)
public List<User> findAllUsers(String param);
或者通過名稱傳遞參數(shù)。
@Query(value = "select * from User where code like :param%",?
nativeQuery= true)
public List<User> findAllUsers(@Param("param")? String param);
添加回答
舉報(bào)