Mercurial > dive4elements > river
annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/map/HWSFactory.java @ 8148:eb48b244921d
The rest is silence.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 27 Aug 2014 19:52:51 +0200 |
parents | fe32a7f9655e |
children | e4606eae8ea5 |
rev | line source |
---|---|
5863
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde |
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
2 * Software engineering by Intevation GmbH |
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
3 * |
5994
af13ceeba52a
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5863
diff
changeset
|
4 * This file is Free Software under the GNU AGPL (>=v3) |
5863
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the |
5994
af13ceeba52a
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5863
diff
changeset
|
6 * documentation coming with Dive4Elements River for details. |
5863
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
7 */ |
4897a58c8746
River artifacts: Added new copyright headers.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
8 |
5831
bd047b71ab37
Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5329
diff
changeset
|
9 package org.dive4elements.river.artifacts.model.map; |
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
10 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
11 import java.util.List; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
12 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
13 import net.sf.ehcache.Cache; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
14 import net.sf.ehcache.Element; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
15 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
16 import org.apache.log4j.Logger; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
17 import org.hibernate.SQLQuery; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
18 import org.hibernate.Session; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
19 import org.hibernate.type.StandardBasicTypes; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
20 import org.hibernatespatial.GeometryUserType; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
21 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
22 import com.vividsolutions.jts.geom.Geometry; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
23 |
5831
bd047b71ab37
Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5329
diff
changeset
|
24 import org.dive4elements.river.artifacts.cache.CacheFactory; |
bd047b71ab37
Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5329
diff
changeset
|
25 import org.dive4elements.river.backend.SessionHolder; |
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
26 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
27 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
28 public class HWSFactory |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
29 { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
30 /** Private logger to use here. */ |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
31 private static Logger log = Logger.getLogger(HWSFactory.class); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
32 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
33 private static final int HWS_LINES = 0; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
34 private static final int HWS_POINTS = 1; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
35 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
36 public static final String SQL_SELECT_LINES = |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
37 "SELECT hl.name, hl.geom, hl.id, hl.kind_id, hl.official, fs.name AS fed, hl.description " + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
38 " FROM hws_lines hl" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
39 " JOIN rivers r ON hl.river_id = r.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
40 " LEFT JOIN fed_states fs ON hl.fed_state_id = fs.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
41 " WHERE r.name = :river"; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
42 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
43 public static final String SQL_SELECT_POINTS = |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
44 "SELECT hp.name, hp.geom, hp.id, hp.kind_id, hp.official, fs.name AS fed, hp.description " + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
45 " FROM hws_points hp" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
46 " JOIN rivers r ON hp.river_id = r.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
47 " LEFT JOIN fed_states fs ON hp.fed_state_id = fs.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
48 " WHERE r.name = :river"; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
49 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
50 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
51 private HWSFactory() { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
52 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
53 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
54 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
55 public static HWSContainer getHWSLines(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
56 log.debug("HWSFactory.getHWS"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
57 Cache cache = CacheFactory.getCache(StaticHWSCacheKey.CACHE_NAME); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
58 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
59 StaticHWSCacheKey cacheKey; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
60 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
61 if (cache != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
62 cacheKey = new StaticHWSCacheKey(river, HWS_LINES); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
63 Element element = cache.get(cacheKey); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
64 if (element != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
65 log.debug("Got static hws values from cache"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
66 return (HWSContainer)element.getValue(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
67 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
68 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
69 else { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
70 cacheKey = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
71 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
72 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
73 HWSContainer values = getHWSLinesUncached(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
74 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
75 if (values != null && cacheKey != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
76 log.debug("Store static hws values in cache."); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
77 Element element = new Element(cacheKey, values); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
78 cache.put(element); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
79 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
80 return values; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
81 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
82 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
83 public static HWSContainer getHWSPoints(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
84 log.debug("HWSFactory.getHWS"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
85 Cache cache = CacheFactory.getCache(StaticHWSCacheKey.CACHE_NAME); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
86 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
87 StaticHWSCacheKey cacheKey; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
88 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
89 if (cache != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
90 cacheKey = new StaticHWSCacheKey(river, HWS_LINES); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
91 Element element = cache.get(cacheKey); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
92 if (element != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
93 log.debug("Got static hws values from cache"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
94 return (HWSContainer)element.getValue(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
95 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
96 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
97 else { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
98 cacheKey = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
99 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
100 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
101 HWSContainer values = getHWSPointsUncached(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
102 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
103 if (values != null && cacheKey != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
104 log.debug("Store static hws values in cache."); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
105 Element element = new Element(cacheKey, values); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
106 cache.put(element); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
107 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
108 return values; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
109 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
110 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
111 private static HWSContainer getHWSLinesUncached(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
112 if (log.isDebugEnabled()) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
113 log.debug("HWSFactory.getHWSLinesUncached"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
114 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
115 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
116 Session session = SessionHolder.HOLDER.get(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
117 SQLQuery sqlQuery = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
118 HWSContainer container = new HWSContainer(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
119 container.setRiver(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
120 container.setType(HWS.TYPE.LINE); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
121 sqlQuery = session.createSQLQuery(SQL_SELECT_LINES) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
122 .addScalar("name", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
123 .addScalar("geom", GeometryUserType.TYPE) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
124 .addScalar("id", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
125 .addScalar("kind_id", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
126 .addScalar("official", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
127 .addScalar("fed", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
128 .addScalar("description", StandardBasicTypes.STRING); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
129 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
130 sqlQuery.setString("river", river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
131 List<Object []> resultsLines = sqlQuery.list(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
132 |
5329
029b5f5f1dcc
Little code clean up and possible a NPE fix.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5307
diff
changeset
|
133 for (Object [] row: resultsLines) { |
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
134 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
135 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
136 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
137 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
138 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
139 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
140 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
141 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
142 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
143 HWS.TYPE.LINE)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
144 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
145 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
146 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
147 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
148 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
149 private static HWSContainer getHWSPointsUncached(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
150 if (log.isDebugEnabled()) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
151 log.debug("HWSFactory.getHWSLinesUncached"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
152 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
153 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
154 Session session = SessionHolder.HOLDER.get(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
155 SQLQuery sqlQuery = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
156 HWSContainer container = new HWSContainer(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
157 container.setRiver(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
158 container.setType(HWS.TYPE.LINE); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
159 sqlQuery = session.createSQLQuery(SQL_SELECT_POINTS) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
160 .addScalar("name", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
161 .addScalar("geom", GeometryUserType.TYPE) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
162 .addScalar("id", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
163 .addScalar("kind_id", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
164 .addScalar("official", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
165 .addScalar("fed", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
166 .addScalar("description", StandardBasicTypes.STRING); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
167 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
168 sqlQuery.setString("river", river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
169 List<Object []> resultsPoints = sqlQuery.list(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
170 |
7254
fe32a7f9655e
Reduce usage of careless 'for (int i = 0; i < x.size(); i++)' pattern.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5994
diff
changeset
|
171 for (Object [] row: resultsPoints) { |
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
172 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
173 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
174 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
175 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
176 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
177 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
178 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
179 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
180 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
181 HWS.TYPE.POINT)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
182 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
183 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
184 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
185 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
186 } |