package entity.server;


import javax.persistence.*;

@Entity
@Table(name="person")
@NamedQueries(value={
   @NamedQuery(name= "Person.byName", query = "select p from Person p where name = :name order by p.name"),
   @NamedQuery(name= "Person.allPersons", query = "select p from Person p order by p.name"),
   @NamedQuery(name= "Person.byId", query = "select p from Person p where p.personId = :personId")
})

public class Person {
   
   @Id
   @Column(name="PERSONID")
   private int personId;
   public int getId(){return this.personId;}
   public void setId(int personId){this.personId = personId;}
   
   @Column(name="NAME")
   private String name;
   public String getName() {return name;}
   public void setName(String newName) {this.name = newName;}
   
   @Column(name="MAXBOOKS")
   private int maximumBooks;
   public int getMaximumBooks() {return maximumBooks;}
   public void setMaximumBooks(int maximumBooks) {this.maximumBooks = maximumBooks;}