--- a/flys-backend/src/main/java/de/intevation/flys/model/Building.java	Thu Nov 10 13:35:31 2011 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/Building.java	Thu Nov 10 13:58:33 2011 +0000
@@ -1,6 +1,7 @@
 package de.intevation.flys.model;
 
 import java.io.Serializable;
+import java.util.List;
 
 import javax.persistence.Column;
 import javax.persistence.Entity;
@@ -9,10 +10,14 @@
 import javax.persistence.OneToOne;
 import javax.persistence.Table;
 
+import org.hibernate.Session;
+import org.hibernate.Query;
 import org.hibernate.annotations.Type;
 
 import com.vividsolutions.jts.geom.LineString;
 
+import de.intevation.flys.backend.SessionHolder;
+
 
 @Entity
 @Table(name = "buildings")
@@ -73,5 +78,16 @@
     public void setGeom(LineString geom) {
         this.geom = geom;
     }
+
+
+    public static List<Building> getBuildings(int riverId) {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+            "from Building where river.id =:river_id");
+        query.setParameter("river_id", riverId);
+
+        return query.list();
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :