comparison flys-backend/src/main/java/de/intevation/flys/model/Building.java @ 2366:2246348ff90e

Added functions that return lists of Buildings/Fixpoints to according classes. flys-backend/trunk@3223 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Thu, 10 Nov 2011 13:58:33 +0000
parents e2deda3b77a7
children b6f94c5db89e
comparison
equal deleted inserted replaced
2365:60532f75396b 2366:2246348ff90e
1 package de.intevation.flys.model; 1 package de.intevation.flys.model;
2 2
3 import java.io.Serializable; 3 import java.io.Serializable;
4 import java.util.List;
4 5
5 import javax.persistence.Column; 6 import javax.persistence.Column;
6 import javax.persistence.Entity; 7 import javax.persistence.Entity;
7 import javax.persistence.Id; 8 import javax.persistence.Id;
8 import javax.persistence.JoinColumn; 9 import javax.persistence.JoinColumn;
9 import javax.persistence.OneToOne; 10 import javax.persistence.OneToOne;
10 import javax.persistence.Table; 11 import javax.persistence.Table;
11 12
13 import org.hibernate.Session;
14 import org.hibernate.Query;
12 import org.hibernate.annotations.Type; 15 import org.hibernate.annotations.Type;
13 16
14 import com.vividsolutions.jts.geom.LineString; 17 import com.vividsolutions.jts.geom.LineString;
18
19 import de.intevation.flys.backend.SessionHolder;
15 20
16 21
17 @Entity 22 @Entity
18 @Table(name = "buildings") 23 @Table(name = "buildings")
19 public class Building 24 public class Building
71 76
72 77
73 public void setGeom(LineString geom) { 78 public void setGeom(LineString geom) {
74 this.geom = geom; 79 this.geom = geom;
75 } 80 }
81
82
83 public static List<Building> getBuildings(int riverId) {
84 Session session = SessionHolder.HOLDER.get();
85
86 Query query = session.createQuery(
87 "from Building where river.id =:river_id");
88 query.setParameter("river_id", riverId);
89
90 return query.list();
91 }
76 } 92 }
77 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : 93 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org