Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3289:ec9aab93f292
SQ: First peek into fetching relevant data from SedDB
flys-artifacts/trunk@4957 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 12 Jul 2012 16:15:30 +0000 |
| parents | 30f157c7e466 |
| children | 36f3b53d5cfc |
comparison
equal
deleted
inserted
replaced
| 3288:cf1b769190b7 | 3289:ec9aab93f292 |
|---|---|
| 94 " ON m.stationid = s.stationid " + | 94 " ON m.stationid = s.stationid " + |
| 95 " JOIN gewaesser g " + | 95 " JOIN gewaesser g " + |
| 96 " ON s.gewaesserid = g.gewaesserid " + | 96 " ON s.gewaesserid = g.gewaesserid " + |
| 97 "WHERE" + | 97 "WHERE" + |
| 98 " m.gsiebsatzid IS NOT NULL AND" + | 98 " m.gsiebsatzid IS NOT NULL AND" + |
| 99 " m.q IS NOT NULL AND" + | |
| 99 " g.name = :name " + | 100 " g.name = :name " + |
| 100 "ORDER by" + | 101 "ORDER by" + |
| 101 " s.km, m.datum"; | 102 " s.km, m.datum"; |
| 102 | 103 |
| 103 protected String riverName; | 104 protected String riverName; |
| 117 return Math.abs(a - b) < EPSILON; | 118 return Math.abs(a - b) < EPSILON; |
| 118 } | 119 } |
| 119 | 120 |
| 120 protected void loadData(Session session) { | 121 protected void loadData(Session session) { |
| 121 SQLQuery query = session.createSQLQuery(SQL_SQ) | 122 SQLQuery query = session.createSQLQuery(SQL_SQ) |
| 122 .addScalar("km", StandardBasicTypes.DOUBLE) | 123 .addScalar("km", StandardBasicTypes.DOUBLE) |
| 123 .addScalar("datum", StandardBasicTypes.DATE); | 124 .addScalar("datum", StandardBasicTypes.DATE); |
| 124 | 125 |
| 125 query.setString("name", riverName); | 126 query.setString("name", riverName); |
| 126 | 127 |
| 127 List<Object []> list = query.list(); | 128 List<Object []> list = query.list(); |
| 128 | 129 |