modify spring query

Doha2012 · Doha2012 · commit 3100b6b8fba2 · 2015-01-28T17:56:05.000+02:00
diff --git a/spring-security-rest-full/.classpath b/spring-security-rest-full/.classpath
@@ -1,18 +1,23 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <classpath>
-	<classpathentry kind="src" output="target/classes" path="src/main/java">
+	<classpathentry kind="src" path="src/main/java">
 		<attributes>
 			<attribute name="optional" value="true"/>
 			<attribute name="maven.pomderived" value="true"/>
 		</attributes>
 	</classpathentry>
-	<classpathentry kind="src" path="target/generated-sources/java"/>
-	<classpathentry excluding="**" kind="src" output="target/classes" path="src/main/resources">
+	<classpathentry kind="src" path="target/generated-sources/java">
+		<attributes>
+			<attribute name="optional" value="true"/>
+			<attribute name="maven.pomderived" value="true"/>
+		</attributes>
+	</classpathentry>
+	<classpathentry excluding="**" kind="src" path="src/main/resources">
 		<attributes>
 			<attribute name="maven.pomderived" value="true"/>
 		</attributes>
 	</classpathentry>
-	<classpathentry excluding="**" kind="src" output="target/test-classes" path="src/test/resources">
+	<classpathentry excluding="**" kind="src" path="src/test/resources">
 		<attributes>
 			<attribute name="maven.pomderived" value="true"/>
 		</attributes>
@@ -23,7 +28,7 @@
 			<attribute name="org.eclipse.jst.component.dependency" value="/WEB-INF/lib"/>
 		</attributes>
 	</classpathentry>
-	<classpathentry kind="src" output="target/test-classes" path="src/test/java">
+	<classpathentry kind="src" path="src/test/java">
 		<attributes>
 			<attribute name="optional" value="true"/>
 			<attribute name="maven.pomderived" value="true"/>
diff --git a/spring-security-rest-full/.externalToolBuilders/org.hibernate.eclipse.console.hibernateBuilder.launch b/spring-security-rest-full/.externalToolBuilders/org.hibernate.eclipse.console.hibernateBuilder.launch
@@ -0,0 +1,7 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<launchConfiguration type="org.eclipse.ant.AntBuilderLaunchConfigurationType">
+<booleanAttribute key="org.eclipse.ui.externaltools.ATTR_BUILDER_ENABLED" value="false"/>
+<stringAttribute key="org.eclipse.ui.externaltools.ATTR_DISABLED_BUILDER" value="org.hibernate.eclipse.console.hibernateBuilder"/>
+<mapAttribute key="org.eclipse.ui.externaltools.ATTR_TOOL_ARGUMENTS"/>
+<booleanAttribute key="org.eclipse.ui.externaltools.ATTR_TRIGGERS_CONFIGURED" value="true"/>
+</launchConfiguration>
diff --git a/spring-security-rest-full/.project b/spring-security-rest-full/.project
@@ -26,8 +26,13 @@
 			</arguments>
 		</buildCommand>
 		<buildCommand>
-			<name>org.hibernate.eclipse.console.hibernateBuilder</name>
+			<name>org.eclipse.ui.externaltools.ExternalToolBuilder</name>
+			<triggers>full,incremental,</triggers>
 			<arguments>
+				<dictionary>
+					<key>LaunchConfigHandle</key>
+					<value>&lt;project&gt;/.externalToolBuilders/org.hibernate.eclipse.console.hibernateBuilder.launch</value>
+				</dictionary>
 			</arguments>
 		</buildCommand>
 		<buildCommand>
diff --git a/spring-security-rest-full/.settings/org.eclipse.jdt.core.prefs b/spring-security-rest-full/.settings/org.eclipse.jdt.core.prefs
@@ -5,6 +5,7 @@ org.eclipse.jdt.core.compiler.annotation.nonnullbydefault=org.eclipse.jdt.annota
 org.eclipse.jdt.core.compiler.annotation.nullable=org.eclipse.jdt.annotation.Nullable
 org.eclipse.jdt.core.compiler.annotation.nullanalysis=disabled
 org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
+org.eclipse.jdt.core.compiler.codegen.methodParameters=do not generate
 org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.7
 org.eclipse.jdt.core.compiler.codegen.unusedLocal=preserve
 org.eclipse.jdt.core.compiler.compliance=1.7
diff --git a/spring-security-rest-full/.settings/org.eclipse.wst.common.component b/spring-security-rest-full/.settings/org.eclipse.wst.common.component
@@ -5,6 +5,8 @@
         <wb-resource deploy-path="/WEB-INF/classes" source-path="/src/main/java"/>
         <wb-resource deploy-path="/WEB-INF/classes" source-path="/src/main/resources"/>
         <wb-resource deploy-path="/WEB-INF/classes" source-path="/target/generated-sources/java"/>
