package ywcai.ls.entity;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.OrderBy;
import javax.persistence.Table;
@Entity
@Table(name="user")
public class User implements Serializable{
/**
* 
*/
private static final long serialVersionUID = -7383132326629943397L;
@Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    @Column(name="id")
    private Long id;
    @Column(name="username")
    private String username;
    @Column(name="password")
    private String password;
    @OneToMany(cascade={CascadeType.ALL},fetch=FetchType.EAGER,mappedBy="user")
   //特別注意：onetomany標(biāo)識(shí)這是級(jí)聯(lián)1對(duì)多的關(guān)系。cascade={CascadeType.ALL}表示主表的增查刪改都會(huì)直接通過(guò)關(guān)聯(lián)字段對(duì)從表進(jìn)行相應(yīng)操作。
   //例如刪除主表的一個(gè)user實(shí)例，從表與user相關(guān)聯(lián)roles將被刪除。
   //而fetch=FetchType.EAGER表示急加載，即指一旦主表進(jìn)行了相應(yīng)操作，則從表也將立即進(jìn)行相應(yīng)的級(jí)聯(lián)操作。
   //例如，一旦讀取了user表的某一個(gè)實(shí)例，則user會(huì)立即加載Roles；而fetch=FetchType.LAZY為懶加載，當(dāng)需要使用到getRolelist()方法時(shí)，才會(huì)讀取相關(guān)聯(lián)的級(jí)聯(lián)表數(shù)據(jù)
    @OrderBy(value= "id ASC")//獲取的角色信息根據(jù)角色表的id進(jìn)行升序排序
    private Set<Roles> rolelist;
    
public Set<Roles> getRolelist() {
return rolelist;
}
public void setRolelist(Set<Roles> rolelist) {
this.rolelist = rolelist;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
}

package ywcai.ls.entity;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
@Entity
@Table(name="roles")
public class Roles {
    @Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    @Column(name="id")
    private Long id;
    @Column(name="username")
    private String username;
    @Column(name="rolename")
    private String rolename;
    @ManyToOne(cascade={CascadeType.REFRESH},fetch=FetchType.LAZY)
    @JoinColumn(name="userid")//加入一列作為外鍵
    private User user;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getRolename() {
return rolename;
}
public void setRolename(String rolename) {
this.rolename = rolename;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}

@ManyToOne(cascade={CascadeType.REFRESH},fetch=FetchType.EAGER)

@Repository
@Table(name="roles")
@Qualifier("rolesRepository")
public interface RolesRepository extends JpaRepository<Roles, Long > {
@Transactional
int deleteByUsernameAndRolename(String username,String rolename);
}

@OneToMany(cascade = CascadeType.ALL,fetch = FetchType.LAZY,mappedBy="dcpDataServiceManage")
    private List<DcpDataServiceTableFieldEntity> dataServiceTableFieldList;

/**
     * 關(guān)聯(lián)的
     */
    @ManyToOne
    @JoinColumn(referencedColumnName = "gid")
    private DcpDataServiceManageEntity dcpDataServiceManage;