Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/Building.java @ 5838:5aa05a7a34b7
Rename modules to more fitting names.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 25 Apr 2013 15:23:37 +0200 |
parents | flys-backend/src/main/java/org/dive4elements/river/model/Building.java@18619c1e7c2a |
children | 4dd33b86dc61 |
comparison
equal
deleted
inserted
replaced
5837:d9901a08d0a6 | 5838:5aa05a7a34b7 |
---|---|
1 package org.dive4elements.river.model; | |
2 | |
3 import java.io.Serializable; | |
4 import java.util.List; | |
5 | |
6 import javax.persistence.Column; | |
7 import javax.persistence.Entity; | |
8 import javax.persistence.Id; | |
9 import javax.persistence.JoinColumn; | |
10 import javax.persistence.OneToOne; | |
11 import javax.persistence.Table; | |
12 | |
13 import org.hibernate.Session; | |
14 import org.hibernate.Query; | |
15 import org.hibernate.annotations.Type; | |
16 | |
17 import com.vividsolutions.jts.geom.LineString; | |
18 | |
19 import org.dive4elements.river.backend.SessionHolder; | |
20 | |
21 | |
22 @Entity | |
23 @Table(name = "buildings") | |
24 public class Building | |
25 implements Serializable | |
26 { | |
27 private Integer id; | |
28 private River river; | |
29 private String name; | |
30 private LineString geom; | |
31 | |
32 public Building() { | |
33 } | |
34 | |
35 | |
36 @Id | |
37 @Column(name = "id") | |
38 public Integer getId() { | |
39 return id; | |
40 } | |
41 | |
42 | |
43 public void setId(Integer id) { | |
44 this.id = id; | |
45 } | |
46 | |
47 | |
48 @OneToOne | |
49 @JoinColumn(name = "river_id") | |
50 public River getRiver() { | |
51 return river; | |
52 } | |
53 | |
54 | |
55 public void setRiver(River river) { | |
56 this.river = river; | |
57 } | |
58 | |
59 | |
60 @Column(name = "name") | |
61 public String getName() { | |
62 return name; | |
63 } | |
64 | |
65 | |
66 public void setName(String name) { | |
67 this.name = name; | |
68 } | |
69 | |
70 | |
71 @Column(name = "geom") | |
72 @Type(type = "org.hibernatespatial.GeometryUserType") | |
73 public LineString getGeom() { | |
74 return geom; | |
75 } | |
76 | |
77 | |
78 public void setGeom(LineString geom) { | |
79 this.geom = geom; | |
80 } | |
81 | |
82 public static List<Building> getBuildings(int riverId, int kindId) { | |
83 Session session = SessionHolder.HOLDER.get(); | |
84 | |
85 Query query = session.createQuery( | |
86 "from Building where river.id =:river_id and kind_id=:kind_id"); | |
87 query.setParameter("kind_id", kindId); | |
88 query.setParameter("river_id", riverId); | |
89 | |
90 return query.list(); | |
91 } | |
92 | |
93 public static List<Building> getBuildings(int riverId, String name) { | |
94 Session session = SessionHolder.HOLDER.get(); | |
95 | |
96 Query query = session.createQuery( | |
97 "from Building where river.id =:river_id and name=:name"); | |
98 query.setParameter("river_id", riverId); | |
99 query.setParameter("name", name); | |
100 | |
101 return query.list(); | |
102 } | |
103 } | |
104 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |