C:\code\src\poolman\apps\poolman-struts.jsp

<%@ page language="java" %> 
 
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> 
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> 
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> 
 
<html:html> 
 
<head> 
<title> 
  The Code Studio: PoolMan Struts-Based Database Client 
</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 Struts-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-struts.html"><font face="Helvetica,Arial" size="2">[JSP source]</font></a><br> 
  <a href="PoolManAction.html"><font face="Helvetica,Arial" size="2">[PoolMan Struts Action class source]</font></a><br> 
  <br><br> 
  </td> 
</tr> 
<!-- END PAGE TITLE --> 
 
 
<!-- BEGIN QUERY SECTION --> 
<html:form name="poolmanForm" type="com.codestudio.bean.struts.PoolManActionFormBean" action="/poolman.do" focus="sql"> 
 
<tr> 
  <td bgcolor="gray"> 
  <table cellpadding="2" cellspacing="0" width="100%"> 
 
  <logic:present name="poolmanForm" property="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"> 
       <html:select property="currentDatabaseName"> 
         <html:options property="allDatabaseNames"/> 
       </html: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"> 
        <html:text property="sql" size="50"/> 
    </font> 
    </td> 
  </tr> 
 
  <tr> 
    <td bgcolor="lightgrey"></td> 
    <td bgcolor="lightgrey"> 
	<font face="Helvetica,Arial"> 
        <html:submit accesskey="x"> 
        Execute 
        </html:submit> 
        <html:reset accesskey="C"> 
        Clear 
        </html:reset> 
	</font> 
    </td> 
  </tr> 
  </logic:present> 
 
  <logic:notPresent name="poolmanForm" property="allDatabaseNames"> 
  <tr> 
    <td bgcolor="lightgrey"> 
	<font face="Helvetica,Arial"> 
	<b>No databases found! Please check the location of poolman.xml.</b> 
	</font> 
    </td> 
  </tr> 
  </logic:notPresent> 
 
  </table> 
 
  </td> 
</tr> 
</html:form> 
<!-- END QUERY SECTION --> 
 
 
<!-- BEGIN RESULTS SECTION --> 
<logic:present name="poolmanResults"> 
 
<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 --> 
       <logic:present name="poolmanResults" property="error"> 
       <tr><td bgcolor="white"> 
       <font face="Helvetica,Arial" size="3" align="center"> 
       <br><b>A SQLException was encountered:</b><br><br> 
         <bean:write name="poolmanResults" property="error"/> 
       </font> 
       </td></tr> 
       </logic:present> 
 
       <logic:present name="poolmanResults" property="rows"> 
 
         <!-- result set header --> 
         <logic:present name="poolmanResults" property="headerColumns"> 
         <tr> 
           <logic:iterate name="poolmanResults" property="headerColumns" id="headerCell" type="java.lang.String"> 
             <td bgcolor="white"><font face="Helvetica,Arial" size="3" align="center"><b> 
             <bean:write name="headerCell"/> 
             </b></font></td> 
           </logic:iterate> 
         </tr> 
         </logic:present> 
 
         <!-- result set rows --> 
         <logic:iterate name="poolmanResults" property="rows" id="rows" type="java.util.ArrayList"> 
           <tr> 
           <logic:iterate name="rows" id="rowCell" type="java.lang.Object"> 
             <td bgcolor="white"><font face="Helvetica,Arial" size="3"> 
             <bean:write name="rowCell"/> 
             </font></td> 
           </logic:iterate> 
           </tr> 
         </logic:iterate> 
 
       </logic:present> 
 
       </table> 
 
       </td> 
 
       <!-- metrics --> 
       <td bgcolor="lightgrey"> 
       <font face="Helvetica,Arial"> 
 
	   <b><u>PoolMan Info</u></b><br> 
 
       Number of queries this session: <bean:write name="poolmanMetrics" property="queryCount"/><br> 
       Last statement: <bean:write name="poolmanForm" property="sql"/><br> 
       Current database pool: <bean:write name="poolmanForm" property="currentDatabaseName"/><br> 
       Using cache: <bean:write name="poolmanMetrics" property="usingCache"/><br> 
       DB URL: <bean:write name="poolmanMetrics" property="url"/><br> 
       DB Driver: <bean:write name="poolmanMetrics" property="dbDriver"/><br> 
       DB User: <bean:write name="poolmanMetrics" property="user"/><br> 
 
       <br><br> 
       <b><u>PoolMan Metrics</u></b><br> 
 
       Total connections in this pool: <bean:write name="poolmanMetrics" property="totalConnections"/><br> 
       Available connections: <bean:write name="poolmanMetrics" property="availableConnections"/><br> 
       Unavailable connections: <bean:write name="poolmanMetrics" property="unavailableConnections"/><br> 
       Last query execution time: <bean:write name="poolmanMetrics" property="lastQueryDuration"/> millis<br> 
 
       </font> 
       </td> 
 
     </tr> 
 
   </table> 
   </td> 
</tr> 
 
</logic:present> 
<!-- END RESULTS SECTION --> 
 
 
</table> 
</center> 
</body> 
 
</html:html>