Interacting with Databases through the Java Persistence API - Java EE 7 Development with NetBeans 8 - page 157

@NamedQuery(name = "CustomerOrder.findAll",
query = "SELECT c FROM CustomerOrder c"),
@NamedQuery(name = "CustomerOrder.findByCustomerOrderId",
query = "SELECT c FROM CustomerOrder c WHERE c.customerOrderId =
:customerOrderId"),
@NamedQuery(name = "CustomerOrder.findByOrderNumber",
query = "SELECT c FROM CustomerOrder c WHERE c.orderNumber =
:orderNumber"),
@NamedQuery(name = "CustomerOrder.findByOrderDescription",
query = "SELECT c FROM CustomerOrder c WHERE c.orderDescription
= :orderDescription")})
public class CustomerOrder implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@NotNull
@Column(name = "CUSTOMER_ORDER_ID")
private Integer customerOrderId;
@Size(max = 10)
@Column(name = "ORDER_NUMBER")
private String orderNumber;
@Size(max = 200)
@Column(name = "ORDER_DESCRIPTION")
private String orderDescription;
@JoinTable(name = "ORDER_ITEM", joinColumns = {
@JoinColumn(name = "CUSTOMER_ORDER_ID",
referencedColumnName = "CUSTOMER_ORDER_ID")},
inverseJoinColumns = {
@JoinColumn(name = "ITEM_ID",
referencedColumnName = "ITEM_ID")})
@ManyToMany
private Collection<Item> itemCollection;
@JoinColumn(name = "CUSTOMER_ID", referencedColumnName =
"CUSTOMER_ID")
@ManyToOne
private Customer customer;
//generated constructors and methods omitted for brevity.
}