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 : |