Mercurial > dive4elements > river
annotate backend/src/main/java/org/dive4elements/river/model/HydrBoundaryPoly.java @ 8764:d5917ff74d8a
(issue1838) Get min and max directly from database.
The former implementation led to a connection leak.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 17 Aug 2015 10:18:05 +0200 |
parents | 4c3ccf2b0304 |
children | 5e38e2924c07 |
rev | line source |
---|---|
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
2 * Software engineering by Intevation GmbH |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
3 * |
5992
4c3ccf2b0304
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5844
diff
changeset
|
4 * This file is Free Software under the GNU AGPL (>=v3) |
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the |
5992
4c3ccf2b0304
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5844
diff
changeset
|
6 * documentation coming with Dive4Elements River for details. |
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
7 */ |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
8 |
5829
18619c1e7c2a
Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5828
diff
changeset
|
9 package org.dive4elements.river.model; |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
11 import java.io.Serializable; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
12 import java.util.List; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
13 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
14 import javax.persistence.Column; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
15 import javax.persistence.Entity; |
5098
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
16 import javax.persistence.GeneratedValue; |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
17 import javax.persistence.GenerationType; |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
18 import javax.persistence.Id; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 import javax.persistence.JoinColumn; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
20 import javax.persistence.OneToOne; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
21 import javax.persistence.Table; |
5098
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
22 import javax.persistence.SequenceGenerator; |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
23 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 import org.hibernate.Session; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
25 import org.hibernate.Query; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
26 import org.hibernate.annotations.Type; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
27 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
28 import com.vividsolutions.jts.geom.Geometry; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
29 |
5829
18619c1e7c2a
Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5828
diff
changeset
|
30 import org.dive4elements.river.backend.SessionHolder; |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
31 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
32 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 @Entity |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 @Table(name = "hydr_boundaries_poly") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
35 public class HydrBoundaryPoly |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
36 implements Serializable |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
38 private Integer id; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 private String name; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
40 private River river; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
41 private Geometry geom; |
5062
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
42 private SectieKind sectie; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
43 private SobekKind sobek; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
44 private BoundaryKind kind; |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
45 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
46 public HydrBoundaryPoly() { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
48 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
49 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
50 @Id |
5098
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
51 @SequenceGenerator( |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
52 name = "SEQUENCE_HYDR_BOUNDARIES_POLY_ID_SEQ", |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
53 sequenceName = "HYDR_BOUNDARIES_POLY_ID_SEQ", |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
54 allocationSize = 1) |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
55 @GeneratedValue( |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
56 strategy = GenerationType.SEQUENCE, |
a2600507761e
Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents:
5089
diff
changeset
|
57 generator = "SEQUENCE_HYDR_BOUNDARIES_POLY_ID_SEQ") |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
58 @Column(name = "id") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
59 public Integer getId() { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
60 return id; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
61 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
62 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
63 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
64 public void setId(Integer id) { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
65 this.id = id; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
66 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
67 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
68 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
69 @OneToOne |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
70 @JoinColumn(name = "river_id") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
71 public River getRiver() { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
72 return river; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
73 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
74 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
75 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
76 public void setRiver(River river) { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
77 this.river = river; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
78 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
79 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
80 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
81 @Column(name = "name") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
82 public String getName() { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
83 return name; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
84 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
85 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
86 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
87 public void setName(String name) { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
88 this.name = name; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
89 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
90 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
91 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
92 @Column(name = "geom") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
93 @Type(type = "org.hibernatespatial.GeometryUserType") |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
94 public Geometry getGeom() { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
95 return geom; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
96 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
97 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
98 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
99 public void setGeom(Geometry geom) { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
100 this.geom = geom; |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
101 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
102 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
103 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
104 public static List<HydrBoundaryPoly> getHydrBoundaries(int riverId, String name) { |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
105 Session session = SessionHolder.HOLDER.get(); |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
106 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
107 Query query = session.createQuery( |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
108 "from HydrBoundaryPoly where river.id =:river_id and name=:name"); |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
109 query.setParameter("river_id", riverId); |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
110 query.setParameter("name", name); |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
111 |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
112 return query.list(); |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
113 } |
5062
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
114 |
5515
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
115 public static List<HydrBoundaryPoly> getHydrBoundaries(int riverId, |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
116 int kind, int sectie, int sobek) { |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
117 Session session = SessionHolder.HOLDER.get(); |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
118 |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
119 String filter = " where river.id =:river_id"; |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
120 |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
121 if (kind != -1) { |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
122 filter += " and kind = " + kind; |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
123 } |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
124 if (sectie != -1) { |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
125 filter += " and sectie = " + sectie; |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
126 } |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
127 if (sobek != -1){ |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
128 filter += " and sobek = " + sobek; |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
129 } |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
130 |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
131 Query query = session.createQuery("from HydrBoundaryPoly" + filter); |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
132 query.setParameter("river_id", riverId); |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
133 return query.list(); |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
134 } |
87dab419b924
Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents:
5098
diff
changeset
|
135 |
5062
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
136 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
137 * Get sectie. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
138 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
139 * @return sectie as SectieKind. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
140 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
141 @OneToOne |
5089
4e03f3976d4b
Fix column decorator for sectie
Andre Heinecke <aheinecke@intevation.de>
parents:
5062
diff
changeset
|
142 @JoinColumn(name = "sectie") |
5062
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
143 public SectieKind getSectie() |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
144 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
145 return sectie; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
146 } |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
147 |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
148 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
149 * Set sectie. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
150 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
151 * @param sectie the value to set. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
152 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
153 public void setSectie(SectieKind sectie) |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
154 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
155 this.sectie = sectie; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
156 } |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
157 |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
158 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
159 * Get sobek. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
160 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
161 * @return sobek as SobekKind. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
162 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
163 @OneToOne |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
164 @JoinColumn(name = "sobek") |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
165 public SobekKind getSobek() |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
166 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
167 return sobek; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
168 } |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
169 |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
170 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
171 * Set sobek. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
172 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
173 * @param sobek the value to set. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
174 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
175 public void setSobek(SobekKind sobek) |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
176 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
177 this.sobek = sobek; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
178 } |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
179 |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
180 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
181 * Get kind. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
182 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
183 * @return kind as BoundaryKind. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
184 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
185 @OneToOne |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
186 @JoinColumn(name = "kind") |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
187 public BoundaryKind getKind() |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
188 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
189 return kind; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
190 } |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
191 |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
192 /** |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
193 * Set kind. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
194 * |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
195 * @param kind the value to set. |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
196 */ |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
197 public void setKind(BoundaryKind kind) |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
198 { |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
199 this.kind = kind; |
bafc655ee630
Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents:
2868
diff
changeset
|
200 } |
2868
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
201 } |
b6f94c5db89e
Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
202 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |