private Long plugId;
 private AuthUsers authUsers;
 private String plugName;

public TblSecure() {
}

@Id @GeneratedValue(strategy=IDENTITY)
@Column(name="plug_id", unique=true, nullable=false)
public Long getPlugId() {
    return this.plugId;
}

public void setPlugId(Long plugId) {
    this.plugId = plugId;
}

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="plug_user")
public AuthUsers getAuthUsers() {
    return this.authUsers;
}

public void setAuthUsers(AuthUsers authUsers) {
    this.authUsers = authUsers;
}


@Column(name="plug_name")
public String getPlugName() {
    return this.plugName;
}

public void setPlugName(String plugName) {
    this.plugName = plugName;
}

private Long id;
 private String username;
 private String passwd;
 private Set tblSecures = new HashSet(0);

public AuthUsers() {
}

@Id @GeneratedValue(strategy=IDENTITY)

@Column(name="id", unique=true, nullable=false)
public Long getId() {
    return this.id;
}

public void setId(Long id) {
    this.id = id;
}


@Column(name="username", unique=true, nullable=false, length=64)
public String getUsername() {
    return this.username;
}

public void setUsername(String username) {
    this.username = username;
}


@Column(name="passwd", nullable=false, length=64)
public String getPasswd() {
    return this.passwd;
}

public void setPasswd(String passwd) {
    this.passwd = passwd;
}

@OneToMany(fetch=FetchType.LAZY, mappedBy="authUsers")
public Set<TblSecure> getTblSecures() {
    return this.tblSecures;
}

public void setTblSecures(Set<TblSecure> tblSecures) {
    this.tblSecures = tblSecures;
}

Query query = session.createQuery("from TblSecure sec WHERE        sec.uathUser.username=:pUser AND sec.plugName=:pName AND     sec.plugSystem=:pSystem");

query.setParameter("pUser", "user");

query.setParameter("pName", "plugname");

query.setParameter("pSystem", "projectname");

List<TblSecure> result = query.list();

for(TblSecure sec2 : result){
 ///
}