public interface DeviceRepository extends JpaRepository<DeviceDetailEntity, Integer> {
@Query(value="select p from DeviceDetailEntity as p where " +
"(p.name like concat(concat('%',?1),'%')) and" +
"(p.id=?2) order by p.id")
DeviceDetailEntity findByName(String queryStr,int deviceId);
}
concat是用来拼接%与查询参数的。