Parent Directory
| 
Revision Log
| 
Patch
--- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/xsp/esql.xsp 2005/05/03 18:18:50 167950
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/xsp/esql.xsp 2005/05/03 18:22:14 167951
@@ -15,151 +15,136 @@
limitations under the License.
-->
-<!-- CVS: $Id: esql.xsp,v 1.5 2004/04/05 12:25:35 antonio Exp $ -->
+<!-- CVS: $Id$ -->
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2">
<page>
- <title>A Database Driven XSP Page</title>
+ <title>A Database Driven XSP Page</title>
<resources>
- <resource type="file" href="../transform/sql-page.xml.sql">Schema</resource>
- <resource type="doc" href="userdocs/xsp/esql">ESQL</resource>
+ <resource type="file" href="../schema.sql">Schema</resource>
+ <resource type="doc" href="userdocs/xsp/esql">ESQL</resource>
</resources>
- <content>
-
- <esql:connection>
- <esql:pool>personnel</esql:pool>
-
-
- <para>
- Below you see all guys from the departments
- </para>
-
- <esql:execute-query>
- <esql:query>select * from employee</esql:query>
- <esql:results>
- <esql:row-results>
- <para><esql:get-string column="name"/></para>
- <!-- uncomment if you want columns to become tags -->
- <!-- <esql:get-columns/> -->
- </esql:row-results>
- </esql:results>
- </esql:execute-query>
-
- <hr/>
-
- <para>
- Below you see just some of the guys
- </para>
-
- <esql:execute-query>
- <esql:query>select * from employee</esql:query>
- <esql:use-limit-clause>jdbc</esql:use-limit-clause>
- <esql:skip-rows>1</esql:skip-rows>
- <esql:max-rows>2</esql:max-rows>
- <esql:results>
- <esql:row-results>
- <para><esql:get-string column="name"/></para>
- </esql:row-results>
- <esql:previous-results>
- We skipped some.
- </esql:previous-results>
- <esql:more-results>
- There are some more.
- </esql:more-results>
- <para>
- There is a total of <esql:row-count/> employees.
- </para>
- </esql:results>
- </esql:execute-query>
-
- <hr/>
-
- <para>
- Below departments and employees are printed.
- Without the grouping feature, the result would look like this:
- </para>
-
- <esql:execute-query>
- <esql:query>
- SELECT department.name, employee.id, employee.name as empName FROM department, employee
- WHERE department.id = employee.department_id ORDER BY department.name
- </esql:query>
- <esql:results>
- <esql:row-results>
- <Department>
- <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
- <h2><esql:get-string column='name'/></h2>
- <para><employee><esql:get-string column='empName'/></employee></para>
- </Department>
- </esql:row-results>
- </esql:results>
- </esql:execute-query>
-
- <hr/>
-
- <para>
- This uses the grouping feature in esql.
- </para>
-
- <esql:execute-query>
- <esql:query>
- SELECT department.name, employee.id, employee.name as empName FROM department, employee
- WHERE department.id = employee.department_id ORDER BY department.name
- </esql:query>
- <esql:results>
- <esql:row-results>
- <esql:group group-on='name'><!-- grouping -->
- <Department>
- <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
- <h2><esql:get-string column='name'/></h2>
- <esql:member><!-- grouping -->
- <para><employee><esql:get-string column='empName'/></employee></para>
- </esql:member><!--grouping -->
- </Department>
- </esql:group><!-- grouping -->
- </esql:row-results>
- </esql:results>
- </esql:execute-query>
-
- <hr/>
-
- <para>
- This uses nested queries.
- </para>
-
- <esql:execute-query>
- <esql:query>
- SELECT name, id FROM department ORDER BY name
- </esql:query>
- <esql:results>
- <esql:row-results>
- <Department>
- <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
- <h2><esql:get-string column='name'/></h2>
-
- <esql:execute-query>
- <esql:query>
- select name from employee
- where department_id = <esql:parameter type="int"><esql:get-int column="id" ancestor="1"/></esql:parameter>
- </esql:query>
- <esql:results>
- <esql:row-results>
- <para><employee><esql:get-string column='name'/></employee></para>
- </esql:row-results>
- </esql:results>
- </esql:execute-query>
-
- </Department>
- </esql:row-results>
- </esql:results>
- </esql:execute-query>
+ <content>
+ <esql:connection>
+ <esql:pool>personnel</esql:pool>
+
+ <h3>Below you see all of the guys</h3>
+ <ul>
+ <esql:execute-query>
+ <esql:query>select * from employee</esql:query>
+ <esql:results>
+ <esql:row-results>
+ <li><esql:get-string column="name"/></li>
+ <!-- uncomment if you want columns to become tags -->
+ <!-- <esql:get-columns/> -->
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+ </ul>
+
+ <h3>Below you see just some of the guys</h3>
+ <esql:execute-query>
+ <esql:query>select * from employee</esql:query>
+ <esql:use-limit-clause>jdbc</esql:use-limit-clause>
+ <esql:skip-rows>1</esql:skip-rows>
+ <esql:max-rows>2</esql:max-rows>
+ <esql:results>
+ <ul>
+ <esql:row-results>
+ <li><esql:get-string column="name"/></li>
+ </esql:row-results>
+ <esql:previous-results>
+ <li>We skipped some.</li>
+ </esql:previous-results>
+ <esql:more-results>
+ <li>There are some more.</li>
+ </esql:more-results>
+ </ul>
+ <para>
+ There is a total of <esql:row-count/> employees.
+ </para>
+ </esql:results>
+ </esql:execute-query>
+
+ <h3>
+ Below departments and employees are printed.
+ Without the grouping feature, the result would look like this:
+ </h3>
+
+ <esql:execute-query>
+ <esql:query>
+ SELECT department.name, employee.id, employee.name as empName FROM department, employee
+ WHERE department.id = employee.department_id ORDER BY department.name
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <Department>
+ <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
+ <h4><esql:get-string column='name'/></h4>
+ <para><employee><esql:get-string column='empName'/></employee></para>
+ </Department>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ <h3>
+ This uses the grouping feature in esql.
+ </h3>
+
+ <esql:execute-query>
+ <esql:query>
+ SELECT department.name, employee.id, employee.name as empName FROM department, employee
+ WHERE department.id = employee.department_id ORDER BY department.name
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <esql:group group-on='name'><!-- grouping -->
+ <Department>
+ <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
+ <h4><esql:get-string column='name'/></h4>
+ <esql:member><!-- grouping -->
+ <para><employee><esql:get-string column='empName'/></employee></para>
+ </esql:member><!--grouping -->
+ </Department>
+ </esql:group><!-- grouping -->
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ <h3>This uses nested queries.</h3>
+ <esql:execute-query>
+ <esql:query>
+ SELECT name, id FROM department ORDER BY name
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <Department>
+ <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
+ <h4><esql:get-string column='name'/></h4>
+
+ <esql:execute-query>
+ <esql:query>
+ select name from employee
+ where department_id = <esql:parameter type="int"><esql:get-int column="id" ancestor="1"/></esql:parameter>
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <para><employee><esql:get-string column='name'/></employee></para>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ </Department>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
</esql:connection>
- </content>
+ </content>
</page>
</xsp:page>
| infrastructure at apache.org | ViewVC Help |
| Powered by ViewVC 1.1.26 |