+        <wb-resource deploy-path="/WEB-INF/classes" source-path="/src/test/resources"/>
+        <wb-resource deploy-path="/WEB-INF/classes" source-path="/src/test/java"/>
         <property name="context-root" value="spring-security-rest-full"/>
         <property name="java-output-path" value="/spring-security-rest-full/target/classes"/>
     </wb-module>
diff --git a/spring-security-rest-full/pom.xml b/spring-security-rest-full/pom.xml
@@ -327,7 +327,7 @@
 				</configuration>
 			</plugin>
 
-			<!-- Querydsl -->
+			<!-- Querydsl and Specifications -->
 			
 			<plugin>
 			    <groupId>com.mysema.maven</groupId>
diff --git a/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/MyUserPredicatesBuilder.java b/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/MyUserPredicatesBuilder.java
@@ -8,7 +8,21 @@
 import com.mysema.query.types.expr.BooleanExpression;
 
 public class MyUserPredicatesBuilder {
-    public static BooleanExpression buildUserPredicates(final List<SearchCriteria> params) {
+    private List<SearchCriteria> params;
+
+    public MyUserPredicatesBuilder() {
+        params = new ArrayList<SearchCriteria>();
+    }
+
+    public MyUserPredicatesBuilder with(final String key, final String operation, final Object value) {
+        final MyUserPredicatesBuilder builder = new MyUserPredicatesBuilder();
+        final List<SearchCriteria> newParams = new ArrayList<SearchCriteria>(params);
+        newParams.add(new SearchCriteria(key, operation, value));
+        builder.params = newParams;
+        return builder;
+    }
+
+    public BooleanExpression build() {
         if (params.size() == 0)
             return null;
 
diff --git a/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/UserSpecification.java b/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/UserSpecification.java
@@ -11,11 +11,7 @@
 
 public class UserSpecification implements Specification<User> {
 
-    private SearchCriteria criteria;
-
-    public UserSpecification() {
-
-    }
+    private final SearchCriteria criteria;
 
     public UserSpecification(final SearchCriteria criteria) {
         super();
@@ -26,10 +22,6 @@ public SearchCriteria getCriteria() {
         return criteria;
     }
 
-    public void setCriteria(final SearchCriteria criteria) {
-        this.criteria = criteria;
-    }
-
     @Override
     public Predicate toPredicate(final Root<User> root, final CriteriaQuery<?> query, final CriteriaBuilder builder) {
         if (criteria.getOperation().equalsIgnoreCase(">")) {
@@ -38,7 +30,7 @@ public Predicate toPredicate(final Root<User> root, final CriteriaQuery<?> query
             return builder.lessThanOrEqualTo(root.<String> get(criteria.getKey()), criteria.getValue().toString());
         } else if (criteria.getOperation().equalsIgnoreCase(":")) {
             if (root.get(criteria.getKey()).getJavaType() == String.class) {
-                return builder.like(root.<String>get(criteria.getKey()), "%" + criteria.getValue() + "%");
+                return builder.like(root.<String> get(criteria.getKey()), "%" + criteria.getValue() + "%");
             } else {
                 return builder.equal(root.get(criteria.getKey()), criteria.getValue());
             }
diff --git a/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/UserSpecificationsBuilder.java b/spring-security-rest-full/src/main/java/org/baeldung/persistence/dao/UserSpecificationsBuilder.java
@@ -10,7 +10,21 @@
 
 public class UserSpecificationsBuilder {
 
-    public static Specification<User> buildUserSpecs(final List<SearchCriteria> params) {
+    private List<SearchCriteria> params;
+
+    public UserSpecificationsBuilder() {
+        params = new ArrayList<SearchCriteria>();
+    }
+
+    public UserSpecificationsBuilder with(final String key, final String operation, final Object value) {
+        final UserSpecificationsBuilder builder = new UserSpecificationsBuilder();
+        final List<SearchCriteria> newParams = new ArrayList<SearchCriteria>(params);
+        newParams.add(new SearchCriteria(key, operation, value));
+        builder.params = newParams;
+        return builder;
+    }
+
+    public Specification<User> build() {
         if (params.size() == 0)
             return null;
 
diff --git a/spring-security-rest-full/src/main/java/org/baeldung/persistence/service/impl/UserService.java b/spring-security-rest-full/src/main/java/org/baeldung/persistence/service/impl/UserService.java
diff --git a/spring-security-rest-full/src/main/java/org/baeldung/web/controller/UserController.java b/spring-security-rest-full/src/main/java/org/baeldung/web/controller/UserController.java
@@ -5,26 +5,35 @@
 import java.util.regex.Matcher;
 import java.util.regex.Pattern;
 
+import org.baeldung.persistence.dao.IUserDAO;
+import org.baeldung.persistence.dao.MyUserPredicatesBuilder;
+import org.baeldung.persistence.dao.MyUserRepository;
+import org.baeldung.persistence.dao.UserRepository;
+import org.baeldung.persistence.dao.UserSpecificationsBuilder;
 import org.baeldung.persistence.model.MyUser;
 import org.baeldung.persistence.model.User;
-import org.baeldung.persistence.service.impl.MyUserService;
-import org.baeldung.persistence.service.impl.UserService;
 import org.baeldung.web.util.SearchCriteria;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.jpa.domain.Specification;
 import org.springframework.stereotype.Controller;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RequestParam;
 import org.springframework.web.bind.annotation.ResponseBody;
 
+import com.mysema.query.types.expr.BooleanExpression;
+
 @Controller
 public class UserController {
 
     @Autowired
-    private UserService service;
+    private IUserDAO service;
+
+    @Autowired
+    private UserRepository dao;
 
     @Autowired
-    private MyUserService myService;
+    private MyUserRepository mydao;
 
     public UserController() {
         super();
@@ -47,32 +56,39 @@ public List<User> findAll(@RequestParam(value = "search", required = false) fina
 
     @RequestMapping(method = RequestMethod.GET, value = "/users/spec")
     @ResponseBody
-    public List<User> findAllBySpecification(@RequestParam(value = "search", required = false) final String search) {
-        final List<SearchCriteria> params = new ArrayList<SearchCriteria>();
-
+    public List<User> findAllBySpecification(@RequestParam(value = "search") final String search) {
+        UserSpecificationsBuilder builder = new UserSpecificationsBuilder();
         if (search != null) {
             final Pattern pattern = Pattern.compile("(\\w+?)(:|<|>)(\\w+?),");
             final Matcher matcher = pattern.matcher(search + ",");
             while (matcher.find()) {
-                params.add(new SearchCriteria(matcher.group(1), matcher.group(2), matcher.group(3)));
+                builder = builder.with(matcher.group(1), matcher.group(2), matcher.group(3));
             }
         }
-        return service.searchBySpecification(params);
+        final Specification<User> spec = builder.build();
+        if (spec == null)
+            return dao.findAll();
+        else
+            return dao.findAll(spec);
     }
 
     @RequestMapping(method = RequestMethod.GET, value = "/myusers")
     @ResponseBody
-    public Iterable<MyUser> findAllByQuerydsl(@RequestParam(value = "search", required = false) final String search) {
-        final List<SearchCriteria> params = new ArrayList<SearchCriteria>();
+    public Iterable<MyUser> findAllByQuerydsl(@RequestParam(value = "search") final String search) {
+        MyUserPredicatesBuilder builder = new MyUserPredicatesBuilder();
 
         if (search != null) {
             final Pattern pattern = Pattern.compile("(\\w+?)(:|<|>)(\\w+?),");
             final Matcher matcher = pattern.matcher(search + ",");
             while (matcher.find()) {
-                params.add(new SearchCriteria(matcher.group(1), matcher.group(2), matcher.group(3)));
+                builder = builder.with(matcher.group(1), matcher.group(2), matcher.group(3));
             }
         }
-        return myService.search(params);
+        final BooleanExpression exp = builder.build();
+        if (exp == null)
+            return mydao.findAll();
+        else
+            return mydao.findAll(exp);
     }
 
     @RequestMapping(method = RequestMethod.GET, value = "/users/new")
@@ -83,7 +99,7 @@ public long addUser(@RequestParam("first") final String first, @RequestParam("la
         user.setLastName(last);
         user.setEmail("john@doe.com");
         user.setAge(age);
-        service.saveUser(user);
+        dao.save(user);
         return user.getId();
     }
 
@@ -95,7 +111,7 @@ public long addMyUser(@RequestParam("first") final String first, @RequestParam("
         user.setLastName(last);
         user.setEmail("john@doe.com");
         user.setAge(age);
-        myService.save(user);
+        mydao.save(user);
         return user.getId();
     }
 }
diff --git a/spring-security-rest-full/src/test/java/org/baeldung/persistence/query/JPAQuerydslTest.java b/spring-security-rest-full/src/test/java/org/baeldung/persistence/query/JPAQuerydslTest.java
