关闭

用PrintWriter解决servlet的中文输出问题

标签: servletoutputstatisticsstringnullinterface
6179人阅读 评论(0) 收藏 举报

在Java的Servlet中用ServletOutputStream.print()方法输出中文会有问题,如

ServletOutputStream out = response.getOutputStream();
out.print("你好");

在tomcat6会出现错误提示:
java.io.CharConversionException: Not an ISO 8859-1 character

在tomcat5或tomcat4能显示页面,但中文也是乱码。

解决办法:
 response.setCharacterEncoding("UTF-8"); (也可以是其他编码如GBK)
 response.setContentType("text/html");
或者直接
 response.setContentType("text/html;charset=UTF-8");

然后

 PrintWriter out = response.getWriter();
 out.print("你好");
就能正常显示中文。

用此办法解决了proxool控制台org.logicalcobwebs.proxool.admin.servlet.AdminServlet不能显示中文的bug

该AdminServlet的doSnapshot()输出时间:

 DateFormat DATE_FORMAT = new SimpleDateFormat("dd-MMM-yyyy HH:mm:ss");
 DATE_FORMAT.format(snapshot.getDateStarted())

正常应该显示如下格式:
 29-二月-2008 00:28:42

其中"月份"带了中文。

为了正常显示中文,把org.logicalcobwebs.proxool.admin.servlet.AdminServlet源代码抽出来修改

加入PrintWriter包:
 import java.io.PrintWriter;
将所有的ServletOutputStream用PrintWriter替换,所有的getOutputStream用getWriter替换

在doGet()中的response.setHeader("Pragma", "no-cache")语句后添加上编码:
        response.setCharacterEncoding("UTF-8");

编译该AdminServlet.java,运行一切ok!

附源代码:

  另,对AdminServlet显示数据库连接url带用户名密码的bug做了修改:

        String url= drillDownConnection.getDelegateUrl();


        String[] urls=url.split("//?"); //这种方式只能解决mysql数据库的url,可以考虑

干脆不显示url,就能避免用户名密码暴露。

        out.print(urls[0]);//Hide the user & password of url

----------------------------------

 

/*
 * This software is released under a licence similar to the Apache Software Licence.
 * See org.logicalcobwebs.proxool.package.html for details.
 * The latest version is available at 
http://proxool.sourceforge.net
 
*/

package org.logicalcobwebs.proxool.admin.servlet;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.logicalcobwebs.proxool.*;
import org.logicalcobwebs.proxool.admin.SnapshotIF;
import org.logicalcobwebs.proxool.admin.StatisticsIF;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.Iterator;
import java.util.Properties;

/**
 * Use this to admin each pool within Proxool. It acts like a normal
 * servlet., so just configure it within your web app as you see fit.
 * For example, within web.xml:
 * <pre>
 *   &lt;servlet&gt;
 *       &lt;servlet-name&gt;Admin&lt;/servlet-name&gt;
 *       &lt;servlet-class&gt;org.logicalcobwebs.proxool.admin.servlet.AdminServlet&lt;/servlet-class&gt;
 *       &lt;init-param&gt;
 *            &lt;param-name&gt;output&lt;/param-name&gt;
 *            &lt;param-value&gt;full|simple&lt;/param-value&gt;
 *        &lt;/init-param&gt;
 *        &lt;init-param&gt;
 *            &lt;param-name&gt;cssFile&lt;/param-name&gt;
 *            &lt;param-value&gt;/my_path/my.css&lt;/param-value&gt;
 *        &lt;/init-param&gt;
 *   &lt;/servlet&gt;
 *   &lt;servlet-mapping&gt;
 *       &lt;servlet-name&gt;Admin&lt;/servlet-name&gt;
 *       &lt;url-pattern&gt;/proxool&lt;/url-pattern&gt;
 *   &lt;/servlet-mapping&gt;
 * </pre>
 *
 * Options:
 * <ul>
 *   <li>output: full|simple. "full" means with HTML header and body tags "simple" means
 *   just the HTML. Choose "simple" if you are including this servlet within your own
 *   web page. Note that if you choose simple output then you're probably going to want
 *   to consider supplying some CSS to make it look nice.</li>
 *   <li>cssFile: If you choose full output (see above) then some CSS is included, inline,
 *   in the HTML header. If you specify a URL here then that file is also linked to. It is
 *   linked after the inline CSS so you only have to override thos styles you want to be
 *   different.</li>
 * </ul>
 *
 * 
@author bill
 * 
@author $Author: billhorsman $ (current maintainer)
 * 
@version $Revision: 1.14 $, $Date: 2006/06/09 17:32:54 $
 * 
@since Proxool 0.7
 * @modified by goodhumor $Date: 2008/02/29 00:28:42$
 
*/

public class AdminServlet extends HttpServlet {

    
private static final Log LOG = LogFactory.getLog(ProxoolAdminServlet.class);

    
/**
     * The CSS class for a connection in different states:
     * <ul>
     *   <li>null</li>
     *   <li>available</li>
     *   <li>active</li>
     *   <li>offline</li>
     * </ul>
     
*/

    
private static final String[] STATUS_CLASSES = {"null""available""active""offline"};

    
/**
     * OUtput full HTML including &lt;HTML&gt;, &lt;HEAD&gt; and &lt;BODY&gt; tags.
     * 
@see #output
     * 
@see ProxoolAdminServlet configuration
     
*/

    
public static final String OUTPUT_FULL = "full";

    
/**
     * OUtput simple HTML <em>excluding</em> &lt;HTML&gt;, &lt;HEAD&gt; and &lt;BODY&gt; tags.
     * 
@see #output
     * 
@see ProxoolAdminServlet configuration
     
*/

    
public static final String OUTPUT_SIMPLE = "simple";

    
/**
     * Either {
@link #OUTPUT_FULL} (default) or {@link #OUTPUT_SIMPLE}
     * 
@see ProxoolAdminServlet configuration
     
*/

    
private String output;

    
/**
     * A valid URLL that can be linked to to override default, inline CSS.
     * 
@see ProxoolAdminServlet configuration
     
*/


    
private String cssFile;

    
/**
     * Used as part of the CSS class
     
*/

    
private static final String STATISTIC = "statistic";

    
/**
     * Used as part of the CSS class
     
*/

    
private static final String CORE_PROPERTY = "core-property";

    
/**
     * Used as part of the CSS class
     
*/

    
private static final String STANDARD_PROPERTY = "standard-property";

    
/**
     * Used as part of the CSS class
     
*/

    
private static final String DELEGATED_PROPERTY = "delegated-property";

    
/**
     * Used as part of the CSS class
     
*/

    
private static final String SNAPSHOT = "snapshot";

    
public void init(ServletConfig servletConfig) throws ServletException {
        
super.init(servletConfig);

        
// Get output parameter. Default to OUTPUT_FULL.
        output = servletConfig.getInitParameter("output");
        
if (output != null{
            
if (output.equalsIgnoreCase(OUTPUT_FULL)) {
                output 
= OUTPUT_FULL;
            }
 else if (output.equalsIgnoreCase(OUTPUT_SIMPLE)) {
                output 
= OUTPUT_SIMPLE;
            }
 else {
                LOG.warn(
"Unrecognised output parameter for " + this.getClass().getName() + ". Expected: " + OUTPUT_FULL + " or " + OUTPUT_SIMPLE);
                output 
= null;
            }

        }

        
if (output == null{
            output 
= OUTPUT_FULL;
        }


        cssFile 
= servletConfig.getInitParameter("cssFile");

    }


    
/**
     * HH:mm:ss
     * 
@see #formatMilliseconds
     
*/

    
private static final DateFormat TIME_FORMAT = new SimpleDateFormat("HH:mm:ss");

    
/**
     * dd-MMM-yyyy HH:mm:ss
     
*/

    
private static final DateFormat DATE_FORMAT = new SimpleDateFormat("dd-MMM-yyyy HH:mm:ss");

    
private static final DecimalFormat DECIMAL_FORMAT = new DecimalFormat("0.00");

    
private static final String DETAIL = "detail";
    
private static final String DETAIL_MORE = "more";
    
private static final String DETAIL_LESS = "less";

    
/**
     * The request parameter name that defines:
     * <ol>
     *   <li>{
@link #TAB_DEFINITION} (default)</li>
     *   <li>{
@link #TAB_SNAPSHOT}</li>
     *   <li>{
@link #TAB_STATISTICS}</li>
     *  </ol>
     
*/

    
private static final String TAB = "tab";

    
/**
     * 
@see #TAB
     
*/

    
private static final String TAB_DEFINITION = "definition";

    
/**
     * 
@see #TAB
     
*/

    
private static final String TAB_SNAPSHOT = "snapshot";

    
/**
     * 
@see #TAB
     
*/

    
private static final String TAB_STATISTICS = "statistics";

    
/**
     * The request parameter name that defines the pool
     
*/

    
private static final String ALIAS = "alias";

    
/**
     * If we are drilling down into a connection (on the {
@link #TAB_SNAPSHOT snapshot} tab then
     * this points to the {
@link org.logicalcobwebs.proxool.ProxyConnection#getId() ID} we are
     * getting detailed information for.
     
*/

    
private static final String CONNECTION_ID = "id";

    
/**
     * Delegate to {
@link #doGet(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)}
     
*/

    
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }


    
/**
     * Show the details for a pool.
     
*/

    
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setHeader(
"Pragma""no-cache");
        response.setCharacterEncoding(
"UTF-8");
        String link 
= request.getRequestURI();

        
// Check the alias and if not defined and there is only one
        
// then use that.
        String alias = request.getParameter(ALIAS);
        
// Check we can find the pool.
        ConnectionPoolDefinitionIF def = null;
        
if (alias != null{
            
try {
                def 
= ProxoolFacade.getConnectionPoolDefinition(alias);
            }
 catch (ProxoolException e) {
                alias 
= null;
            }

        }

        String[] aliases 
= ProxoolFacade.getAliases();
        
if (alias == null{
            
if (aliases.length > 0{
                alias 
= aliases[0];
            }

        }

        
if (def == null && alias != null{
            
try {
                def 
= ProxoolFacade.getConnectionPoolDefinition(alias);
            }
 catch (ProxoolException e) {
                
throw new ServletException("Couldn't find pool with alias " + alias);
            }

        }


        String tab 
= request.getParameter(TAB);
        
if (tab == null{
            tab 
= TAB_DEFINITION;
        }


        
// If we are showing the snapshot, are we showing it in detail or not?
        String snapshotDetail = request.getParameter(DETAIL);

        
// If we are showing the snapshot, are we drilling down into a connection?
        String snapshotConnectionId = request.getParameter(CONNECTION_ID);

        
try {
            
if (output.equals(OUTPUT_FULL)) {
                response.setContentType(
"text/html");

                openHtml(response.getWriter());
            }

            response.getWriter().println(
"<div class="version">Proxool " + Version.getVersion() + "</div>");
            doList(response.getWriter(), alias, tab, link);
            
// Skip everything if there aren't any pools
            if (aliases != null && aliases.length > 0{
                StatisticsIF[] statisticsArray 
= ProxoolFacade.getStatistics(alias);
                
final boolean statisticsAvailable = (statisticsArray != null && statisticsArray.length > 0);
                
final boolean statisticsComingSoon = def.getStatistics() != null;
                
// We can't be on the statistics tab if there are no statistics
                if (!statisticsComingSoon && tab.equals(TAB_STATISTICS)) {
                    tab 
= TAB_DEFINITION;
                }

                doTabs(response.getWriter(), alias, link, tab, statisticsAvailable, statisticsComingSoon);
                
if (tab.equals(TAB_DEFINITION)) {
                    doDefinition(response.getWriter(), def);
                }
 else if (tab.equals(TAB_SNAPSHOT)) {
                    doSnapshot(response.getWriter(), def, link, snapshotDetail, snapshotConnectionId);
                }
 else if (tab.equals(TAB_STATISTICS)) {
                    doStatistics(response.getWriter(), statisticsArray, def);
                }
 else {
                    
throw new ServletException("Unrecognised tab '" + tab + "'");
                }

            }

        }
 catch (ProxoolException e) {
            
throw new ServletException("Problem serving Proxool Admin", e);
        }


        
if (output.equals(OUTPUT_FULL)) {
            closeHtml(response.getWriter());
        }


    }


    
/**
     * Output the tabs that we are showing at the top of the page
     * 
@param out where to write the HTNL to
     * 
@param alias the current pool
     * 
@param link the URL to get back to this servlet
     * 
@param tab the active tab
     * 
@param statisticsAvailable whether statistics are available (true if configured and ready)
     * 
@param statisticsComingSoon whether statistics will be available (true if configured but not ready yet)
     
*/

    
private void doTabs(PrintWriter out, String alias, String link, String tab, boolean statisticsAvailable, boolean statisticsComingSoon) throws IOException {
        out.println(
"<ul>");
        out.println(
"<li class="" + (tab.equals(TAB_DEFINITION) ? "active" : "inactive"+ ""><a class="quiet" href="" + link + "?alias=" + alias + "&tab=" + TAB_DEFINITION + "">Definition</a></li>");
        out.println(
"<li class="" + (tab.equals(TAB_SNAPSHOT) ? "active" : "inactive"+ ""><a class="quiet" href="" + link + "?alias=" + alias + "&tab=" + TAB_SNAPSHOT + "">Snapshot</a></li>");
        
if (statisticsAvailable) {
            out.println(
"<li class="" + (tab.equals(TAB_STATISTICS) ? "active" : "inactive"+ ""><a class="quiet" href="" + link + "?alias=" + alias + "&tab=" + TAB_STATISTICS + "">Statistics</a></li>");
        }
 else if (statisticsComingSoon) {
            out.println(
"<li class="disabled">Statistics</li>");
        }

        out.println(
"</ul>");
    }


    
/**
     * Output the statistics. If there are more than one set of statistics then show them all.
     * 
@param out where to write HTML to
     * 
@param statisticsArray the statistics we have ready to see
     * 
@param cpd defines the connection
     
*/

    
private void doStatistics(PrintWriter out, StatisticsIF[] statisticsArray, ConnectionPoolDefinitionIF cpd) throws IOException {

        
for (int i = 0; i < statisticsArray.length; i++{
            StatisticsIF statistics 
= statisticsArray[i];

            openDataTable(out);

            printDefinitionEntry(out, ProxoolConstants.ALIAS, cpd.getAlias(), CORE_PROPERTY);

            
// Period
            printDefinitionEntry(out, "Period", TIME_FORMAT.format(statistics.getStartDate()) + " to " + TIME_FORMAT.format(statistics.getStopDate()), STATISTIC);

            
// Served
            printDefinitionEntry(out, "Served", statistics.getServedCount() + " (" + DECIMAL_FORMAT.format(statistics.getServedPerSecond()) + "/s)", STATISTIC);

            
// Refused
            printDefinitionEntry(out, "Refused", statistics.getRefusedCount() + " (" + DECIMAL_FORMAT.format(statistics.getRefusedPerSecond()) + "/s)", STATISTIC);

            
// averageActiveTime
            printDefinitionEntry(out, "Average active time", DECIMAL_FORMAT.format(statistics.getAverageActiveTime() / 1000+ "s", STATISTIC);

            
// activityLevel
            StringBuffer activityLevelBuffer = new StringBuffer();
            
int activityLevel = (int) (100 * statistics.getAverageActiveCount() / cpd.getMaximumConnectionCount());
            activityLevelBuffer.append(activityLevel);
            activityLevelBuffer.append(
"%<br/>");
            String[] colours 
= {"0000ff""eeeeee"};
            
int[] lengths = {activityLevel, 100 - activityLevel};
            drawBarChart(activityLevelBuffer, colours, lengths);
            printDefinitionEntry(out, 
"Activity level", activityLevelBuffer.toString(), STATISTIC);

            closeTable(out);
        }

    }


    
/**
     * We can draw a bar chart simply enough. The two arrays passed as parameters must be of equal length
     * 
@param out where to write the HTML
     * 
@param colours the colur (CSS valid string) for each segment
     * 
@param lengths the length of each segment. Can be any size since the chart just takes up as much room
     * as possible as uses the relative length of each segment.
     
*/

    
private void drawBarChart(StringBuffer out, String[] colours, int[] lengths) {
        out.append(
"<table style="margin: 8px; font-size: 50%;" width="100%" border="0" cellspacing="0" cellpadding="0"><tr>");

        
// Calculate total length
        int totalLength = 0;
        
for (int i = 0; i < colours.length; i++{
            totalLength 
+= lengths[i];
        }


        
// Draw segments
        for (int j = 0; j < colours.length; j++{
            String colour 
= colours[j];
            
int length = lengths[j];
            
if (length > 0{
                out.append(
"<td style="background-color: #");
                out.append(colour);
                out.append(
"" width="");
                out.append(
100 * length / totalLength);
                out.append(
"%">&nbsp;</td>");
            }

        }

        out.append(
"</tr></table>");
    }


    
/**
     * Output the {
@link ConnectionPoolDefinitionIF definition}
     * 
@param out where to write the HTML
     * 
@param cpd the definition
     
*/

    
private void doDefinition(PrintWriter out, ConnectionPoolDefinitionIF cpd) throws IOException {
        openDataTable(out);

        
/*
            TODO: it would be nice to have meta-data in the definition so that this is much easier.
         
*/

        printDefinitionEntry(out, ProxoolConstants.ALIAS, cpd.getAlias(), CORE_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.DRIVER_URL, cpd.getUrl(), CORE_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.DRIVER_CLASS, cpd.getDriver(), CORE_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.MINIMUM_CONNECTION_COUNT, String.valueOf(cpd.getMinimumConnectionCount()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.MAXIMUM_CONNECTION_COUNT, String.valueOf(cpd.getMaximumConnectionCount()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.PROTOTYPE_COUNT, cpd.getPrototypeCount() 
> 0 ? String.valueOf(cpd.getPrototypeCount()) : null, STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.SIMULTANEOUS_BUILD_THROTTLE, String.valueOf(cpd.getSimultaneousBuildThrottle()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.MAXIMUM_CONNECTION_LIFETIME, formatMilliseconds(cpd.getMaximumConnectionLifetime()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.MAXIMUM_ACTIVE_TIME, formatMilliseconds(cpd.getMaximumActiveTime()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.HOUSE_KEEPING_SLEEP_TIME, (cpd.getHouseKeepingSleepTime() 
/ 1000+ "s", STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.HOUSE_KEEPING_TEST_SQL, cpd.getHouseKeepingTestSql(), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.TEST_BEFORE_USE, String.valueOf(cpd.isTestBeforeUse()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.TEST_AFTER_USE, String.valueOf(cpd.isTestAfterUse()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.RECENTLY_STARTED_THRESHOLD, formatMilliseconds(cpd.getRecentlyStartedThreshold()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.OVERLOAD_WITHOUT_REFUSAL_LIFETIME, formatMilliseconds(cpd.getOverloadWithoutRefusalLifetime()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.INJECTABLE_CONNECTION_INTERFACE_NAME, String.valueOf(cpd.getInjectableConnectionInterface()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.INJECTABLE_STATEMENT_INTERFACE_NAME, String.valueOf(cpd.getInjectableStatementInterface()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.INJECTABLE_CALLABLE_STATEMENT_INTERFACE_NAME, String.valueOf(cpd.getInjectableCallableStatementInterface()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.INJECTABLE_PREPARED_STATEMENT_INTERFACE_NAME, String.valueOf(cpd.getInjectablePreparedStatementInterface()), STANDARD_PROPERTY);

        
// fatalSqlExceptions
        String fatalSqlExceptions = null;
        
if (cpd.getFatalSqlExceptions() != null && cpd.getFatalSqlExceptions().size() > 0{
            StringBuffer fatalSqlExceptionsBuffer 
= new StringBuffer();
            Iterator i 
= cpd.getFatalSqlExceptions().iterator();
            
while (i.hasNext()) {
                String s 
= (String) i.next();
                fatalSqlExceptionsBuffer.append(s);
                fatalSqlExceptionsBuffer.append(i.hasNext() 
? "" : "");
            }

            fatalSqlExceptions 
= fatalSqlExceptionsBuffer.toString();
        }

        printDefinitionEntry(out, ProxoolConstants.FATAL_SQL_EXCEPTION, fatalSqlExceptions, STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.FATAL_SQL_EXCEPTION_WRAPPER_CLASS, cpd.getFatalSqlExceptionWrapper(), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.STATISTICS, cpd.getStatistics(), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.STATISTICS_LOG_LEVEL, cpd.getStatisticsLogLevel(), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.VERBOSE, String.valueOf(cpd.isVerbose()), STANDARD_PROPERTY);
        printDefinitionEntry(out, ProxoolConstants.TRACE, String.valueOf(cpd.isTrace()), STANDARD_PROPERTY);
        
// Now all the properties that are forwarded to the delegate driver.
        Properties p = cpd.getDelegateProperties();
        Iterator i 
= p.keySet().iterator();
        
while (i.hasNext()) {
            String name 
= (String) i.next();
            String value 
= p.getProperty(name);
            
// Better hide the password!
            if (name.toLowerCase().indexOf("password"> -1 || name.toLowerCase().indexOf("passwd"> -1{
                value 
= "******";
            }

            printDefinitionEntry(out, name 
+ " (delegated)", value, DELEGATED_PROPERTY);
        }


        closeTable(out);

    }


    
/**
     * Output a {
@link SnapshotIF snapshot} of the pool.
     * 
@param out where to write the HTML
     * 
@param cpd defines the pool
     * 
@param link the URL back to this servlet
     * 
@param level either {@link #DETAIL_LESS} or {@link #DETAIL_MORE}
     * 
@param connectionId the connection we want to drill into (optional)
     
*/

    
private void doSnapshot(PrintWriter out, ConnectionPoolDefinitionIF cpd, String link, String level, String connectionId) throws IOException, ProxoolException {
        
boolean detail = (level != null && level.equals(DETAIL_MORE));
        SnapshotIF snapshot 
= ProxoolFacade.getSnapshot(cpd.getAlias(), detail);

        
if (snapshot != null{

            openDataTable(out);

            printDefinitionEntry(out, ProxoolConstants.ALIAS, cpd.getAlias(), CORE_PROPERTY);

            
// dateStarted
            printDefinitionEntry(out, "Start date", DATE_FORMAT.format(snapshot.getDateStarted()), SNAPSHOT);

            
// snapshot date
            printDefinitionEntry(out, "Snapshot", TIME_FORMAT.format(snapshot.getSnapshotDate()), SNAPSHOT);

            
// connections
            StringBuffer connectionsBuffer = new StringBuffer();
            connectionsBuffer.append(snapshot.getActiveConnectionCount());
            connectionsBuffer.append(
" (active), ");
            connectionsBuffer.append(snapshot.getAvailableConnectionCount());
            connectionsBuffer.append(
" (available), ");
            
if (snapshot.getOfflineConnectionCount() > 0{
                connectionsBuffer.append(snapshot.getOfflineConnectionCount());
                connectionsBuffer.append(
" (offline), ");
            }

            connectionsBuffer.append(snapshot.getMaximumConnectionCount());
            connectionsBuffer.append(
" (max)<br/>");
            String[] colours 
= {"ff9999""66cc66""cccccc"};
            
int[] lengths = {snapshot.getActiveConnectionCount(), snapshot.getAvailableConnectionCount(),
                    snapshot.getMaximumConnectionCount() 
- snapshot.getActiveConnectionCount() - snapshot.getAvailableConnectionCount()}
;
            drawBarChart(connectionsBuffer, colours, lengths);
            printDefinitionEntry(out, 
"Connections", connectionsBuffer.toString(), SNAPSHOT);

            
// servedCount
            printDefinitionEntry(out, "Served", String.valueOf(snapshot.getServedCount()), SNAPSHOT);

            
// refusedCount
            printDefinitionEntry(out, "Refused", String.valueOf(snapshot.getRefusedCount()), SNAPSHOT);

            
if (!detail) {
                out.println(
"    <tr>");
                out.print(
"        <td colspan="2" align="right"><form action="" + link + "" method="GET">");
                out.print(
"<input type="hidden" name="" + ALIAS + "" value="" + cpd.getAlias() + "">");
                out.print(
"<input type="hidden" name="" + TAB + "" value="" + TAB_SNAPSHOT + "">");
                out.print(
"<input type="hidden" name="" + DETAIL + "" value="" + DETAIL_MORE + "">");
                out.print(
"<input type="submit" value="More information&gt;">");
                out.println(
"</form></td>");
                out.println(
"    </tr>");
            }
 else {

                out.println(
"    <tr>");
                out.print(
"      <th width="200" valign="top">");
                out.print(
"Details:<br>(click ID to drill down)");
                out.println(
"</th>");
                out.print(
"      <td>");

                doSnapshotDetails(out, cpd, snapshot, link, connectionId);

                out.println(
"</td>");
                out.println(
"    </tr>");

                
long drillDownConnectionId;
                
if (connectionId != null{
                    drillDownConnectionId 
= Long.valueOf(connectionId).longValue();
                    ConnectionInfoIF drillDownConnection 
= snapshot.getConnectionInfo(drillDownConnectionId);
                    
if (drillDownConnection != null{
                        out.println(
"    <tr>");
                        out.print(
"      <th valign="top">");
                        out.print(
"Connection #" + connectionId);
                        out.println(
"</td>");
                        out.print(
"      <td>");

                        doDrillDownConnection(out, drillDownConnection);

                        out.println(
"</td>");
                        out.println(
"    </tr>");
                    }

                }


                out.println(
"    <tr>");
                out.print(
"        <td colspan="2" align="right"><form action="" + link + "" method="GET">");
                out.print(
"<input type="hidden" name="" + ALIAS + "" value="" + cpd.getAlias() + "">");
                out.print(
"<input type="hidden" name="" + TAB + "" value="" + TAB_SNAPSHOT + "">");
                out.print(
"<input type="hidden" name="" + DETAIL + "" value="" + DETAIL_LESS + "">");
                out.print(
"<input type="submit" value="&lt; Less information">");
                out.println(
"</form></td>");
                out.println(
"    </tr>");
            }


            closeTable(out);
        }

    }


    
/**
     * If we want a {
@link #DETAIL_MORE more} detailed {@link SnapshotIF snapshot} then {@link #doSnapshot(javax.servlet.PrintWriter, org.logicalcobwebs.proxool.ConnectionPoolDefinitionIF, String, String, String)}
     * calls this too
     * 
@param out where to write the HTML
     * 
@param cpd defines the pool
     * 
@param snapshot snapshot
     * 
@param link the URL back to this servlet
     * 
@param connectionId the connection we want to drill into (optional)
     * 
@param connectionId
     * 
@throws IOException
     
*/

    
private void doSnapshotDetails(PrintWriter out, ConnectionPoolDefinitionIF cpd, SnapshotIF snapshot, String link, String connectionId) throws IOException {

        
long drillDownConnectionId = 0;
        
if (connectionId != null{
            drillDownConnectionId 
= Long.valueOf(connectionId).longValue();
        }


        
if (snapshot.getConnectionInfos() != null && snapshot.getConnectionInfos().length > 0{
            out.println(
"<table cellpadding="2" cellspacing="0" border="0">");
            out.println(
"  <tbody>");

            out.print(
"<tr>");
            out.print(
"<td>#</td>");
            out.print(
"<td align="center">born</td>");
            out.print(
"<td align="center">last<br>start</td>");
            out.print(
"<td align="center">lap<br>(ms)</td>");
            out.print(
"<td>&nbsp;thread</td>");
            out.print(
"</tr>");

            ConnectionInfoIF[] connectionInfos 
= snapshot.getConnectionInfos();
            
for (int i = 0; i < connectionInfos.length; i++{
                ConnectionInfoIF connectionInfo 
= connectionInfos[i];

                
if (connectionInfo.getStatus() != ConnectionInfoIF.STATUS_NULL) {

                    out.print(
"<tr>");

                    
// drillDownConnectionId
                    out.print("<td style="background-color: #");
                    
if (connectionInfo.getStatus() == ConnectionInfoIF.STATUS_ACTIVE) {
                        out.print(
"ffcccc");
                    }
 else if (connectionInfo.getStatus() == ConnectionInfoIF.STATUS_AVAILABLE) {
                        out.print(
"ccffcc");
                    }
 else if (connectionInfo.getStatus() == ConnectionInfoIF.STATUS_OFFLINE) {
                        out.print(
"ccccff");
                    }

                    out.print(
"" style="");

                    
if (drillDownConnectionId == connectionInfo.getId()) {
                        out.print(
"border: 1px solid black;");
                        out.print(
"">");
                        out.print(connectionInfo.getId());
                    }
 else {
                        out.print(
"border: 1px solid transparent;");
                        out.print(
""><a href="");
                        out.print(link);
                        out.print(
"?");
                        out.print(ALIAS);
                        out.print(
"=");
                        out.print(cpd.getAlias());
                        out.print(
"&");
                        out.print(TAB);
                        out.print(
"=");
                        out.print(TAB_SNAPSHOT);
                        out.print(
"&");
                        out.print(DETAIL);
                        out.print(
"=");
                        out.print(DETAIL_MORE);
                        out.print(
"&");
                        out.print(CONNECTION_ID);
                        out.print(
"=");
                        out.print(connectionInfo.getId());
                        out.print(
"">");
                        out.print(connectionInfo.getId());
                        out.print(
"</a>");
                    }

                    out.print(
"</td>");

                    
// birth
                    out.print("<td>&nbsp;");
                    out.print(TIME_FORMAT.format(connectionInfo.getBirthDate()));
                    out.print(
"</td>");

                    
// started
                    out.print("<td>&nbsp;");
                    out.print(connectionInfo.getTimeLastStartActive() 
> 0 ? TIME_FORMAT.format(new Date(connectionInfo.getTimeLastStartActive())) : "-");
                    out.print(
"</td>");

                    
// active
                    out.print("<td align="right" class="");
                    out.print(getStatusClass(connectionInfo));
                    out.print(
"">");
                    String active 
= "&nbsp;";
                    
if (connectionInfo.getTimeLastStopActive() > 0{
                        active 
= String.valueOf((int) (connectionInfo.getTimeLastStopActive() - connectionInfo.getTimeLastStartActive()));
                    }
 else if (connectionInfo.getTimeLastStartActive() > 0{
                        active 
= String.valueOf((int) (snapshot.getSnapshotDate().getTime() - connectionInfo.getTimeLastStartActive()));
                    }

                    out.print(active);
                    out.print(
"&nbsp;&nbsp;</td>");

                    
// requester
                    out.print("<td>&nbsp;");
                    out.print(connectionInfo.getRequester() 
!= null ? connectionInfo.getRequester() : "-");
                    out.print(
"</td>");

                    out.println(
"</tr>");
                }

            }

            out.println(
"  </tbody>");
            out.println(
"</table>");

        }
 else {
            out.println(
"No connections yet");
        }

    }


    
/**
     * What CSS class to use for a particular connection.
     * 
@param info so we know the {@link org.logicalcobwebs.proxool.ConnectionInfoIF#getStatus()} status
     * 
@return the CSS class
     * 
@see #STATUS_CLASSES
     
*/

    
private static String getStatusClass(ConnectionInfoIF info) {
        
try {
            
return STATUS_CLASSES[info.getStatus()];
        }
 catch (ArrayIndexOutOfBoundsException e) {
            LOG.warn(
"Unknown status: " + info.getStatus());
            
return "unknown-" + info.getStatus();
        }

    }


    
private void doDrillDownConnection(PrintWriter out, ConnectionInfoIF drillDownConnection) throws IOException {

        
// sql calls
        String[] sqlCalls = drillDownConnection.getSqlCalls();
        
for (int i = 0; sqlCalls != null && i < sqlCalls.length; i++{
            String sqlCall 
= sqlCalls[i];
            out.print(
"<div class="drill-down">");
            out.print(
"sql = ");
            out.print(sqlCall);
            out.print(
"</div>");
        }


        
// proxy
        out.print("<div class="drill-down">");
        out.print(
"proxy = ");
        out.print(drillDownConnection.getProxyHashcode());
        out.print(
"</div>");

        
// delegate
        out.print("<div class="drill-down">");
        out.print(
"delegate = ");
        out.print(drillDownConnection.getDelegateHashcode());
        out.print(
"</div>");

        
// url
        String url= drillDownConnection.getDelegateUrl();
        String[] urls
=url.split("/?");    //Hide the user & password of url
        out.print("<div class="drill-down">");
        out.print(
"url = ");
        out.print(urls[
0]);
        out.print(
"</div>");

    }


    
private void openHtml(PrintWriter out) throws IOException {
        out.println(
"<html><header><title>Proxool Admin</title>");
        out.println(
"<style media="screen">");
        out.println(
"body {background-color: #93bde6;} " +
                
"div.version {font-weight: bold; font-size: 100%; margin-bottom: 8px;} " +
                
"h1 {font-weight: bold; font-size: 100%} " +
                
"option {padding: 2px 24px 2px 4px;} " +
                
"input {margin: 0px 0px 4px 12px;} " +
                
"table.data {font-size: 90%; border-collapse: collapse; border: 1px solid black;} " +
                
"table.data th {background: #bddeff; width: 25em; text-align: left; padding-right: 8px; font-weight: normal; border: 1px solid black;} " +
                
"table.data td {background: #ffffff; vertical-align: top; padding: 0px 2px 0px 2px; border: 1px solid black;} " +
                
"td.null {background: yellow;} " +
                
"td.available {color: black;} " +
                
"td.active {color: red;} " +
                
"td.offline {color: blue;} " +
                
"div.drill-down {} " +
                
"ul {list-style: none; padding: 0px; margin: 0px; position: relative; font-size: 90%;} " +
                
"li {padding: 0px; margin: 0px 4px 0px 0px; display: inline; border: 1px solid black; border-width: 1px 1px 0px 1px;} " +
                
"li.active {background: #bddeff;} " +
                
"li.inactive {background: #eeeeee;} " +
                
"li.disabled {background: #dddddd; color: #999999; padding: 0px 4px 0px 4px;} " +
                
"a.quiet {color: black; text-decoration: none; padding: 0px 4px 0px 4px; } " +
                
"a.quiet:hover {background: white;} ");
        out.println(
"</style>");
        
// If we have configured a cssFile then that will override what we have above
        if (cssFile != null{
            out.println(
"<link rel="stylesheet" media="screen" type="text/css" href="" + cssFile + ""></script>");
        }

        out.println(
"</header><body>");
    }


    
private void closeHtml(PrintWriter out) throws IOException {
        out.println(
"</body></html>");
    }


    
private void openDataTable(PrintWriter out) throws IOException {
        out.println(
"<table cellpadding="2" cellspacing="0" border="1" class="data">");
        out.println(
"  <tbody>");
    }


    
private void closeTable(PrintWriter out) throws IOException {
        out.println(
"  </tbody>");
        out.println(
"</table>");
        out.println(
"<br/>");
    }


    
private void printDefinitionEntry(PrintWriter out, String name, String value, String type) throws IOException {
        out.println(
"    <tr>");
        out.print(
"      <th valign="top">");
        out.print(name);
        out.println(
":</th>");
        out.print(
"      <td class="" + type + ""nowrap>");
        
if (value != null && !value.equals("null")) {
            out.print(value);
        }
 else {
            out.print(
"-");
        }

        out.print(
"</td>");
        out.println(
"    </tr>");
    }


    
/**
     * Output the list of available connection pools. If there are none then display a message saying that.
     * If there is only one then just display nothing (and the pool will displayed by default)
     * 
@param out where to write the HTML
     * 
@param alias identifies the current pool
     * 
@param tab identifies the tab we are on so that changing pools doesn't change the tab
     * 
@param link the URL back to this servlet
     
*/

    
private void doList(PrintWriter out, String alias, String tab, String link) throws IOException {

        String[] aliases 
= ProxoolFacade.getAliases();

        
if (aliases.length == 0{
            out.println(
"<p>No pools have been registered.</p>");
        }
 else if (aliases.length == 1{
            
// Don't bother listing. Just show it.
        }
 else {
            out.println(
"<form action="" + link + "" method="GET" name="alias">");
            out.println(
"<select name="alias" size="" + Math.min(aliases.length, 5+ "">");
            
for (int i = 0; i < aliases.length; i++{
                out.print(
"  <option value="");
                out.print(aliases[i]);
                out.print(
""");
                out.print(aliases[i].equals(alias) 
? " selected" : "");
                out.print(
">");
                out.print(aliases[i]);
                out.println(
"</option>");
            }

            out.println(
"</select>");
            out.println(
"<input name="" + TAB + "" value="" + tab + "" type="hidden">");
            out.println(
"<input value="Show" type="submit">");
            out.println(
"</form>");
        }

    }


    
/**
     * Express time in an easy to read HH:mm:ss format
     *
     * 
@param time in milliseconds
     * 
@return time (e.g. 180000 = 00:30:00)
     * 
@see #TIME_FORMAT
     
*/

    
private String formatMilliseconds(int time) {
        Calendar c 
= Calendar.getInstance();
        c.clear();
        c.add(Calendar.MILLISECOND, time);
        
return TIME_FORMAT.format(c.getTime());
    }

}


/*
Revision history:
$Log: ProxoolAdminServlet.java,v $
Revision 1.14  2006/06/09 17:32:54  billhorsman
Fix closing tag for select. Credit to Paolo Di Tommaso.

Revision 1.13  2006/01/18 14:39:56  billhorsman
Unbundled Jakarta's Commons Logging.

Revision 1.12  2005/10/07 08:23:10  billhorsman
Doc

Revision 1.11  2005/10/02 09:45:49  billhorsman
Layout

Revision 1.10  2005/09/26 21:47:46  billhorsman
no message

Revision 1.9  2005/09/26 13:31:14  billhorsman
Smartened up ProxoolAdminServlet

Revision 1.8  2003/09/29 17:49:19  billhorsman
Includes new fatal-sql-exception-wrapper-class in display

Revision 1.7  2003/08/06 20:08:58  billhorsman
fix timezone display of time (for millisecond based properties)

Revision 1.6  2003/03/10 23:43:14  billhorsman
reapplied checkstyle that i'd inadvertently let
IntelliJ change...

Revision 1.5  2003/03/10 15:26:51  billhorsman
refactoringn of concurrency stuff (and some import
optimisation)

Revision 1.4  2003/03/03 11:12:00  billhorsman
fixed licence

Revision 1.3  2003/02/26 16:59:18  billhorsman
fixed spelling error in method name

Revision 1.2  2003/02/26 16:51:12  billhorsman
fixed units for average active time. now displays
properly in seconds

Revision 1.1  2003/02/24 10:19:44  billhorsman
moved ProxoolAdminServlet into servlet package

Revision 1.1  2003/02/19 23:36:51  billhorsman
renamed monitor package to admin

Revision 1.10  2003/02/12 12:28:27  billhorsman
added url, proxyHashcode and delegateHashcode to
ConnectionInfoIF

Revision 1.9  2003/02/11 00:30:28  billhorsman
add version

Revision 1.8  2003/02/06 17:41:05  billhorsman
now uses imported logging

Revision 1.7  2003/02/06 15:42:21  billhorsman
display changes

Revision 1.6  2003/02/05 17:04:02  billhorsman
fixed date format

Revision 1.5  2003/02/05 15:06:16  billhorsman
removed dependency on JDK1.4 imaging.

Revision 1.4  2003/01/31 16:53:21  billhorsman
checkstyle

Revision 1.3  2003/01/31 16:38:52  billhorsman
doc (and removing public modifier for classes where possible)

Revision 1.2  2003/01/31 11:35:57  billhorsman
improvements to servlet (including connection details)

Revision 1.1  2003/01/31 00:38:22  billhorsman
*** empty log message ***

*/
0
1

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:15351次
    • 积分:171
    • 等级:
    • 排名:千里之外
    • 原创:0篇
    • 转载:16篇
    • 译文:0篇
    • 评论:1条
    文章分类
    最新评论