Parent Directory | Revision Log | Patch
--- cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-employee.xsp 2005/05/03 18:18:50 167950 +++ cocoon/branches/BRANCH_2_1_X/src/blocks/databases/samples/org-db/process-employee.xsp 2005/05/03 18:22:14 167951 @@ -15,18 +15,18 @@ limitations under the License. --> -<xsp:page - language="java" +<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" - xmlns:xsp-request="http://apache.org/xsp/request/2.0" -> + xmlns:xsp-request="http://apache.org/xsp/request/2.0"> + <xsp:logic> String process = null; String name = null; String departmentId = null; int currId = -1; </xsp:logic> + <page> <xsp:logic> process = <xsp-request:get-parameter name="process"/>; @@ -35,34 +35,34 @@ </xsp:logic> <resources> - <resource type="file" href="employee.xml?cocoon-view=pretty-content">Descriptor</resource> - <resource type="file" href="../transform/sql-page.xml.sql">Schema</resource> - <resource type="doc" href="userdocs/actions/database-actions.html">Actions</resource> - <resource type="doc" href="userdocs/xsp/esql.html">ESQL</resource> + <resource type="file" href="employee.xml?cocoon-view=pretty-content">Descriptor</resource> + <resource type="file" href="../schema.sql">Schema</resource> + <resource type="doc" href="userdocs/actions/database-actions.html">Actions</resource> + <resource type="doc" href="userdocs/xsp/esql.html">ESQL</resource> </resources> <title><xsp:expr>process</xsp:expr> Employee Processed</title> <content> <esql:connection> <esql:pool>personnel</esql:pool> - <esql:autocommit>false</esql:autocommit> + <esql:autocommit>false</esql:autocommit> <esql:execute-query> <esql:query>select max(id) as maxid from employee</esql:query> <esql:results> - <esql:row-results> - <xsp:logic> + <esql:row-results> + <xsp:logic> currId = <esql:get-int column="maxid"/>; - </xsp:logic> + </xsp:logic> <esql:execute-query> <esql:query> insert into employee (id, name, department_id) values ( (<esql:parameter><xsp:expr>currId + 1</xsp:expr></esql:parameter>), - <esql:parameter><xsp:expr>name</xsp:expr></esql:parameter>, - <esql:parameter><xsp:expr>departmentId</xsp:expr></esql:parameter> + <esql:parameter><xsp:expr>name</xsp:expr></esql:parameter>, + <esql:parameter><xsp:expr>departmentId</xsp:expr></esql:parameter> ) </esql:query> </esql:execute-query> - </esql:row-results> + </esql:row-results> </esql:results> </esql:execute-query> </esql:connection>
infrastructure at apache.org | ViewVC Help |
Powered by ViewVC 1.1.26 |