What is Spring Data Specification?

Spring Data Specification is an interface from the Spring Data JPA module that allows creating dynamic database queries based on the JPA Criteria API. It provides a type-safe way to define predicates (filter conditions) for queries, making them more readable and maintainable compared to native SQL or JPQL.

Main components:

• Specification<T>: The main interface. The method toPredicate(Root<T> root, CriteriaQuery<?> query, CriteriaBuilder criteriaBuilder) returns a predicate that will be applied to the query.
• Root<T>: Represents the root entity in the query expression. It allows access to the entity's fields.
• CriteriaQuery<?>: Represents the query constructor.
• CriteriaBuilder: Provides methods to create various predicates (equality, inequality, like, greater than, less than, etc.), logical operators (AND, OR, NOT), and aggregate functions.

Advantages of using Specification:

• Type safety: Eliminates the need to use string field names when building queries, reducing the risk of errors.
• Reusability: Allows creating specifications for common filter conditions and combining them.
• Readability: Code built with Specification is more clear and understandable than complex JPQL queries, especially with many conditions.
• Testability: Individual specifications are easier to test in isolation.
• Security: Helps prevent SQL injection as conditions are built programmatically rather than from string expressions.

Example usage:

interface UserRepository extends JpaRepository<User, Long>, JpaSpecificationExecutor<User> {
}

// Specification for finding users by name
public static Specification<User> hasName(String name) {
    return (root, query, criteriaBuilder) ->
            criteriaBuilder.equal(root.get("name"), name);
}

// Specification for finding active users
public static Specification<User> isActive() {
    return (root, query, criteriaBuilder) ->
            criteriaBuilder.equal(root.get("active"), true);
}

// Using specifications
// userRepository.findAll(Specification.where(hasName("John")).and(isActive()));

The JpaSpecificationExecutor<T> interface must be implemented by your repository to access methods that accept Specification (e.g., findAll, findOne, count).