SpringDataJPA之@Query 分页查询加like模糊查询加in查询

@Query自定义 分页查询加like模糊查询加in查询

    //分页查询，第一页从0开始，Sort.by按字段排序
    Pageable pageable = PageRequest.of(0, limit, Sort.by("name").ascending());

    @Query(value = "SELECT * FROM table WHERE group_id = ?1 AND severity IN ?2 AND cluster IN ?3 AND (name LIKE %?4% or append_tags LIKE %?5%)", nativeQuery = true)
    List<Table Entity> findTablePageable(Long groupId, List<Integer> severities, List<String> clusters, String name, String appendTags, Pageable pageable);

jpa按方法名自动拼接sql