这里有一个可行的测试
@Test
public void test1() {
repository.save(makeEmployee("billy", "London"));
repository.save(makeEmployee("noby", "London"));
repository.save(makeEmployee("fred", "London"));
assertEquals(3, repository.count());
final Long id = 3l;
final String name = "noby";
final String city = "London";
Specification<Employee> specification = new Specification<Employee>() {
public Predicate toPredicate(Root<Employee> root, CriteriaQuery<?> query, CriteriaBuilder builder) {
List<Predicate> predicates = new ArrayList<Predicate>();
predicates.add(builder.equal(root.get("id"), id));
predicates.add(builder.equal(root.get("name"), name));
predicates.add(builder.equal(root.get("address").get("city"), city));
return builder.and(predicates.toArray(new Predicate[predicates.size()]));
}
};
List<Employee> find = repository.findByIdAndNameAndAddressCity(id, name, city);
assertEquals(1, find.size());
find = repository.findAll(specification);
assertEquals(1, find.size());
}
private Employee makeEmployee(String name, String city) {
Address address = new Address();
address.setCity(city);
Employee employee = new Employee();
employee.setName(name);
employee.setAddress(address);
return employee;
}
}
仓库看起来是这样的
@Repository
public interface EmployeeRepository extends JpaRepository<Employee, Long>, JpaSpecificationExecutor<Employee> {
List<Employee> findByIdAndNameAndAddressCity(Long id, String name, String city);
}
实体看起来像这样
@Entity(name = "EMPLOYEE")
public class Employee {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@Column(name = "NAME")
private String name;
@Column(name = "DATE_OF_BIRTH")
private Date dob;
@OneToOne(cascade=CascadeType.ALL)
@JoinColumn(name = "address_id", referencedColumnName = "id", nullable = false)
private Address address;
希望这能有所帮助。