Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/GaugesFactory.java @ 311:ea3a438a7021
Backend access: Static methods are using the SessionHolder, too.
flys-artifacts/trunk@1694 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 14 Apr 2011 13:15:16 +0000 |
| parents | 4eddbb219866 |
| children | 94c176fdcb89 |
comparison
equal
deleted
inserted
replaced
| 310:6d2c8915e22c | 311:ea3a438a7021 |
|---|---|
| 1 package de.intevation.flys.artifacts.model; | 1 package de.intevation.flys.artifacts.model; |
| 2 | 2 |
| 3 import java.util.List; | 3 import java.util.List; |
| 4 import java.util.ArrayList; | 4 import java.util.ArrayList; |
| 5 | 5 |
| 6 import de.intevation.flys.backend.SessionFactoryProvider; | |
| 7 | |
| 8 import de.intevation.flys.model.River; | 6 import de.intevation.flys.model.River; |
| 9 import de.intevation.flys.model.Gauge; | 7 import de.intevation.flys.model.Gauge; |
| 10 import de.intevation.flys.model.Range; | 8 import de.intevation.flys.model.Range; |
| 11 | 9 |
| 12 import org.hibernate.SessionFactory; | |
| 13 import org.hibernate.Session; | 10 import org.hibernate.Session; |
| 14 import org.hibernate.Query; | 11 import org.hibernate.Query; |
| 15 | 12 |
| 16 public class GaugesFactory | 13 public class GaugesFactory |
| 17 { | 14 { |
| 18 public static List<Gauge> getGauges(River river) { | 15 public static List<Gauge> getGauges(River river) { |
| 19 return getGauges(river.getName()); | 16 return getGauges(river.getName()); |
| 20 } | 17 } |
| 21 | 18 |
| 22 public static List<Gauge> getGauges(String river) { | 19 public static List<Gauge> getGauges(String river) { |
| 23 SessionFactory sf = SessionFactoryProvider.getSessionFactory(); | 20 Session session = SessionHolder.HOLDER.get(); |
| 24 Session session = sf.openSession(); | 21 Query query = session.createQuery( |
| 25 try { | 22 "from Gauge where river.name=:name"); |
| 26 Query query = session.createQuery( | 23 query.setParameter("name", river); |
| 27 "from Gauge where river.name=:name"); | 24 return query.list(); |
| 28 query.setParameter("name", river); | |
| 29 return query.list(); | |
| 30 } | |
| 31 finally { | |
| 32 session.close(); | |
| 33 } | |
| 34 } | 25 } |
| 35 | 26 |
| 36 public static List<Gauge> filterRanges( | 27 public static List<Gauge> filterRanges( |
| 37 List<Gauge> gauges, | 28 List<Gauge> gauges, |
| 38 List<double []> ranges | 29 List<double []> ranges |