Mercurial > dive4elements > river
comparison flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java @ 2872:bcfdaa3a5bfc
Added functions to BedHeightSingle and BedHeightEpoch to get instances from db by id or river.
flys-backend/trunk@4434 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Fri, 18 May 2012 07:01:47 +0000 |
parents | f283212966e8 |
children | 444e52222941 |
comparison
equal
deleted
inserted
replaced
2871:5a89c2b05e6d | 2872:bcfdaa3a5bfc |
---|---|
12 import javax.persistence.SequenceGenerator; | 12 import javax.persistence.SequenceGenerator; |
13 import javax.persistence.GenerationType; | 13 import javax.persistence.GenerationType; |
14 import javax.persistence.JoinColumn; | 14 import javax.persistence.JoinColumn; |
15 import javax.persistence.OneToOne; | 15 import javax.persistence.OneToOne; |
16 import javax.persistence.OneToMany; | 16 import javax.persistence.OneToMany; |
17 | |
18 import org.hibernate.Session; | |
19 import org.hibernate.Query; | |
20 | |
21 import de.intevation.flys.backend.SessionHolder; | |
17 | 22 |
18 | 23 |
19 @Entity | 24 @Entity |
20 @Table(name = "bed_height_single") | 25 @Table(name = "bed_height_single") |
21 public class BedHeightSingle implements Serializable { | 26 public class BedHeightSingle implements Serializable { |
214 } | 219 } |
215 | 220 |
216 public void setValues(List<BedHeightSingleValue> values) { | 221 public void setValues(List<BedHeightSingleValue> values) { |
217 this.values = values; | 222 this.values = values; |
218 } | 223 } |
224 | |
225 | |
226 public static List<BedHeightSingle> getBedHeightSingles(River river) { | |
227 Session session = SessionHolder.HOLDER.get(); | |
228 | |
229 Query query = session.createQuery( | |
230 "from BedHeightSingle where river=:river"); | |
231 | |
232 query.setParameter("river", river); | |
233 | |
234 return query.list(); | |
235 } | |
236 | |
237 | |
238 public static BedHeightSingle getBedHeightSingleById(int id) { | |
239 Session session = SessionHolder.HOLDER.get(); | |
240 | |
241 Query query = session.createQuery( | |
242 "from BedHeightSingle where id=:id"); | |
243 | |
244 query.setParameter("id", id); | |
245 | |
246 List<BedHeightSingle> singles = query.list(); | |
247 | |
248 return singles != null ? singles.get(0) : null; | |
249 } | |
219 } | 250 } |
220 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 251 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |