dive4elements/river: backend/src/main/java/org/dive4elements/river/model/sinfo/TkhValue.java comparison

Added datacage select and chart display for TKH series loaded from database

comparison

equal deleted inserted replaced

-:baef34f54ee2
+:6e5ff436febe
 */
 package org.dive4elements.river.model.sinfo;
 import java.io.Serializable;
+import java.util.List;
 import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.JoinColumn;
 import javax.persistence.OneToOne;
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
+import org.dive4elements.river.backend.SessionHolder;
+import org.hibernate.Query;
+import org.hibernate.Session;
 /**
 * Hibernate binding for the DB table tkh_values
 *
 * @author Matthias Schäfer
 }
 public void setTkheight(final Double tkheight) {
 this.tkheight = tkheight;
 }
+/**
+* Selects the tkh values of a tkh series column in a km range from the database
+*/
+public static List<TkhValue> getTkhValues(final TkhColumn parent, final double kmLo, final double kmHi) {
+final Session session = SessionHolder.HOLDER.get();
+final Query query = session.createQuery("FROM TkhValue WHERE (tkhColumn=:parent)"
++ " AND (station >= :kmLo - 0.0001) AND (station <= :kmHi + 0.0001)");
+query.setParameter("parent", parent);
+query.setParameter("kmLo", new Double(kmLo));
+query.setParameter("kmHi", new Double(kmHi));
+return query.list();
+}
 }

Mercurial > dive4elements > river