@Entity
@Table(name = "Player")
public class Player {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "sql_player")
@SequenceGenerator(name = "sql_player",sequenceName = "sql_player",allocationSize = 1,initialValue = 1)
private Integer pid;
@Column
private String pname;
@ManyToMany(mappedBy = "players")//cascade = CascadeType.ALL,
private Set<Game> games=new HashSet<Game>();
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public String getPname() {
return pname;
}
public void setPname(String pname) {
this.pname = pname;
}
public Set<Game> getGames() {
return games;
}
public void setGames(Set<Game> games) {
this.games = games;
}
}
@Entity
@Table(name = "Game")
public class Game {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "sql_Game")
@SequenceGenerator(name = "sql_Game",sequenceName = "sql_Game",allocationSize = 1,initialValue = 1)
private Integer gid;
@Column
private String gname;
@ManyToMany(cascade = CascadeType.ALL)
@JoinTable(name = "PG",joinColumns = {@JoinColumn(name = "gid")},inverseJoinColumns = {@JoinColumn(name = "pid")})
private Set<Player> players=new HashSet<Player>();
public Integer getGid() {
return gid;
}
public void setGid(Integer gid) {
this.gid = gid;
}
public String getGname() {
return gname;
}
public void setGname(String gname) {
this.gname = gname;
}
public Set<Player> getPlayers() {
return players;
}
public void setPlayers(Set<Player> players) {
this.players = players;
}
}