home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2004 December / PCpro_2004_12.ISO / files / webserver / xampp / xampp-cocoon-addon-1.4.9-installer.exe / edit-dept.xsp < prev    next >
Encoding:
Extensible Markup Language  |  2004-07-12  |  2.5 KB  |  69 lines
  1. <?xml version="1.0"?>
  2. <!--
  3.   Copyright 1999-2004 The Apache Software Foundation
  4.  
  5.   Licensed under the Apache License, Version 2.0 (the "License");
  6.   you may not use this file except in compliance with the License.
  7.   You may obtain a copy of the License at
  8.  
  9.       http://www.apache.org/licenses/LICENSE-2.0
  10.  
  11.   Unless required by applicable law or agreed to in writing, software
  12.   distributed under the License is distributed on an "AS IS" BASIS,
  13.   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14.   See the License for the specific language governing permissions and
  15.   limitations under the License.
  16. -->
  17.  
  18. <xsp:page xmlns:xsp="http://apache.org/xsp"
  19.           xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"
  20.       xmlns:xsp-request="http://apache.org/xsp/request/2.0"
  21.       xmlns:esql="http://apache.org/cocoon/SQL/v2">
  22. <document>
  23.   <header>
  24.     <title>Department</title>
  25.   </header>
  26.   <body>
  27.     <s1 title="Create a Department">
  28.       <form handler="edit-dept.html">
  29.         <p>
  30.           You can create a department by typing in the
  31.           name and pressing the "submit" button.
  32.         </p>
  33.         <p>
  34.           <parameter name="id">
  35.             <xsp:attribute name="value"><xsp-request:get-parameter name="id"/></xsp:attribute>
  36.           </parameter>
  37.           <esql:connection>
  38.             <esql:pool>personnel</esql:pool>
  39.             <esql:execute-query>
  40.               <esql:query>
  41.                 SELECT name FROM department
  42.                     WHERE id = <esql:parameter type="int"><xsp:expr>Integer.parseInt(<xsp-request:get-parameter name="id" default="0"/>)</xsp:expr></esql:parameter>
  43.               </esql:query>
  44.               <esql:results>
  45.                 <esql:row-results>
  46.                   Name: <text name="name" size="30" required="true">
  47.                   <xsp:attribute name="value"><esql:get-string column="name"/></xsp:attribute>
  48.                   </text><br />
  49.                   <xsp-formval:on-toosmall name="name">
  50.                     Name must be at least 5 characters.
  51.                   </xsp-formval:on-toosmall>
  52.                   <xsp-formval:on-toolarge name="name">
  53.                     Name must be less than 64 characters.
  54.                   </xsp-formval:on-toolarge>
  55.                 </esql:row-results>
  56.               </esql:results>
  57.             </esql:execute-query>
  58.           </esql:connection>
  59.         </p>
  60.         <submit name="Update Department"/><submit name="Delete Department"/>
  61.         <note>
  62.           * These fields are required.
  63.         </note>
  64.       </form>
  65.     </s1>
  66.   </body>
  67. </document>
  68. </xsp:page>
  69.