Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/DischargeTable.java @ 6692:ce691d22cee3
issue1891: Add method to get a discharge table by it's id
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Mon, 29 Jul 2013 12:17:11 +0200 |
| parents | 4c3ccf2b0304 |
| children | ff27548d078c |
comparison
equal
deleted
inserted
replaced
| 6691:f41ba63e7a43 | 6692:ce691d22cee3 |
|---|---|
| 21 import javax.persistence.OneToMany; | 21 import javax.persistence.OneToMany; |
| 22 import javax.persistence.OneToOne; | 22 import javax.persistence.OneToOne; |
| 23 import javax.persistence.OrderBy; | 23 import javax.persistence.OrderBy; |
| 24 import javax.persistence.SequenceGenerator; | 24 import javax.persistence.SequenceGenerator; |
| 25 import javax.persistence.Table; | 25 import javax.persistence.Table; |
| 26 | |
| 27 import org.hibernate.Session; | |
| 28 import org.hibernate.Query; | |
| 29 import org.dive4elements.river.backend.SessionHolder; | |
| 26 | 30 |
| 27 @Entity | 31 @Entity |
| 28 @Table(name = "discharge_tables") | 32 @Table(name = "discharge_tables") |
| 29 public class DischargeTable | 33 public class DischargeTable |
| 30 implements Serializable, Comparable<DischargeTable> | 34 implements Serializable, Comparable<DischargeTable> |
| 195 } | 199 } |
| 196 else { | 200 else { |
| 197 return 0; | 201 return 0; |
| 198 } | 202 } |
| 199 } | 203 } |
| 204 | |
| 205 public static DischargeTable getDischargeTableById(int dtId) | |
| 206 { | |
| 207 Session session = SessionHolder.HOLDER.get(); | |
| 208 Query query = session.createQuery( | |
| 209 "from DischargeTable where id =:dtId"); | |
| 210 query.setParameter("dtId", dtId); | |
| 211 | |
| 212 List<DischargeTable> list = query.list(); | |
| 213 return list.isEmpty() ? null : list.get(0); | |
| 214 } | |
| 200 } | 215 } |
| 201 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 216 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |