<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
   <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
   <meta name="GENERATOR" content="Mozilla/4.72 [en] (X11; I; SunOS 5.6 sun4u) [Netscape]">
   <title>OracleJSP</title>
</head>
<body bgcolor="#FFFFFF">
&nbsp;

<br>
<jsp:include page="setDataSource.jsp" flush="true" />

<table BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%" >
<tr VALIGN=TOP>
<td WIDTH="100%">
<table BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%" >
<tr>
<td>
<table BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%" >
<tr>
<td COLSPAN="3"><a NAME="general"></a><b><font face="Arial, Helvetica">
<font size=+1>JSP SQL Tag Samples</font><br>
(Please click <a href="taglib.html">here</a> for detailed descriptions 
of SQL Access Tag Library.)</font></b></td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample1.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that opens connection, executes query and closes connection
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample1.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample1.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica">
<font size=-1>sample2.jsp</font></font></b>
<br><font size=-1>
A SQL tag sample that makes use of nested tags with Query inside Open and does a where-condition search.
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td> 
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="sample2.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="../../../servlet/ViewSrc/jsp/sql/tag/sample2.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica">
<font size=-1>sample3.jsp</font></font></b>
<br><font size=-1>
A SQL access tag that outputs in XML and transforms with an XSL style sheet
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="sample3.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="indx3.html">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica">
<font size=-1>sample4.jsp</font></font></b>
<br><font size=-1>
A SQL access tag sample that iterates through a result set
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="sample4.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="../../../servlet/ViewSrc/jsp/sql/tag/sample4.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica">
<font size=-1>sample5.jsp</font></font></b>
<br><font size=-1>
A DML sample
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="sample5.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1>
<a href="../../../servlet/ViewSrc/jsp/sql/tag/sample5.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>




<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample6.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that can allow user input skiprows and maxrows in query
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample6.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample6.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>


<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample7.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that has skiprows and maxrows combined with tag dbNextRow
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample7.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample7.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>


<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample8.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that has bindparams in the query
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample8.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample8.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>


<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample9.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that has bindparams in the insert query
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample9.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample9.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>


<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample10.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that has bindparams in the insert query and get the value set from session
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample10.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample10.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>


<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>sample11.jsp</font></font></b>
<br><font size=-1>
A simple SQL tag sample that can set cookie
</font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="sample11.jsp">Try it</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35"></td>
<td WIDTH="100%"><spacer TYPE="HORIZONTAL" SIZE="35"><font size=-1><a href="../../../servlet/ViewSrc/jsp/sql/tag/sample11.jsp">Source</a></font></td>
</tr>
<tr>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="35">&nbsp;</td>
<td WIDTH="100%">&nbsp;</td>
</tr>





</table>
</td>
</tr>
</table>
</td>

<td WIDTH="15"></td>

<td WIDTH="1"></td>

<td WIDTH="15"></td>

<td WIDTH="100">&nbsp;</td>
</tr>
</table>
<font size=+0>
<FORM METHOD=get ACTION="changeDataSource.jsp" >
<INPUT TYPE="submit" VALUE="Change Data Source String" >
<INPUT TYPE="hidden" NAME="nextaction" VALUE="./index.jsp" >
</FORM>
</font>
</body>
</html>
