我不同意QueryDSL会导致大量额外的代码。这是QueryDSL的一些测试代码:
仓库定义:
public interface UserRepository extends PagingAndSortingRepository<User, Long>, QueryDslPredicateExecutor<User> { public User findOne(Predicate predicate); public List<User> findAll(Predicate predicate);}基于各种属性及其组合的测试代码:
@Test public void testFindByEmailAddress() { User user = repository.findOne(QUser.user.emailAddress.eq("jack@hamilton.net")); Assert.assertNotNull(user); Assert.assertEquals("Jack", user.getForename()); Assert.assertEquals("Hamilton", user.getSurname()); } @Test public void testFindByGender() { List<User> users = repository.findAll(QUser.user.gender.eq(Gender.M)); Assert.assertEquals(4, users.size()); users = repository.findAll(QUser.user.gender.eq(Gender.F)); Assert.assertEquals(2, users.size()); } @Test public void testFindByCity() { List<User> users = repository.findAll(QUser.user.address.town.eq("Edinburgh")); Assert.assertEquals(2, users.size()); users = repository.findAll(QUser.user.address.town.eq("Stirling")); Assert.assertEquals(1, users.size()); } @Test public void testFindByGenderAndCity() { List<User> users = repository.findAll(QUser.user.address.town.eq("Glasgow").and(QUser.user.gender.eq(Gender.M))); Assert.assertEquals(2, users.size()); users = repository.findAll(QUser.user.address.town.eq("Glasgow").and(QUser.user.gender.eq(Gender.F))); Assert.assertEquals(1, users.size()); }


