Mercurial > dive4elements > river
comparison flys-backend/src/main/java/de/intevation/flys/model/BedHeightEpoch.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 | 04eeb45df27b |
children | 444e52222941 |
comparison
equal
deleted
inserted
replaced
2871:5a89c2b05e6d | 2872:bcfdaa3a5bfc |
---|---|
13 import javax.persistence.SequenceGenerator; | 13 import javax.persistence.SequenceGenerator; |
14 import javax.persistence.GenerationType; | 14 import javax.persistence.GenerationType; |
15 import javax.persistence.JoinColumn; | 15 import javax.persistence.JoinColumn; |
16 import javax.persistence.OneToOne; | 16 import javax.persistence.OneToOne; |
17 import javax.persistence.OneToMany; | 17 import javax.persistence.OneToMany; |
18 | |
19 import org.hibernate.Session; | |
20 import org.hibernate.Query; | |
21 | |
22 import de.intevation.flys.backend.SessionHolder; | |
18 | 23 |
19 | 24 |
20 @Entity | 25 @Entity |
21 @Table(name = "bed_height_epoch") | 26 @Table(name = "bed_height_epoch") |
22 public class BedHeightEpoch implements Serializable { | 27 public class BedHeightEpoch implements Serializable { |
154 } | 159 } |
155 | 160 |
156 public void setValues(List<BedHeightEpochValue> values) { | 161 public void setValues(List<BedHeightEpochValue> values) { |
157 this.values = values; | 162 this.values = values; |
158 } | 163 } |
164 | |
165 | |
166 public static List<BedHeightEpoch> getBedHeightEpochs(River river) { | |
167 Session session = SessionHolder.HOLDER.get(); | |
168 | |
169 Query query = session.createQuery( | |
170 "from BedHeightEpoch where river=:river"); | |
171 | |
172 query.setParameter("river", river); | |
173 | |
174 return query.list(); | |
175 } | |
176 | |
177 | |
178 public static BedHeightEpoch getBedHeightEpochById(int id) { | |
179 Session session = SessionHolder.HOLDER.get(); | |
180 | |
181 Query query = session.createQuery( | |
182 "from BedHeightEpoch where id=:id"); | |
183 | |
184 query.setParameter("id", id); | |
185 | |
186 List<BedHeightEpoch> singles = query.list(); | |
187 | |
188 return singles != null ? singles.get(0) : null; | |
189 } | |
159 } | 190 } |
160 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 191 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |