+++ /dev/null
-<!-- $Id: stats.jsp,v 1.11 2005/05/27 20:30:25 yuk Exp $ -->\r
-<!doctype html public "-//w3c//dtd html 4.0 transitional//en"\r
- "http://www.w3.org/tr/rec-html40/loose.dtd">\r
-<%@ page contentType="text/html; charset=UTF-8" %>\r
-\r
-<%@ page import="java.util.*" %>\r
-<%@ page import="java.text.*" %>\r
-<%-- <%@ page import="com.lavans.util.*" %> --%>\r
-<%@ page import="com.lavans.luz2.sql.stats.*" %>\r
-<%!\r
- private static String METHOD_EXCLUDE_PACKAGE="com.lavans.util";\r
-\r
- private static String COMMAND ="cmd";\r
- private static String C_LIST ="list";\r
-\r
- private static String SORT ="sort";\r
- private static String SORT_TOTAL="total";\r
- private static String SORT_AVERAGE="ave";\r
-\r
-%>\r
-<%\r
- Statistics stat = Statistics.getInstance();\r
-\r
- // 繧ス繝シ繝�
- String sort = request.getParameter(SORT);\r
- if(sort==null) sort=SORT_AVERAGE;\r
-\r
- // 繧ウ繝槭Φ繝�
- String command = request.getParameter(COMMAND);\r
- if(command==null) command=C_LIST;\r
-\r
- NumberFormat nf = NumberFormat.getInstance();\r
- DecimalFormat df = new DecimalFormat("#,###.00");\r
-%>\r
-<html lang="ja">\r
-<head>\r
-<title>邨ア險域ュ蝣ア</title>\r
-<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r
-<style type="text/css">\r
- body{\r
- color: #000000;\r
- background-color: #fffafa;\r
- font-size: 12px;\r
- }\r
-\r
-a:link {\r
- text-decoration: none;\r
-}\r
-\r
-a:visited {\r
- text-decoration: none;\r
-}\r
-\r
-a:hover {\r
- color: #FFFFFF;\r
- background-color: #000066;\r
-}\r
-\r
- .txt{\r
- font-size: 12px;\r
- }\r
-\r
- div.center{\r
- text-align: center\r
- }\r
-\r
- tr.title{\r
- color: #ffffff;\r
- background-color: #000066;\r
- font-size: 14px;\r
- font-weight: bold;\r
- text-align: middle;\r
- }\r
-\r
- td.sql{\r
- color: #000066;\r
- background-color: #f5f9ff;\r
- font-size: 12px;\r
- }\r
-\r
- td.method{\r
- color: #991000;\r
- background-color: #FDFDFF;\r
- font-size: 12px;\r
- }\r
- .hilight{\r
- color: #FF0000;\r
- }\r
-\r
- .white{\r
- color: #ffffff;\r
- }\r
- .gray{\r
- color: #999999;\r
- }\r
-</style>\r
-<script language="javascript">\r
-function openSQL(sql){\r
- w = window.open("","_new","width=500,height=300,scrollbars=yes,resizable=yes,status=no,menbar=no");\r
- w.document.open("text/html","replace");\r
- w.document.write("<font face=\"�ュ�ウ 繧エ繧キ繝�け\">");\r
- w.document.write(sql);\r
- w.document.write("</font>");\r
- w.document.close();\r
- w.focus();\r
- }\r
-</script>\r
-</head>\r
-<body>\r
-\r
-<table border=1 cellspacing=0 cellpadding=3 width="100%">\r
-<tr class="title">\r
- <th>蜻シ蜃コ蜈�/th>\r
- <th rowspan="2" width="30">螳溯。�br>蝗樊焚</th>\r
-<%\r
- if(sort.equals(SORT_TOTAL)){\r
-%>\r
- <th rowspan="2">邱丞ョ溯。梧凾髢�br>(msec)<font class="gray">笆シ</font></th>\r
- <th rowspan="2">蟷ウ蝮�ョ溯。梧凾髢�br>(msec)<a href="stats.jsp?<%= SORT +"="+ SORT_AVERAGE %>" class="white">笆シ</a></th>\r
-<%\r
- }else{\r
-%>\r
- <th rowspan="2">邱丞ョ溯。梧凾髢�br>(msec)<a href="stats.jsp?<%= SORT +"="+ SORT_TOTAL %>" class="white">笆シ</a></th>\r
- <th rowspan="2">蟷ウ蝮�ョ溯。梧凾髢�br>(msec)<font class="gray">笆シ</font></th>\r
-<%\r
- }\r
-%>\r
-\r
-</tr>\r
-<tr class="title">\r
- <th>SQL</th>\r
-</tr>\r
-<%\r
- List list = null;\r
- if(sort.equals(SORT_TOTAL)){\r
- list = stat.getStatInfoByTotal();\r
- }else{\r
- list = stat.getStatInfoByAverage();\r
- }\r
- for(int i=0; i<list.size(); i++){\r
- StatsRecord rec = (StatsRecord)list.get(i);\r
- // 蜻シ蜃コ蜈�ク�ヲァ\r
- StringBuffer buf = new StringBuffer();\r
- Object methods[] = rec.getMethodNames().toArray();\r
- for(int j=0; j<methods.length; j++){\r
- buf.append(methods[j] + "<br>");\r
- }\r
-%>\r
-<tr>\r
-<!-- <td class='method'><%= buf.substring(METHOD_EXCLUDE_PACKAGE.length()) %></td>\r
--->\r
- <td class='method'><%= buf.toString() %></td>\r
- <td rowspan="2" align="right"><%= nf.format(rec.getCallCount()) %></td>\r
- <td rowspan="2" align="right"><%= nf.format(rec.getTotalCostTime()) %></td>\r
- <td rowspan="2" align="right"><%= df.format(rec.getAverage()) %></td>\r
-</tr>\r
-<tr>\r
- <td class='sql'>\r
-<%\r
- if(rec.getSql().length()<200){\r
- out.print(rec.getSql());\r
- }else{\r
-%>\r
-<script> var sql<%= i %>="<%= rec.getSql().replaceAll("\n","<br>").replaceAll(" "," ") %>"; </script>\r
- <%= rec.getSql().substring(0,200) %><a href="javascript:openSQL(sql<%= i %>)">.....</a>\r
-<%\r
- }\r
-%>\r
-</td>\r
-</tr>\r
-<%\r
- }\r
-%>\r
-</table>\r
-<%= Statistics.getInstance().viewConnectionPool() %>\r
-<%\r
-/*\r
- Enumeration e = DriverManager.getDrivers();\r
- while(e.hasMoreElements()){\r
- Driver drivera = (Driver)e.nextElement();\r
- %><%= drivera.toString() %><br>\n<%\r
- }\r
-*/\r
-%>\r
-</body>\r
-</html>
\ No newline at end of file