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
