First page Back Continue Last page Overview Graphics
XSP Examples : ESQL
<xsp:page xmlns:xsp="http://apache.org/xsp/core/v1"
xmlns:esql="http://apache.org/xsp/SQL/v2"
xmlns:except="http://axkit.org/NS/xsp/exception/v1"
xmlns:param="http://axkit.org/NS/xsp/param/v1">
<addresses>
<esql:connection>
<esql:driver>Pg</esql:driver>
<esql:dburl>dbname=phonebook</esql:dburl>
<esql:username>postgres</esql:username>
<esql:password></esql:password>
<esql:execute-query>
<xsp:logic>
if (<param:address_id/>) {
<esql:query>
SELECT * FROM address WHERE id =
<esql:parameter><param:address_id/></esql:parameter>
</esql:query>
} else {
<esql:query>
SELECT * FROM address
</esql:query>
}
</xsp:logic>