--- a/flys-backend/src/main/java/de/intevation/flys/model/Line.java	Wed Nov 09 16:25:20 2011 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/Line.java	Thu Nov 10 13:35:31 2011 +0000
@@ -2,6 +2,7 @@
 
 import java.io.Serializable;
 import java.math.BigDecimal;
+import java.util.List;
 
 import javax.persistence.Column;
 import javax.persistence.Entity;
@@ -10,10 +11,15 @@
 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 = "lines")
@@ -21,7 +27,7 @@
 implements   Serializable
 {
     private Integer    id;
-    private Integer    kind;
+    private String     kind;
     private River      river;
     private LineString geom;
     private BigDecimal z;
@@ -55,12 +61,12 @@
 
 
     @Column(name = "kind")
-    public Integer getKind() {
+    public String getKind() {
         return kind;
     }
 
 
-    public void setKind(Integer kind) {
+    public void setKind(String kind) {
         this.kind = kind;
     }
 
@@ -86,5 +92,16 @@
     public void setZ(BigDecimal z) {
         this.z = z;
     }
+
+
+    public static List<Line> getLines(int riverId) {
+        Session session = SessionHolder.HOLDER.get();
+
+        Query query = session.createQuery(
+            "from Line 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 :