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>