Mercurial > dive4elements > river
diff flys-backend/src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java @ 2871:5a89c2b05e6d
Added functions to retrieve data from database.
flys-backend/trunk@4409 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Tue, 15 May 2012 14:19:55 +0000 |
parents | ac13e466a55e |
children |
line wrap: on
line diff
--- a/flys-backend/src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java Tue May 15 07:06:31 2012 +0000 +++ b/flys-backend/src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java Tue May 15 14:19:55 2012 +0000 @@ -2,6 +2,7 @@ import java.io.Serializable; import java.math.BigDecimal; +import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; @@ -13,8 +14,13 @@ import javax.persistence.JoinColumn; import javax.persistence.OneToOne; +import org.hibernate.Session; +import org.hibernate.Query; + import org.apache.log4j.Logger; +import de.intevation.flys.backend.SessionHolder; + @Entity @Table(name = "flow_velocity_model_values") @@ -127,5 +133,26 @@ public void setShearStress(BigDecimal shearStress) { this.shearStress = shearStress; } + + + public static List<FlowVelocityModelValue> getValues( + FlowVelocityModel model, + double kmLo, + double kmHi + ) { + Session session = SessionHolder.HOLDER.get(); + + Query query = session.createQuery( + "from FlowVelocityModelValue where " + + " flowVelocity=:model and" + + " station >= :kmLo and " + + " station <= :kmHi"); + + query.setParameter("model", model); + query.setParameter("kmLo", new BigDecimal(kmLo)); + query.setParameter("kmHi", new BigDecimal(kmHi)); + + return query.list(); + } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :