Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. @Entity
  2. @Table(name="usergroup")
  3. public class UserGroup{
  4.  
  5. @Id
  6. @Column(name = "id")
  7. @GeneratedValue(strategy = GenerationType.IDENTITY)
  8. private Long id;
  9.  
  10. @Column(name="date")
  11. private Timestamp date;
  12.  
  13. @Column(name="name")
  14. private String name;
  15.  
  16. @OneToMany(mappedBy="userGroup",
  17. cascade= {CascadeType.PERSIST, CascadeType.MERGE,
  18. CascadeType.DETACH, CascadeType.REFRESH}, fetch = FetchType.LAZY)
  19. private List<User> users= new ArrayList<>();
  20.  
  21. //constructor, getter and setter
  22.  
  23. @Entity
  24. @Table(name="user")
  25. public class User{
  26.  
  27. @Id
  28. @Column(name = "id")
  29. @GeneratedValue(strategy = GenerationType.IDENTITY)
  30. private Long id;
  31.  
  32.  
  33. @Column(name = "name")
  34. private String name;
  35.  
  36. @ManyToOne(fetch = FetchType.LAZY, cascade= {CascadeType.PERSIST, CascadeType.MERGE,
  37. CascadeType.DETACH, CascadeType.REFRESH}, optional = false)
  38. @JoinColumn(name="user_group_id", referencedColumnName = "id")
  39. private UserGroup userGroup;
  40.  
  41. //constructor, getter and setter
  42.  
  43. public class ResponseFromDatabase {
  44. private Long id;
  45. private String groupName;
  46. private Timestamp date;
  47.  
  48. //constructor, getter and setter
  49.  
  50. @Query(value = "SELECT new com.java.test.ResponseFromDatabase(ug.id, ug.groupName, u.date) FROM UserGroup ug JOIN ug.users u WHERE u.id =:userGroupId ORDER BY u.date")
  51. List<ResponseFromDatabase > findAllUserInformation(@Param("userGroupId") Long userGroupId, @Param("date") Timestamp date;
  52. }
  53.  
  54. "Expected arguments are: long, String, java.util.Date"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement