Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/WstValueTableFactory.java @ 2610:3c907758f0ab
Added cacheable model for fixing column.
flys-artifacts/trunk@4192 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 03 Apr 2012 16:51:03 +0000 |
parents | ed550e325248 |
children | 5642a83420f2 |
comparison
equal
deleted
inserted
replaced
2609:ed550e325248 | 2610:3c907758f0ab |
---|---|
234 * of which the values shall be fetched. | 234 * of which the values shall be fetched. |
235 * @return resultant rows. | 235 * @return resultant rows. |
236 */ | 236 */ |
237 protected static List<WstValueTable.Row> loadRowsOneColumn( | 237 protected static List<WstValueTable.Row> loadRowsOneColumn( |
238 Session session, | 238 Session session, |
239 int wst_id, | 239 int wstId, |
240 int column_pos | 240 int column_pos |
241 ) { | 241 ) { |
242 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_WS_AT_COL) | 242 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_WS_AT_COL) |
243 .addScalar("km", StandardBasicTypes.DOUBLE) | 243 .addScalar("km", StandardBasicTypes.DOUBLE) |
244 .addScalar("w", StandardBasicTypes.DOUBLE); | 244 .addScalar("w", StandardBasicTypes.DOUBLE); |
245 | 245 |
246 sqlQuery.setInteger("wst_id", wst_id); | 246 sqlQuery.setInteger("wst_id", wstId); |
247 sqlQuery.setInteger("column_pos", column_pos); | 247 sqlQuery.setInteger("column_pos", column_pos); |
248 | 248 |
249 List<Object []> results = sqlQuery.list(); | 249 List<Object []> results = sqlQuery.list(); |
250 | 250 |
251 double [] ws = null; | 251 double [] ws = null; |
252 | 252 |
253 ArrayList<WstValueTable.Row> rows = new ArrayList<WstValueTable.Row>(); | 253 List<WstValueTable.Row> rows = |
254 new ArrayList<WstValueTable.Row>(results.size()); | |
254 | 255 |
255 // Walk over rows. | 256 // Walk over rows. |
256 for (Object [] result: results) { | 257 for (Object [] result: results) { |
257 ws = new double[1]; | 258 ws = new double[1]; |
258 WstValueTable.Row row = | 259 WstValueTable.Row row = |
261 | 262 |
262 Double w = (Double) result[1]; | 263 Double w = (Double) result[1]; |
263 ws[0] = w != null ? w : Double.NaN; | 264 ws[0] = w != null ? w : Double.NaN; |
264 } | 265 } |
265 | 266 |
266 rows.trimToSize(); | |
267 return rows; | 267 return rows; |
268 } | 268 } |
269 | 269 |
270 protected static List<WstValueTable.Row> loadRows( | 270 protected static List<WstValueTable.Row> loadRows( |
271 Session session, | 271 Session session, |