database.jsp

来自「Jive是基于JSP/JAVA技术构架的一个大型BBS论坛系统,这是Jive论坛」· JSP 代码 · 共 516 行 · 第 1/2 页

<tr bgcolor="#ffffff">
    <td><font size="-1">Average time for all inserts (ms)</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getAverageQueryTime(ProfiledConnection.INSERT),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Inserts per second</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.INSERT),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">10 Most common inserts</font></td>
    <td bgcolor="#ffffff"><%
            list = ProfiledConnection.getSortedQueries(ProfiledConnection.INSERT, sortByTime);

            if (list == null || list.length < 1) {
                out.println("<font size=\"-1\">No queries</font>");
            }
            else {  %>
            &nbsp;
     </td>
</tr>
</table>
</td></tr>
</table>

<br>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="0" border="0" width="100%">
<tr bgcolor="#ffffff"><td>
<%
        out.println("<table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"0\" bgcolor=\"" + tblBorderColor + "\"><tr><td bgcolor=\"#ffffff\" align=\"middle\"><font size=\"-1\"><b>Query</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=false';\">Count</a></b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b>Total Time (ms)</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=true';\">Average Time</a> (ms)</b></font></td></tr>");

        alternate = 0;

        for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) {
            ProfiledConnectionEntry pce = list[i];
            out.println("<tr><td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.sql + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.count + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate++%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime/pce.count + "</font></td></tr>");
        }
        out.println("</table>");
    }
    %></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<font size="-1"><b>Update Query Statistics</b></font>

<ul>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td><font size="-1">Total # of updates</font></td>
    <td><font size="-1"><%= ProfiledConnection.getQueryCount(ProfiledConnection.UPDATE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Total time for all updates (ms)</font></td>
    <td><font size="-1"><%= ProfiledConnection.getTotalQueryTime(ProfiledConnection.UPDATE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Average time for all updates (ms)</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getAverageQueryTime(ProfiledConnection.UPDATE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Updates per second</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.UPDATE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">10 Most common updates</font></td>
    <td bgcolor="#ffffff"><%
            list = ProfiledConnection.getSortedQueries(ProfiledConnection.UPDATE, sortByTime);

            if (list == null || list.length < 1) {
                out.println("<font size=\"-1\">No queries</font>");
            }
            else { %>
            &nbsp;
     </td>
</tr>
</table>
</td></tr>
</table>

<br>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="0" border="0" width="100%">
<tr bgcolor="#ffffff"><td>
<%
        out.println("<table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"0\" bgcolor=\"" + tblBorderColor + "\"><tr><td bgcolor=\"#ffffff\" align=\"middle\"><font size=\"-1\"><b>Query</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=false';\">Count</a></b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b>Total Time (ms)</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=true';\">Average Time</a> (ms)</b></font></td></tr>");

        alternate = 0;

        for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) {
            ProfiledConnectionEntry pce = list[i];
            out.println("<tr><td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.sql + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.count + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate++%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime/pce.count + "</font></td></tr>");
        }
        out.println("</table>");
    }
    %></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<font size="-1"><b>Delete Query Statistics</b></font>

<ul>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td><font size="-1">Total # of deletes</font></td>
    <td><font size="-1"><%= ProfiledConnection.getQueryCount(ProfiledConnection.DELETE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Total time for all deletes (ms)</font></td>
    <td><font size="-1"><%= ProfiledConnection.getTotalQueryTime(ProfiledConnection.DELETE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Average time for all deletes (ms)</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getAverageQueryTime(ProfiledConnection.DELETE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Deletes per second</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.DELETE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">10 Most common deletes</font></td>
    <td bgcolor="#ffffff"><%
            list = ProfiledConnection.getSortedQueries(ProfiledConnection.DELETE, sortByTime);

            if (list == null || list.length < 1) {
                out.println("<font size=\"-1\">No queries</font>");
            }
            else { %>
            &nbsp;
     </td>
</tr>
</table>
</td></tr>
</table>

<br>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="0" border="0" width="100%">
<tr bgcolor="#ffffff"><td>
<%
        out.println("<table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"0\" bgcolor=\"" + tblBorderColor + "\"><tr><td bgcolor=\"#ffffff\" align=\"middle\"><font size=\"-1\"><b>Query</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=false';\">Count</a></b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b>Total Time (ms)</b></font></td>");
        out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='database.jsp?sortByTime=true';\">Average Time</a> (ms)</b></font></td></tr>");

        alternate = 0;

        for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) {
            ProfiledConnectionEntry pce = list[i];
            out.println("<tr><td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.sql + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.count + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime + "</font></td>");
            out.println("<td bgcolor=\"" + ((alternate++%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime/pce.count + "</font></td></tr>");
        }
        out.println("</table>");
    }
    %></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<ul>
<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="300">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td colspan="2">
        <form action="database.jsp">
        <input type="hidden" name="doClear" value="true">
        <input type="submit" value="Clear Query Statistics">
        </form></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<% } %>

<font size="-1"><b>Query Statistics</b></font>

<ul>

<form action="database.jsp">
<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="300">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td align="center" <%= ((doLog) ? "bgcolor=\"#99cc99\"":"") %>>
    <font size="-1">
        <input type="radio" name="doLog" value="true" id="rb01" <%= ((doLog) ? "checked":"") %>>
        <label for="rb01"><%= ((doLog) ? "<b>On</b>":"On") %></label>
    </font>
    </td>
    <td align="center" <%= ((!doLog) ? "bgcolor=\"#cc6666\"":"") %>>
    <font size="-1">
        <input type="radio" name="doLog" value="false" id="rb02" <%= ((!doLog) ? "checked":"") %>>
        <label for="rb02"><%= ((!doLog) ? "<b>Off</b>":"Off") %></label>
    </font>
    </td>
    <td align="center">
        <input type="submit" value="Update">
    </td>
</tr>
</table>
</td></tr>
</table>
</form>

</ul>

<%      } finally {
            try { con.close(); }
            catch (Exception e) { e.printStackTrace(); }
        }
    }
%>

</body>
</html>