Mercurial > dive4elements > river
view artifacts/src/main/java/org/dive4elements/river/artifacts/datacage/templating/ResultData.java @ 5890:6ea004d51203
Datacage: Introduced <dc:group epxr="xpath" type="type"> ... </dc:group> and XPath function dc:group-key().
This splits the current result set into groups formed by expr. The type defaults to string.
Afterwards all these groups are iterated by there natural order.
The dc:group-key() gives access to the result of the grouping expression that forms a group.
Say, you have a result set like this:
name | description
-----+------------
a | foo
a | bar
b | baz
b | bla
c | blub
you can use:
<dc:group expr="$name">
<group name="{dc:group-key()}">
<dc:for-each>
<description value="{$description}"/>
</dc:for-each>
</group>
</dc:group>
to create:
<group name="a">
<description name="foo"/>
<description name="bar"/>
</group>
<group name="b">
<description name="baz"/>
<description name="bla"/>
</group>
<group name="c">
<description name="blub"/>
</group>
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 02 May 2013 20:52:18 +0200 |
parents | 4897a58c8746 |
children | af13ceeba52a |
line wrap: on
line source
/* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde * Software engineering by Intevation GmbH * * This file is Free Software under the GNU AGPL (>=v3) * and comes with ABSOLUTELY NO WARRANTY! Check out the * documentation coming with Dive4Elements River for details. */ package org.dive4elements.river.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) { this(columns, 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(Object [] result) { rows.add(result); } 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 :