Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/Catchment.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 | a6ef300748c4 |
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.Geometry; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "catchment") public class Catchment implements Serializable { private Integer id; private BigDecimal area; private String name; private River river; private Geometry geom; public Catchment() { } @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 = "name") public String getName() { return name; } public void setName(String name) { this.name = name; } @Column(name = "area") public BigDecimal getArea() { return area; } public void setArea(BigDecimal area) { this.area = area; } @Column(name = "geom") @Type(type = "org.hibernatespatial.GeometryUserType") public Geometry getGeom() { return geom; } public void setGeom(Geometry geom) { this.geom = geom; } public static List<Catchment> getCatchments(int riverId, String name) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from Catchment where river.id =:river_id AND name=:name"); query.setParameter("river_id", riverId); query.setParameter("name", name); return query.list(); } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :