Advertisement
Guest User

Untitled

a guest
Jun 20th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.02 KB | None | 0 0
  1. openjpa: 2.2.2
  2. Spring framework(orm, test, context, etc..): 4.1.1.RELEASE
  3. spring-data-jpa: 1.3.0.RELEASE
  4. postgres-jdbc: 9.4-1201-jdbc41
  5. jdk: 1.7
  6.  
  7. openjpa: 2.4.1
  8. Spring framework(orm, test, context, etc..): 4.3.0.RELEASE
  9. spring-data-jpa: 1.10.2.RELEASE
  10. postgres-jdbc: 9.4-1208
  11. jdk: 1.8
  12.  
  13. List<Subtask> subtasks = this.subtaskDao.findByDeviceId("1000000002");
  14. print(subtasks);
  15. List<Subtask> subtasks1 = this.subtaskDao.findByDeviceId("1000000003");
  16. print(subtasks1);
  17. List<Subtask> subtasks2 = this.subtaskDao.findByDeviceId("1000000004");
  18. print(subtasks2);enter code here
  19.  
  20. @Query("SELECT entity FROM Subtask as entity WHERE entity.deviceId IN :deviceIdList AND entity.state IN :states")
  21. public List<Subtask> findByDeviceIdInAndStateInOrderByIdAsc(@Param("deviceIdList") Collection<String> deviceIdList, @Param("states") Collection<Integer> states);
  22.  
  23. @NoRepositoryBean
  24. public interface DaoBase<T extends EntityBase, ID extends Serializable> extends JpaRepository<T, ID>, JpaSpecificationExecutor<T>
  25. {}
  26.  
  27. public interface SubtaskDao extends DaoBase<Subtask, Long>
  28. {
  29. public List<Subtask> findByDeviceIdInAndStateInOrderByIdAsc(Collection<String> deviceIdList, Collection<Integer> states);
  30. }
  31.  
  32. List<Subtask> subtasks = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000002"}), Arrays.asList(new Integer[]{5,10}));
  33. System.out.println("1" + subtasks);
  34. print(subtasks);
  35. List<Subtask> subtasks1 = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000003"}), Arrays.asList(new Integer[]{5,10}));
  36. System.out.println("2" + subtasks1);
  37. print(subtasks1);
  38. List<Subtask> subtasks2 = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000004"}), Arrays.asList(new Integer[]{5,10}));
  39. System.out.println("3" + subtasks2);
  40. print(subtasks2);
  41.  
  42. private void print(List<Subtask> subtasks)
  43. {
  44. for (Subtask subtask : subtasks)
  45. {
  46. System.out.println(subtask.getId() + ", " + subtask.getDeviceId());
  47. }
  48. }
  49.  
  50. 1[devicemanage.repository.appdeploy.entity.Subtask@3b01897f, devicemanage.repository.appdeploy.entity.Subtask@6b3b2c34]
  51. 444, 1000000002
  52. 2[devicemanage.repository.appdeploy.entity.Subtask@4377ed24, devicemanage.repository.appdeploy.entity.Subtask@7a30e30b]
  53. 447, 1000000003
  54. 449, 1000000003
  55. 3[devicemanage.repository.appdeploy.entity.Subtask@b339a08, devicemanage.repository.appdeploy.entity.Subtask@1d556461]
  56. 410, 1000000004
  57.  
  58. 1[devicemanage.repository.appdeploy.entity.Subtask@77a9ac36, devicemanage.repository.appdeploy.entity.Subtask@3c743d40]
  59. 444, 1000000002
  60. 2[devicemanage.repository.appdeploy.entity.Subtask@3a5ce4b8, devicemanage.repository.appdeploy.entity.Subtask@38848217]
  61. 444, 1000000002
  62. 3[devicemanage.repository.appdeploy.entity.Subtask@511d5e6e, devicemanage.repository.appdeploy.entity.Subtask@7a78d380]
  63. 444, 1000000002
  64.  
  65. <dependency>
  66. <groupId>org.postgresql</groupId>
  67. <artifactId>postgresql</artifactId>
  68. <version>9.4-1201-jdbc41</version>
  69. </dependency>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement