📄 showsql.jsp
字号:
<html>
<head>
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="epod.collections.*,epod.system.cache.*" %>
<%@ page import="epod.app.module.helper.*"%>
<%@ page import="epod.framework.*,epod.framework.constant.*"%>
<%
if( session.getAttribute(epod.framework.constant.SessionKey.USER) == null ) {
out.write(epod.util.HtmlUtil.getMsgHtml("会话超时，请重新登录。", "/", "parent"));
return;
}
EpodContext context = new EpodContext(request,this.getServletConfig());
%>
<title>本页使用SQL</title>
<link rel="stylesheet" type="text/css" href="<%=context.getContextPath()%>/epod/skins/m_default/lib/style.css">
<SCRIPT LANGUAGE="JavaScript" src="<%=context.getContextPath()%>/epod/page/lib/common.js"></SCRIPT>
</head>
<body >
<center class=view_title>系统SQL监控</center>
<% try{ %>
<table width=100% cellspacing=0 cellpadding=1 border=0>
<tr><td>
<table border=0 cellspacing=0 cellpadding=1 width=100% class="unit_title_table">
<tr><td class="unit_title_left"></td><td class="unit_title_right"><input type="button" name="refresh" value="刷新" class="button" onclick="window.location=window.location"></td></tr></table>
<tr><td>
<table width="100%" onclick=onPin() onMouseOut='offMouse();' onMouseOver='onMouse();' class=unit_table border=0 cellspacing=1 cellpadding=1 id="_user_list_list">
<tr id="_g_0">
<TD class="cell_title" width=5%>序号</TD>
<TD class="cell_title" width=5%>时间</TD>
<TD class="cell_title" width=90%>SQL</TD>
</TR>
<%
if( ConstantCache.getInstance().getConstantInt("_userSQL_LogMode") == SQLLogMode.LOG) {
HashList userSQLList = (HashList)session.getAttribute(SessionKey.USR_SQL_LOG);
for( int ii = 0 ; ii < userSQLList.size() ; ii++ ) {
%>
<tr id="_g_<%= ii+1%>">
<TD class="cell_center"><%= ii+1%></TD>
<TD class="cell_right"><%= userSQLList.get(ii , "cost")%></TD>
<TD class="cell_left"><%= userSQLList.get(ii , "sql")%></TD>
</TR>
<%}%>
</TABLE>
</TABLE>
<%} else {%>
没有打开SQL日志开关。请在系统常量中进行调整。
<%}%>
<%
} catch (Exception ex) {
ex.printStackTrace();
}
%>
<TABLE border=0 width="100%" cellspacing=0>
<TR>
<TD colspan=2><HR></TD>
</TR>
<TR bgcolor="#E8E8E8">
<TD align=center style="font-size=10pt">Copyright © 2005 Thunis, All Rights Reserved</TD>
<TD align=center style="font-size=10pt" width="10%"></TD>
</TR>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -