blob: 090ca284e1775aca229ddb703968da855aaf077e [file] [log] [blame]
package jpql.query;
import java.io.Serializable;
import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
@Entity
@NamedQueries
({
@NamedQuery(name = "dept.and.multiple", query = "DELETE FROM Dept d WHERE d.dname = 'DEPT A' AND d.role = 'ROLE A' AND d.loc = 'LOCATION A'"),
@NamedQuery(name = "dept.findAll", query = "select o from Dept o"),
@NamedQuery(name = "dept.dname", query = "select o from Dept o where o.dname in (:dname1, :dname2, :dname3)"),
@NamedQuery(name = "dept.floorNumber", query = "select d.floorNumber from Dept d"),
@NamedQuery(name = "dept.new1", query = "SELECT NEW java.util.Vector(d.dname) FROM Dept d")
})
@SuppressWarnings("unused")
public class Dept implements Serializable {
@Id
@Column(nullable = false)
private Long deptno;
@Column(length = 14)
private String dname;
@OneToMany(mappedBy = "dept")
private List<Employee> empList;
private int floorNumber;
@Column(length = 13)
private String loc;
private String role;
}