Mercurial > dive4elements > river
annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/map/HWSFactory.java @ 5502:566eea137330
Added i18n strings for static sq data.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Thu, 28 Mar 2013 15:17:52 +0100 |
parents | 029b5f5f1dcc |
children |
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 |
5329
029b5f5f1dcc
Little code clean up and possible a NPE fix.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5307
diff
changeset
|
125 for (Object [] row: resultsLines) { |
5307
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
126 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
127 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
128 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
129 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
130 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
131 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
132 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
133 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
134 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
135 HWS.TYPE.LINE)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
136 } |
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 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
139 } |
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 private static HWSContainer getHWSPointsUncached(String river) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
142 if (log.isDebugEnabled()) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
143 log.debug("HWSFactory.getHWSLinesUncached"); |
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 Session session = SessionHolder.HOLDER.get(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
147 SQLQuery sqlQuery = null; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
148 HWSContainer container = new HWSContainer(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
149 container.setRiver(river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
150 container.setType(HWS.TYPE.LINE); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
151 sqlQuery = session.createSQLQuery(SQL_SELECT_POINTS) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
152 .addScalar("name", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
153 .addScalar("geom", GeometryUserType.TYPE) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
154 .addScalar("id", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
155 .addScalar("kind_id", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
156 .addScalar("official", StandardBasicTypes.INTEGER) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
157 .addScalar("fed", StandardBasicTypes.STRING) |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
158 .addScalar("description", StandardBasicTypes.STRING); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
159 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
160 sqlQuery.setString("river", river); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
161 List<Object []> resultsPoints = sqlQuery.list(); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
162 |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
163 for (int i = 0; i < resultsPoints.size(); i++) { |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
164 Object[] row = resultsPoints.get(i); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
165 container.addHws( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
166 new HWS( |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
167 (String) row[0], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
168 (Geometry) row[1], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
169 (String) row[2], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
170 (Integer) row[3], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
171 (Integer) row[4], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
172 (String) row[5], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
173 (String) row[6], |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
174 HWS.TYPE.POINT)); |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
175 } |
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 return container; |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
178 } |
6131b352e5e4
Data structure and factory for hws.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff
changeset
|
179 } |