Mercurial > dive4elements > river
view flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/AnnotationsFactory.java @ 304:992afc0299cd
Bugfix: Repaired the dynamic UI part of the RiverSelect state in DESCRIBE.
flys-artifacts/trunk@1675 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Wed, 13 Apr 2011 08:31:20 +0000 |
parents | 1a00cb4998a8 |
children | ea3a438a7021 |
line wrap: on
line source
package de.intevation.flys.artifacts.model; import java.util.List; import de.intevation.flys.backend.SessionFactoryProvider; import de.intevation.flys.model.Annotation; import de.intevation.flys.model.Range; import de.intevation.flys.model.River; import org.hibernate.SessionFactory; import org.hibernate.Session; import org.hibernate.Query; /** * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a> */ public class AnnotationsFactory { public static List<Annotation> getAnnotations(River river) { return getAnnotations(river.getName()); } public static List<Annotation> getAnnotations(String river) { SessionFactory sf = SessionFactoryProvider.getSessionFactory(); Session session = sf.openSession(); try { Query rangesQuery = session.createQuery( "from Range where river.name=:name"); rangesQuery.setParameter("name", river); List<Range> ranges = rangesQuery.list(); Query query = session.createQuery( "from Annotation where range in (:ranges)"); query.setParameterList("ranges", ranges); return query.list(); } finally { session.close(); } } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :