Greeting to all,
As I'm learning Java, JDBC and MySQL I reach one point where I would like to perform the following
I have 2 entites
class User {
private Long id;
private String username;
...
...
private Set<Team> teams;
Constructors /
Getter/Setter
Second Entity
class Team {
private Long id;
private String name;
private Set<Users> users
Constructors/Getter/Setters
in my mysql there are 3 tables corresponding to User/Team and hybrid table where is the relationship between them users_teams holding user_id and team_id
My question is is there is a way when I call a sql query to select 1 team and all users in that particular team and get the info with ResultSet and build the Team object with the set of the users
or I need to do couple of sql queries to get the info separately and build the object later ?
