blob: f3319ed7423bbf933819b614d535d3b33f47f30a [file] [log] [blame]
/*
* Copyright (c) 2018, 2021 Oracle and/or its affiliates. All rights reserved.
*
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v. 2.0 which is available at
* http://www.eclipse.org/legal/epl-2.0,
* or the Eclipse Distribution License v. 1.0 which is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
*/
package jpql.query;
import java.io.Serializable;
import java.util.List;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.Id;
import jakarta.persistence.NamedQueries;
import jakarta.persistence.NamedQuery;
import jakarta.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 {
private static final long serialVersionUID = 4238076584091468481L;
@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;
}