C:\code\src\poolman\apps\poolman-velocity.vm

<html> 
<head> 
  <title>The Code Studio: PoolMan Velocity-Based Web Application</title> 
</head> 
<body bgcolor="#ffffff"> 
 
<center> 
<table border="0" cellpadding="6" cellspacing="4"> 
 
<!-- BEGIN PAGE TITLE --> 
<tr valign="top"> 
  <td> 
  <font face="Helvetica,Arial" size="5" color="#000080"> 
  <b>PoolMan Velocity-Based Database Client</b><br> 
  </font> 
  <font face="Helvetica,Arial" size="2" color="#808080"> 
  <i>PoolMan v2.1</i></font><br><br> 
  <a href="poolman-velocity.html"><font face="Helvetica,Arial" size="2">[Velocity XML template source]</font></a><br> 
  <a href="PoolManVelocityServlet.html"><font face="Helvetica,Arial" size="2">[Velocity PoolMan servlet source]</font></a><br> 
  <br><br> 
  </td> 
</tr> 
<!-- END PAGE TITLE --> 
 
 
<!-- BEGIN QUERY SECTION --> 
<form name="poolmanForm" action="PoolManVelocityServlet"> 
 
<tr> 
  <td bgcolor="gray"> 
  <table cellpadding="2" cellspacing="0" width="100%"> 
 
 
  #if ($allDatabaseNames) 
  <tr> 
    <td bgcolor="lightgrey" align="center" colspan="2"> 
	<font face="Helvetica,Arial" size="4"> 
	<b>SQL Statement</b><br> 
	</font> 
    </td> 
  </tr> 
 
  <tr> 
    <td bgcolor="lightgrey"> 
	<font face="Helvetica,Arial"> 
	<b>Use Database Pool:</b> 
	</font> 
    </td> 
 
    <td bgcolor="lightgrey"> 
      <font face="Helvetica,Arial"> 
       <select name="currentDatabaseName"> 
       #foreach ($databaseName in $allDatabaseNames) 
         <option>$databaseName 
       #end 
       </select> 
      </font> 
    </td> 
  </tr> 
 
  <tr> 
    <td bgcolor="lightgrey"> 
    <font face="Helvetica,Arial"> 
	<b>Enter SQL:</b> 
    </font> 
    </td> 
 
    <td bgcolor="lightgrey"> 
    <font face="Helvetica,Arial"> 
        <input name="sql" size="50" value="$sql"> 
    </font> 
    </td> 
  </tr> 
 
  <tr> 
    <td bgcolor="lightgrey"></td> 
    <td bgcolor="lightgrey"> 
	<font face="Helvetica,Arial"> 
        <input type="Submit" value="Execute"> 
        <input type="Reset" value="Clear"> 
	</font> 
    </td> 
  </tr> 
 
  #else 
     <tr><td bgcolor="lightgrey" align="center"> 
       <font face="Helvetica,Arial"> 
       <b>No databases found! Please check the location of poolman.xml.</b> 
       </font> 
     </td></tr> 
  #end 
 
  </table> 
 
  </td> 
</tr> 
</form> 
<!-- END QUERY SECTION --> 
 
 
<!-- BEGIN RESULTS SECTION --> 
 
#if ($resultsRows || $errors) 
 
<tr valign="top"> 
  <td bgcolor="gray" align="center"> 
 
  <table cellpadding="10" cellspacing="0" width="100%"> 
 
    <tr valign="top"> 
      <td bgcolor="lightgrey" colspan="2" align="center"> 
	  <font face="Helvetica,Arial" size="4"> 
	  <b>SQL Results</b></font><p> 
	  </td> 
     </tr> 
 
     <tr valign="top"> 
 
       <!-- results --> 
       <td bgcolor="lightgrey"> 
       <font face="Helvetica,Arial"> 
	   <b><u>ResultSet</u></b> 
	   </font><br> 
 
       <table cellpadding="1" cellspacing="2" border="1"> 
 
       <!-- if there are errors, print them and no results --> 
       #if ($errors) 
       <tr><td bgcolor="white"> 
       <font face="Helvetica,Arial" size="3" align="center"> 
       <br><b>A SQLException was encountered:</b><br><br> 
         $errors 
       </font> 
       </td></tr> 
 
       #elseif ($resultsRows) 
 
         <!-- result set header --> 
         <tr> 
           #foreach ($headerCell in $headerColumns) 
             <td bgcolor="white"><font face="Helvetica,Arial" size="3" align="center"><b> 
             $headerCell 
             </b></font></td> 
           #end 
         </tr> 
 
         <!-- result set rows --> 
         #foreach ($row in $resultsRows) 
           <tr> 
           #foreach ($rowCell in $row) 
             <td bgcolor="white"><font face="Helvetica,Arial" size="3"> 
             $rowCell 
             </font></td> 
           #end 
           </tr> 
         #end 
 
       #end 
 
       </table> 
 
       </td> 
 
       <!-- metrics --> 
       <td bgcolor="lightgrey"> 
       <font face="Helvetica,Arial"> 
 
	   <b><u>PoolMan Info</u></b><br> 
 
       Number of queries this session: $queryCount<br> 
       Last statement: $sql<br> 
       Current database pool: $currentDatabaseName<br> 
       Using cache: $usingCache<br> 
       DB URL: $url<br> 
       DB Driver: $driver<br> 
       DB User: $user<br> 
 
       <br><br> 
       <b><u>PoolMan Metrics</u></b><br> 
 
       Total connections in this pool: $totalConnections<br> 
       Available connections: $availableConnections<br> 
       Unavailable connections: $unavailableConnections<br> 
       Last query execution time: $lastQueryDuration millis<br> 
 
       </font> 
       </td> 
 
     </tr> 
 
   </table> 
   </td> 
</tr> 
 
#end 
<!-- END RESULTS SECTION --> 
 
 
</table> 
</center> 
</body> 
 
</html>