Mercurial > dive4elements > river
annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/map/HWSFactory.java @ 5307:6131b352e5e4
Data structure and factory for hws.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Thu, 14 Mar 2013 17:13:49 +0100 |
parents | |
children | 029b5f5f1dcc |
rev | line source |
---|---|
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
1 package de.intevation.flys.artifacts.model.map; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
2 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
3 import java.util.List; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
4 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
5 import net.sf.ehcache.Cache; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
6 import net.sf.ehcache.Element; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
7 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
8 import org.apache.log4j.Logger; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
9 import org.hibernate.SQLQuery; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
10 import org.hibernate.Session; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
11 import org.hibernate.type.StandardBasicTypes; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
12 import org.hibernatespatial.GeometryUserType; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
13 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
14 import com.vividsolutions.jts.geom.Geometry; |
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 de.intevation.flys.artifacts.cache.CacheFactory; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
17 import de.intevation.flys.backend.SessionHolder; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
18 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
19 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
20 public class HWSFactory |
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 /** Private logger to use here. */ |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
23 private static Logger log = Logger.getLogger(HWSFactory.class); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
24 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
25 private static final int HWS_LINES = 0; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
26 private static final int HWS_POINTS = 1; |
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 static final String SQL_SELECT_LINES = |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
29 "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
|
30 " FROM hws_lines hl" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
31 " JOIN rivers r ON hl.river_id = r.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
32 " 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
|
33 " WHERE r.name = :river"; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
34 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
35 public static final String SQL_SELECT_POINTS = |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
36 "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
|
37 " FROM hws_points hp" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
38 " JOIN rivers r ON hp.river_id = r.id" + |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
39 " 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
|
40 " WHERE r.name = :river"; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
41 |
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 private HWSFactory() { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
44 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
45 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
46 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
47 public static HWSContainer getHWSLines(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
48 log.debug("HWSFactory.getHWS"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
49 Cache cache = CacheFactory.getCache(StaticHWSCacheKey.CACHE_NAME); |
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 StaticHWSCacheKey cacheKey; |
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 if (cache != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
54 cacheKey = new StaticHWSCacheKey(river, HWS_LINES); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
55 Element element = cache.get(cacheKey); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
56 if (element != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
57 log.debug("Got static hws values from cache"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
58 return (HWSContainer)element.getValue(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
59 } |
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 else { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
62 cacheKey = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
63 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
64 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
65 HWSContainer values = getHWSLinesUncached(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
66 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
67 if (values != null && cacheKey != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
68 log.debug("Store static hws values in cache."); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
69 Element element = new Element(cacheKey, values); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
70 cache.put(element); |
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 return values; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
73 } |
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 public static HWSContainer getHWSPoints(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
76 log.debug("HWSFactory.getHWS"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
77 Cache cache = CacheFactory.getCache(StaticHWSCacheKey.CACHE_NAME); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
78 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
79 StaticHWSCacheKey cacheKey; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
80 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
81 if (cache != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
82 cacheKey = new StaticHWSCacheKey(river, HWS_LINES); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
83 Element element = cache.get(cacheKey); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
84 if (element != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
85 log.debug("Got static hws values from cache"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
86 return (HWSContainer)element.getValue(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
87 } |
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 else { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
90 cacheKey = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
91 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
92 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
93 HWSContainer values = getHWSPointsUncached(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
94 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
95 if (values != null && cacheKey != null) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
96 log.debug("Store static hws values in cache."); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
97 Element element = new Element(cacheKey, values); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
98 cache.put(element); |
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 return values; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
101 } |
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 private static HWSContainer getHWSLinesUncached(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
104 if (log.isDebugEnabled()) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
105 log.debug("HWSFactory.getHWSLinesUncached"); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
106 } |
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 Session session = SessionHolder.HOLDER.get(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
109 SQLQuery sqlQuery = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
110 HWSContainer container = new HWSContainer(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
111 container.setRiver(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
112 container.setType(HWS.TYPE.LINE); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
113 sqlQuery = session.createSQLQuery(SQL_SELECT_LINES) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
114 .addScalar("name", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
115 .addScalar("geom", GeometryUserType.TYPE) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
116 .addScalar("id", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
117 .addScalar("kind_id", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
118 .addScalar("official", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
119 .addScalar("fed", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
120 .addScalar("description", StandardBasicTypes.STRING); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
121 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
122 sqlQuery.setString("river", river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
123 List<Object []> resultsLines = sqlQuery.list(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
124 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
125 for (int i = 0; i < resultsLines.size(); i++) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
126 Object[] row = resultsLines.get(i); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
127 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
128 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
129 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
130 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
131 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
132 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
133 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
134 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
135 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
136 HWS.TYPE.LINE)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
137 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
138 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
139 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
140 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
141 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
142 private static HWSContainer getHWSPointsUncached(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
143 if (log.isDebugEnabled()) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
144 log.debug("HWSFactory.getHWSLinesUncached"); |
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 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
147 Session session = SessionHolder.HOLDER.get(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
148 SQLQuery sqlQuery = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
149 HWSContainer container = new HWSContainer(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
150 container.setRiver(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
151 container.setType(HWS.TYPE.LINE); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
152 sqlQuery = session.createSQLQuery(SQL_SELECT_POINTS) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
153 .addScalar("name", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
154 .addScalar("geom", GeometryUserType.TYPE) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
155 .addScalar("id", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
156 .addScalar("kind_id", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
157 .addScalar("official", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
158 .addScalar("fed", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
159 .addScalar("description", StandardBasicTypes.STRING); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
160 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
161 sqlQuery.setString("river", river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
162 List<Object []> resultsPoints = sqlQuery.list(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
163 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
164 for (int i = 0; i < resultsPoints.size(); i++) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
165 Object[] row = resultsPoints.get(i); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
166 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
167 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
168 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
169 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
170 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
171 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
172 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
173 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
174 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
175 HWS.TYPE.POINT)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
176 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
177 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
178 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
179 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
180 } |