/* * PersonEntity.java *  * PostGIS extension for PostgreSQL JDBC driver - EJB3 Tutorial *  * (C) 2006  Norman Barker <norman.barker@gmail.com> *  * This library is free software; you can redistribute it and/or modify it under * the terms of the GNU Lesser General Public License as published by the Free * Software Foundation, either version 2.1 of the License. *  * This library is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more * details. *  * You should have received a copy of the GNU Lesser General Public License * along with this library; if not, write to the Free Software Foundation, Inc., * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA or visit the web at * http://www.gnu.org. *  * $Id: PersonEntity.java 2500 2006-10-09 17:12:46Z mschaber $ */package org.postgis.ejb;import java.util.Date;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.NamedQuery;import javax.persistence.Table;import javax.persistence.Temporal;import javax.persistence.TemporalType;import org.hibernate.annotations.Type;import org.postgis.Geometry;@Entity@Table(name="people")@NamedQuery(name="findPerson",		query="SELECT DISTINCT OBJECT(p) FROM PersonEntity p WHERE ((p.name = :name) AND (p.surname = :surname)) ORDER BY p.date")public class PersonEntity {	private long id;	private String name;	private String surname;	private Geometry location;	private Date date;		@Id 	@GeneratedValue(strategy=GenerationType.IDENTITY)	@Column(name="id")	public long getId() {		return id;	}	public void setId(long id) {		this.id = id;	}		@Type(type = "org.postgis.hibernate.GeometryType")	@Column(name="location", columnDefinition="Geometry")	public Geometry getLocation() {		return location;	}	public void setLocation(Geometry location) {		this.location = location;	}		@Column(name="name")	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}		@Column(name="surname")	public String getSurname() {		return surname;	}	public void setSurname(String surname) {		this.surname = surname;	}		@Column(name="ingested")	@Temporal(TemporalType.TIMESTAMP)	public Date getDate() {		return date;	}		public void setDate(Date date) {		this.date = date;	}}