Mercurial > dive4elements > river
view flys-artifacts/src/main/java/de/intevation/flys/artifacts/datacage/templating/ResultData.java @ 5509:627584bc0586
Datacage: Added <dc:filter> element. This allows cleaner way to narrow the datasets.
Example:
<dc:context>
<dc:statement>
SELECT DISTINCT
name AS hws_name,
official AS hws_official,
kind_id AS hws_kind
FROM hws_lines
WHERE river_id = ${river_id}
</dc:statement>
<dc:if test="dc:has-result()">
<lines>
<dc:macro name="hws-lines">
<dc:elements>
<hws factory="hwsfactory" name="{$hws_name}"/>
</dc:elements>
</dc:macro>
<dc:filter expr="$hws_official=1">
<dc:if test="dc:has-result()">
<official>
<dc:filter expr="$hws_kind=1">
<dc:if test="dc:has-result()">
<Durchlass><dc:call-macro name="hws-lines"></Durchlass>
</dc:if>
</dc:filter>
<dc:filter expr="$hws_kind=2">
<dc:if test="dc:has-result()">
<Damm><dc:call-macro name="hws-lines"></Damm>
</dc:if>
</dc:filter>
<dc:filter expr="$hws_kind=3">
<dc:if test="dc:has-result()">
<Graben><dc:call-macro name="hws-lines"></Graben>
</dc:if>
</dc:filter>
</official>
</dc:if>
</dc:filter>
</lines>
</dc:if>
</dc:context>
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 28 Mar 2013 16:51:15 +0100 |
parents | ac2746f3e75f |
children |
line wrap: on
line source
package de.intevation.flys.artifacts.datacage.templating; import java.io.Serializable; import java.sql.ResultSetMetaData; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import java.util.ArrayList; import org.apache.log4j.Logger; /** Result Data from a DB/SQL query. */ public class ResultData implements Serializable { private static Logger log = Logger.getLogger(ResultData.class); protected String [] columns; protected List<Object []> rows; public ResultData() { rows = new ArrayList<Object []>(); } public ResultData(String [] columns, List<Object []> rows) { this.columns = columns; this.rows = rows; } public ResultData(ResultSetMetaData meta) throws SQLException { this(); boolean debug = log.isDebugEnabled(); int N = meta.getColumnCount(); columns = new String[N]; if (debug) { log.debug("ResultSet column names:"); } for (int i = 1; i <= N; ++i) { columns[i-1] = meta.getColumnLabel(i).toUpperCase(); if (debug) { log.debug(" " + i + ": " + columns[i-1]); } } } public String [] getColumnLabels() { return columns; } public ResultData addAll(ResultSet result) throws SQLException { while (result.next()) { add(result); } return this; } public void add(ResultSet result) throws SQLException { Object [] row = new Object[columns.length]; for (int i = 0; i < columns.length; ++i) { row[i] = result.getObject(i+1); } rows.add(row); } public List<Object []> getRows() { return rows; } public boolean isEmpty() { return rows.isEmpty(); } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :