Author: cziegeler Date: Fri May 6 03:19:21 2005 New Revision: 168589 URL: http://svn.apache.org/viewcvs?rev=168589&view=rev Log: Add some more samples
Added: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp (with props) cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml (with props) Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/add-department.xsp cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-department.xsp cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/samples.xml Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/add-department.xsp URL: http://svn.apache.org/viewcvs/cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/add-department.xsp?rev=168589&r1=168588&r2=168589&view=diff ============================================================================== --- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/add-department.xsp (original) +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/add-department.xsp Fri May 6 03:19:21 2005 @@ -31,6 +31,7 @@ <form action="process-department" method="POST"> <input name="process" type="hidden" value="Add"/> <para>Department Name: <input name="name" type="text"/></para> + <para>Description: <textarea name="desc" cols="50" rows="10"></textarea></para> <input type="submit" value="Add"/> </form> </content> Added: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp URL: http://svn.apache.org/viewcvs/cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp?rev=168589&view=auto ============================================================================== --- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp (added) +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp Fri May 6 03:19:21 2005 @@ -0,0 +1,37 @@ +<?xml version="1.0"?> +<!-- + Copyright 2005 The Apache Software Foundation + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +--> + +<xsp:page language="java" + xmlns:xsp="http://apache.org/xsp" + xmlns:esql="http://apache.org/cocoon/SQL/v2"> + <page> + <title>Show Departments</title> + <content> + <esql:connection> + <esql:pool>personnel</esql:pool> + <esql:execute-query> + <esql:query>select id, name, description from department order by name</esql:query> + <esql:results> + <esql:row-results> + <li><esql:get-string column="id"/>. <esql:get-string column="name"/> : <esql:get-string column="description"/></li> + </esql:row-results> + </esql:results> + </esql:execute-query> + </esql:connection> + </content> + </page> +</xsp:page> Propchange: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp ------------------------------------------------------------------------------ svn:eol-style = native Propchange: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/departments.xsp ------------------------------------------------------------------------------ svn:keywords = Id Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-department.xsp URL: http://svn.apache.org/viewcvs/cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-department.xsp?rev=168589&r1=168588&r2=168589&view=diff ============================================================================== --- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-department.xsp (original) +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-department.xsp Fri May 6 03:19:21 2005 @@ -23,6 +23,7 @@ <xsp:logic> String process = null; String name = null; + String desc = null; int currId = -1; </xsp:logic> @@ -30,6 +31,7 @@ <xsp:logic> process = <xsp-request:get-parameter name="process"/>; name = <xsp-request:get-parameter name="name"/>; + desc = <xsp-request:get-parameter name="desc"/>; </xsp:logic> <resources> @@ -54,9 +56,10 @@ </xsp:logic> <esql:execute-query> <esql:query> - insert into department (id, name) values ( + insert into department (id, name, description) values ( (<esql:parameter><xsp:expr>currId</xsp:expr></esql:parameter> + 1), - <esql:parameter><xsp:expr>name</xsp:expr></esql:parameter> + <esql:parameter><xsp:expr>name</xsp:expr></esql:parameter>, + <esql:parameter><xsp:expr>desc</xsp:expr></esql:parameter> ) </esql:query> </esql:execute-query> Modified: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/samples.xml URL: http://svn.apache.org/viewcvs/cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/samples.xml?rev=168589&r1=168588&r2=168589&view=diff ============================================================================== --- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/samples.xml (original) +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/samples.xml Fri May 6 03:19:21 2005 @@ -40,6 +40,9 @@ <sample name="Nested Queries" href="transform/sql-page2" xlink:role="dynamic"> Example with two queries nested into the third one. </sample> + <sample name="XML Test" href="transform/sql-page3" xlink:role="dynamic"> + Example with inserting XML into a database. + </sample> </group> <group name="XSP"> @@ -86,6 +89,9 @@ </sample> <sample name="Insert Employees" href="org-db/add-employee" xlink:role="dynamic"> Adds new Employees to the employees table. + </sample> + <sample name="Show Departments" href="org-db/departments" xlink:role="dynamic"> + Show all departments. </sample> </group> Added: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml URL: http://svn.apache.org/viewcvs/cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml?rev=168589&view=auto ============================================================================== --- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml (added) +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml Fri May 6 03:19:21 2005 @@ -0,0 +1,42 @@ +<?xml version="1.0"?> +<!-- + Copyright 1999-2004 The Apache Software Foundation + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +--> + +<page> + <title>Hello</title> + + <resources> + <resource type="file" href="../schema.sql">Schema</resource> + <resource type="doc" href="userdocs/transformers/sql-transformer.html">SQL Transformer</resource> + </resources> + + <content> + <para>This is my first Cocoon2 page filled with SQL data!</para> + + <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0"> + <sql:query> + select max(id) as maxid from department + </sql:query> + <sql:execute-query> + <sql:query> + insert into department (id, name, description) + values(<sql:ancestor-value name="maxid" level="1"/> + 1, 'XML Test', + '<span>An XML Test</span>') + </sql:query> + </sql:execute-query> + </sql:execute-query> + </content> +</page> Propchange: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml ------------------------------------------------------------------------------ svn:eol-style = native Propchange: cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/transform/sql-page3.xml ------------------------------------------------------------------------------ svn:keywords = Id