diff flys-backend/src/main/java/de/intevation/flys/model/HWSPoint.java @ 5349:d43ef9f709cd

Add HWSLines and HWSPoints to datacage for the map
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 20 Mar 2013 16:37:02 +0100
parents 0a83a796f7cf
children
line wrap: on
line diff
--- a/flys-backend/src/main/java/de/intevation/flys/model/HWSPoint.java	Wed Mar 20 16:35:47 2013 +0100
+++ b/flys-backend/src/main/java/de/intevation/flys/model/HWSPoint.java	Wed Mar 20 16:37:02 2013 +0100
@@ -3,6 +3,7 @@
 import com.vividsolutions.jts.geom.Geometry;
 
 import java.io.Serializable;
+import java.util.List;
 
 import java.math.BigDecimal;
 
@@ -17,6 +18,10 @@
 import javax.persistence.SequenceGenerator;
 
 import org.hibernate.annotations.Type;
+import org.hibernate.Session;
+import org.hibernate.Query;
+
+import de.intevation.flys.backend.SessionHolder;
 
 @Entity
 @Table(name = "hws_points")
@@ -437,5 +442,16 @@
     {
         this.river = river;
     }
+
+    public static List<HWSPoint> getPoints(int riverId, String name) {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+                    "from HWSPoint where river.id =:river_id and name=:name");
+        query.setParameter("river_id", riverId);
+        query.setParameter("name", name);
+
+        return query.list();
+    }
 }
 

http://dive4elements.wald.intevation.org