Mercurial > dive4elements > river
view flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/FlowVelocityMeasurementFactory.java @ 4655:cd44d28d0fbc
Move the access to artifact data to the Access object
Use BedHeightAccess class to receive the data from the artifact. This abstracts
the data access from the actual artifact.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Tue, 11 Dec 2012 09:44:04 +0100 |
parents | 4e4226d99b49 |
children |
line wrap: on
line source
package de.intevation.flys.artifacts.model.minfo; import java.util.List; import org.apache.log4j.Logger; import org.hibernate.SQLQuery; import org.hibernate.Session; import de.intevation.flys.model.FlowVelocityMeasurementValue; import de.intevation.flys.backend.SessionHolder; public class FlowVelocityMeasurementFactory { /** Private logger to use here. */ private static Logger log = Logger.getLogger(FlowVelocityMeasurementFactory.class); /** Query to get description and start year, given name and a km range. */ public static final String SQL_SELECT_ONE = "SELECT station, datetime, w, q, v, description " + " FROM flow_velocity_measure_values" + " WHERE id = :id"; private FlowVelocityMeasurementFactory() { } public static FlowVelocityMeasurementValue.FastFlowVelocityMeasurementValue getFlowVelocityMeasurement(int id) { log.debug("FlowVelocityMeasurementFactory.getFlowVelocityMeasurementValue"); Session session = SessionHolder.HOLDER.get(); SQLQuery sqlQuery = null; sqlQuery = session.createSQLQuery(SQL_SELECT_ONE); sqlQuery.setParameter("id", id); List<Object []> results = sqlQuery.list(); if (results.size() > 0) { Object[] row = results.get(0); if (row == null || row.length < 6) { return null; } return FlowVelocityMeasurementValue.getUnmapped( Double.parseDouble(row[0].toString()), Double.parseDouble(row[2].toString()), Double.valueOf(row[3].toString()), Double.valueOf(row[4].toString()), null, row[5].toString()); } return null; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :