Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/RiverAxisKm.java @ 4173:7d4480c0e68e
Allow users to select the current relevant discharge table in historical discharge table calculattion.
In addition to this, the discharge tables in the helper panel displayed in the client is ordered in time.
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Thu, 18 Oct 2012 12:13:48 +0200 |
parents | 9df06b88c079 |
children |
line wrap: on
line source
package de.intevation.flys.model; import java.io.Serializable; import java.math.BigDecimal; 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 org.hibernate.Session; import org.hibernate.Query; import org.hibernate.annotations.Type; import com.vividsolutions.jts.geom.Point; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "river_axes_km") public class RiverAxisKm implements Serializable { private Integer id; private River river; private BigDecimal km; private Point geom; public RiverAxisKm() { } @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 = "km") public BigDecimal getKm() { return km; } public void setKm(BigDecimal km) { this.km = km; } @Column(name = "geom") @Type(type = "org.hibernatespatial.GeometryUserType") public Point getGeom() { return geom; } public void setGeom(Point geom) { this.geom = geom; } /** * Returns a list of RiverAxisKm objects for a given river. * * @param riverid The ID of a river in the database. * * @return a list of RiverAxisKm objects. */ public static List<RiverAxisKm> getRiverAxisKms(int riverid) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from RiverAxisKm where river.id =:riverid"); query.setParameter("riverid", riverid); List<RiverAxisKm> list = query.list(); return list; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :