Mercurial > dive4elements > river
comparison flys-backend/src/main/java/de/intevation/flys/model/CrossSectionTrack.java @ 5465:c8e74e5e828c
Add crosssection track accessors that filter by kind and by kind and name
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 15:26:28 +0100 |
| parents | 88e3473a3846 |
| children |
comparison
equal
deleted
inserted
replaced
| 5464:f2bcf0fb1efd | 5465:c8e74e5e828c |
|---|---|
| 132 query.setParameter("name", name); | 132 query.setParameter("name", name); |
| 133 | 133 |
| 134 return query.list(); | 134 return query.list(); |
| 135 } | 135 } |
| 136 | 136 |
| 137 public static List<CrossSectionTrack> getCrossSectionTrack( | |
| 138 String river, | |
| 139 int kind_id | |
| 140 ) { | |
| 141 Session session = SessionHolder.HOLDER.get(); | |
| 142 | |
| 143 Query query = session.createQuery( | |
| 144 "from CrossSectionTrack as cst " + | |
| 145 " where river.name =:river" + | |
| 146 " and kind_id=:kind_id"); | |
| 147 query.setParameter("river", river); | |
| 148 query.setParameter("kind_id", kind_id); | |
| 149 | |
| 150 return query.list(); | |
| 151 } | |
| 152 | |
| 153 public static List<CrossSectionTrack> getCrossSectionTrack( | |
| 154 String river, | |
| 155 String name, | |
| 156 int kind_id | |
| 157 ) { | |
| 158 Session session = SessionHolder.HOLDER.get(); | |
| 159 | |
| 160 Query query = session.createQuery( | |
| 161 "from CrossSectionTrack as cst " + | |
| 162 " where river.name =:river" + | |
| 163 " and cst.name=:name" + | |
| 164 " and kind_id=:kind_id"); | |
| 165 query.setParameter("river", river); | |
| 166 query.setParameter("name", name); | |
| 167 query.setParameter("kind_id", kind_id); | |
| 168 | |
| 169 return query.list(); | |
| 170 } | |
| 171 | |
| 137 | 172 |
| 138 /** | 173 /** |
| 139 * Returns the nearest CrossSectionTrack of <i>river</i> to a given | 174 * Returns the nearest CrossSectionTrack of <i>river</i> to a given |
| 140 * <i>km</i>. | 175 * <i>km</i>. |
| 141 * | 176 * |