<!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="../setconn.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 JDBC Samples</font></font></b></td>
</tr>

<tr>
<td WIDTH="35"></td>
<td COLSPAN="2"><b><font face="Arial, Helvetica"><font size=-1>ConnCache1.jsp</font></font></b>
<br><font size=-1>
Connection Cache Sample #1: display the employee table in the database.
</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="ConnCache1.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/jdbc/ConnCache1.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>ConnCache2.jsp</font></font></b>
<br><font size=-1>
Connection Cache Sample #2: display the username of the 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="ConnCache2.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/jdbc/ConnCache2.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>setupcache.jsp</font></font></b>
<br><font size=-1>
Sample #1 and sample #2 both make use of a common included
JSP file - setupcache.jsp. setupcache.jsp creates an application-based 
bean which is the connection cache object shared by both sample pages.
</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/jdbc/setupcache.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>ConnCache3.jsp</font></font></b>
<br><font size=-1>
Connection Cache Sample #3: Similar to Sample #1. <br>
But, this page does not include <b>setupcache.jsp</b>. It creates a session-based connection cache by itself.
</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="ConnCache3.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/jdbc/ConnCache3.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>JDBCQuery.jsp</font></font></b>
<br><font size=-1>
Search condition JDBC 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="JDBCQuery.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/jdbc/JDBCQuery.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>SimpleQuery.jsp</font></font></b>
<br><font size=-1>
A very simple JDBC 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="SimpleQuery.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/jdbc/SimpleQuery.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>UseHtmlQueryBean.jsp</font></font></b>
<br><font size=-1>
A JDBC sample that make use of a JavaBean that perform a where-condition search and format the result into HTML.
</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="UseHtmlQueryBean.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/jdbc/UseHtmlQueryBean.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="../changeConn.jsp" >
<INPUT TYPE="submit" VALUE="Change Connection String" >
<INPUT TYPE="hidden" NAME="nextaction" VALUE="./jdbc/index.jsp" >
</FORM>
</font>
</body>
</html>
