Dept.java

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;
}