Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- openjpa: 2.2.2
- Spring framework(orm, test, context, etc..): 4.1.1.RELEASE
- spring-data-jpa: 1.3.0.RELEASE
- postgres-jdbc: 9.4-1201-jdbc41
- jdk: 1.7
- openjpa: 2.4.1
- Spring framework(orm, test, context, etc..): 4.3.0.RELEASE
- spring-data-jpa: 1.10.2.RELEASE
- postgres-jdbc: 9.4-1208
- jdk: 1.8
- List<Subtask> subtasks = this.subtaskDao.findByDeviceId("1000000002");
- print(subtasks);
- List<Subtask> subtasks1 = this.subtaskDao.findByDeviceId("1000000003");
- print(subtasks1);
- List<Subtask> subtasks2 = this.subtaskDao.findByDeviceId("1000000004");
- print(subtasks2);enter code here
- @Query("SELECT entity FROM Subtask as entity WHERE entity.deviceId IN :deviceIdList AND entity.state IN :states")
- public List<Subtask> findByDeviceIdInAndStateInOrderByIdAsc(@Param("deviceIdList") Collection<String> deviceIdList, @Param("states") Collection<Integer> states);
- @NoRepositoryBean
- public interface DaoBase<T extends EntityBase, ID extends Serializable> extends JpaRepository<T, ID>, JpaSpecificationExecutor<T>
- {}
- public interface SubtaskDao extends DaoBase<Subtask, Long>
- {
- public List<Subtask> findByDeviceIdInAndStateInOrderByIdAsc(Collection<String> deviceIdList, Collection<Integer> states);
- }
- List<Subtask> subtasks = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000002"}), Arrays.asList(new Integer[]{5,10}));
- System.out.println("1" + subtasks);
- print(subtasks);
- List<Subtask> subtasks1 = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000003"}), Arrays.asList(new Integer[]{5,10}));
- System.out.println("2" + subtasks1);
- print(subtasks1);
- List<Subtask> subtasks2 = this.subtaskDao.findByDeviceIdInAndStateInOrderByIdAsc(Arrays.asList(new String[]{"1000000004"}), Arrays.asList(new Integer[]{5,10}));
- System.out.println("3" + subtasks2);
- print(subtasks2);
- private void print(List<Subtask> subtasks)
- {
- for (Subtask subtask : subtasks)
- {
- System.out.println(subtask.getId() + ", " + subtask.getDeviceId());
- }
- }
- 1[devicemanage.repository.appdeploy.entity.Subtask@3b01897f, devicemanage.repository.appdeploy.entity.Subtask@6b3b2c34]
- 444, 1000000002
- 2[devicemanage.repository.appdeploy.entity.Subtask@4377ed24, devicemanage.repository.appdeploy.entity.Subtask@7a30e30b]
- 447, 1000000003
- 449, 1000000003
- 3[devicemanage.repository.appdeploy.entity.Subtask@b339a08, devicemanage.repository.appdeploy.entity.Subtask@1d556461]
- 410, 1000000004
- 1[devicemanage.repository.appdeploy.entity.Subtask@77a9ac36, devicemanage.repository.appdeploy.entity.Subtask@3c743d40]
- 444, 1000000002
- 2[devicemanage.repository.appdeploy.entity.Subtask@3a5ce4b8, devicemanage.repository.appdeploy.entity.Subtask@38848217]
- 444, 1000000002
- 3[devicemanage.repository.appdeploy.entity.Subtask@511d5e6e, devicemanage.repository.appdeploy.entity.Subtask@7a78d380]
- 444, 1000000002
- <dependency>
- <groupId>org.postgresql</groupId>
- <artifactId>postgresql</artifactId>
- <version>9.4-1201-jdbc41</version>
- </dependency>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement