Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/Floodmark.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/Floodmark.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.math.BigDecimal; | |
5 import java.util.List; | |
6 | |
7 import javax.persistence.Column; | |
8 import javax.persistence.Entity; | |
9 import javax.persistence.Id; | |
10 import javax.persistence.JoinColumn; | |
11 import javax.persistence.OneToOne; | |
12 import javax.persistence.Table; | |
13 | |
14 import org.hibernate.Session; | |
15 import org.hibernate.Query; | |
16 import org.hibernate.annotations.Type; | |
17 | |
18 import com.vividsolutions.jts.geom.Point; | |
19 | |
20 import org.dive4elements.river.backend.SessionHolder; | |
21 | |
22 | |
23 @Entity | |
24 @Table(name = "flood_marks") | |
25 public class Floodmark | |
26 implements Serializable | |
27 { | |
28 private Integer id; | |
29 private River river; | |
30 private Integer z; | |
31 private Integer year; | |
32 private BigDecimal km; | |
33 private Point geom; | |
34 | |
35 public Floodmark() { | |
36 } | |
37 | |
38 | |
39 @Id | |
40 @Column(name = "id") | |
41 public Integer getId() { | |
42 return id; | |
43 } | |
44 | |
45 | |
46 public void setId(Integer id) { | |
47 this.id = id; | |
48 } | |
49 | |
50 | |
51 @OneToOne | |
52 @JoinColumn(name = "river_id") | |
53 public River getRiver() { | |
54 return river; | |
55 } | |
56 | |
57 | |
58 public void setRiver(River river) { | |
59 this.river = river; | |
60 } | |
61 | |
62 | |
63 @Column(name = "z") | |
64 public Integer getZ() { | |
65 return z; | |
66 } | |
67 | |
68 | |
69 public void setZ(Integer z) { | |
70 this.z = z; | |
71 } | |
72 | |
73 | |
74 @Column(name = "year") | |
75 public Integer getYear() { | |
76 return year; | |
77 } | |
78 | |
79 | |
80 public void setYear(Integer year) { | |
81 this.year = year; | |
82 } | |
83 | |
84 | |
85 @Column(name = "km") | |
86 public BigDecimal getKm() { | |
87 return km; | |
88 } | |
89 | |
90 | |
91 public void setKm(BigDecimal km) { | |
92 this.km = km; | |
93 } | |
94 | |
95 | |
96 @Column(name = "geom") | |
97 @Type(type = "org.hibernatespatial.GeometryUserType") | |
98 public Point getGeom() { | |
99 return geom; | |
100 } | |
101 | |
102 | |
103 public void setGeom(Point geom) { | |
104 this.geom = geom; | |
105 } | |
106 | |
107 public static List<Floodmark> getFloodmarks(int riverId) { | |
108 Session session = SessionHolder.HOLDER.get(); | |
109 | |
110 Query query = session.createQuery( | |
111 "from Floodmark where river.id =:river_id"); | |
112 query.setParameter("river_id", riverId); | |
113 | |
114 return query.list(); | |
115 } | |
116 | |
117 public static List<Floodmark> getFloodmarks(int riverId, int year) { | |
118 Session session = SessionHolder.HOLDER.get(); | |
119 | |
120 Query query = session.createQuery( | |
121 "from Floodmark where river.id =:river_id and year = :year"); | |
122 query.setParameter("river_id", riverId); | |
123 query.setParameter("year", year); | |
124 | |
125 return query.list(); | |
126 } | |
127 } | |
128 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | |
129 |