Cocoon/my.xsp

From Fxp Wiki

 
 
<?xml version="1.0" encoding="ISO-8859-1"?>
 
<xsp:page language="java" xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp="http://apache.org/xsp">
<page>
 <title>Hello World!</title>
 <content>
  <paragraph>This is my first Cocoon page!cibcib3</paragraph>
 </content>
 
 
<query>
 
<esql:connection>
		
  
  
			<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
			<esql:dburl>jdbc:mysql://localhost/cib1</esql:dburl>
 
			<esql:username></esql:username>
			<esql:password></esql:password>
 
 
<esql:execute-query>
    <esql:query>SELECT Notion,langue FROM notions</esql:query>
    <esql:results>
      <table>
        <esql:row-results>
          <tr>
             <td><esql:get-string column="Notion"/></td>
             <td><esql:get-string column="langue"/></td>
          </tr>
        </esql:row-results>
      </table>
    </esql:results>
    <esql:no-results>
       <p>Sorry, no results!</p>
    </esql:no-results>
  </esql:execute-query>
 
 
&lt;BR/&gt;
&lt;I&gt;QUERY 2&lt;/I&gt;
&lt;BR/&gt;
 
<esql:execute-query>
       <esql:query>select * from notions</esql:query>
       <esql:results>
         <esql:row-results>
           <para><esql:get-string column="Notion"/></para>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
 
 
<esql:execute-query>
			<esql:query>select * from notions</esql:query>
 
			<esql:results>
				
				<notions>hi cib<esql:get-string column="notion"/></notions>
				<lg><esql:get-string column="Langue"/></lg>
								
			</esql:results>
 
			<esql:no-results><error>no results were found</error></esql:no-results>
 
			<esql:error-results>
				 <message><esql:get-message/></message>
				 <stacktrace><esql:get-stacktrace/></stacktrace>
			</esql:error-results>
 
		</esql:execute-query>
 
</esql:connection>
	</query>
 
 
 
</page>
 
</xsp:page>