通过从存储库函数jpa、java中排除多个列(和)中的特定值进行过滤

@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
}

@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
    @Query("SELECT e FROM YourEntity e WHERE e.column1 NOT IN :values AND e.column2 NOT IN :values")
    List<YourEntity> findByExcludedValues(@Param("values") List<String> excludedValues);
}

@Service
public class YourService {
    @Autowired
    private YourRepository yourRepository;

    public List<YourEntity> getFilteredEntities(List<String> excludedValues) {
        return yourRepository.findByExcludedValues(excludedValues);
    }
}