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, |