Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/Jetty.java @ 5478:5bb3610b94f7
Schema Change: removed constraint that did not allow to have more than one measurement_type per station
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Wed, 27 Mar 2013 19:23:57 +0100 |
parents | b582df0c7b00 |
children |
line wrap: on
line source
package de.intevation.flys.model; import java.io.Serializable; import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.OneToOne; import javax.persistence.Table; import com.vividsolutions.jts.geom.Geometry; import org.hibernate.Session; import org.hibernate.Query; import org.hibernate.annotations.Type; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "jetties") public class Jetty implements Serializable { private Integer id; private River river; private Geometry geom; public Jetty() { } @Id @Column(name = "id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @OneToOne @JoinColumn(name = "river_id") public River getRiver() { return river; } public void setRiver(River river) { this.river = river; } @Column(name = "geom") @Type(type = "org.hibernatespatial.GeometryUserType") public Geometry getGeom() { return geom; } public void setGeom(Geometry geom) { this.geom = geom; } public static List<Jetty> getJetties(int riverId, int kindId) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from Jetty where river.id =:river_id and kind_id=:kind_id"); query.setParameter("kind_id", kindId); query.setParameter("river_id", riverId); return query.list(); } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :