Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2870:28526b0b0a90 | 2871:5a89c2b05e6d |
|---|---|
| 1 package de.intevation.flys.model; | 1 package de.intevation.flys.model; |
| 2 | 2 |
| 3 import java.io.Serializable; | 3 import java.io.Serializable; |
| 4 import java.math.BigDecimal; | 4 import java.math.BigDecimal; |
| 5 import java.util.List; | |
| 5 | 6 |
| 6 import javax.persistence.Entity; | 7 import javax.persistence.Entity; |
| 7 import javax.persistence.Id; | 8 import javax.persistence.Id; |
| 8 import javax.persistence.Table; | 9 import javax.persistence.Table; |
| 9 import javax.persistence.GeneratedValue; | 10 import javax.persistence.GeneratedValue; |
| 11 import javax.persistence.SequenceGenerator; | 12 import javax.persistence.SequenceGenerator; |
| 12 import javax.persistence.GenerationType; | 13 import javax.persistence.GenerationType; |
| 13 import javax.persistence.JoinColumn; | 14 import javax.persistence.JoinColumn; |
| 14 import javax.persistence.OneToOne; | 15 import javax.persistence.OneToOne; |
| 15 | 16 |
| 17 import org.hibernate.Session; | |
| 18 import org.hibernate.Query; | |
| 19 | |
| 16 import org.apache.log4j.Logger; | 20 import org.apache.log4j.Logger; |
| 21 | |
| 22 import de.intevation.flys.backend.SessionHolder; | |
| 17 | 23 |
| 18 | 24 |
| 19 @Entity | 25 @Entity |
| 20 @Table(name = "flow_velocity_model_values") | 26 @Table(name = "flow_velocity_model_values") |
| 21 public class FlowVelocityModelValue | 27 public class FlowVelocityModelValue |
| 125 } | 131 } |
| 126 | 132 |
| 127 public void setShearStress(BigDecimal shearStress) { | 133 public void setShearStress(BigDecimal shearStress) { |
| 128 this.shearStress = shearStress; | 134 this.shearStress = shearStress; |
| 129 } | 135 } |
| 136 | |
| 137 | |
| 138 public static List<FlowVelocityModelValue> getValues( | |
| 139 FlowVelocityModel model, | |
| 140 double kmLo, | |
| 141 double kmHi | |
| 142 ) { | |
| 143 Session session = SessionHolder.HOLDER.get(); | |
| 144 | |
| 145 Query query = session.createQuery( | |
| 146 "from FlowVelocityModelValue where " + | |
| 147 " flowVelocity=:model and" + | |
| 148 " station >= :kmLo and " + | |
| 149 " station <= :kmHi"); | |
| 150 | |
| 151 query.setParameter("model", model); | |
| 152 query.setParameter("kmLo", new BigDecimal(kmLo)); | |
| 153 query.setParameter("kmHi", new BigDecimal(kmHi)); | |
| 154 | |
| 155 return query.list(); | |
| 156 } | |
| 130 } | 157 } |
| 131 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 158 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |