⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 resetconnpool.jsp

📁 jsp网站
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="com.sunny.currency.database.*,javax.servlet.*,javax.servlet.http.*,java.io.*,java.util.*,com.sunny.currency.*" %>
<%
Request m_request = new Request(request);
String strPoolName = m_request.GetString("PoolName");
if(strPoolName.trim().length()>0)
{
  if(ConnectionPool.Instance().CloseAllConn(strPoolName)>0)
  {
%>
<script language="JavaScript" type="text/JavaScript">
alert("“<%=strPoolName%>”连接池重置成功!");
window.location="<%=request.getRequestURI()%>";
</script>
<%
  }
  else
  {
%>
<script language="JavaScript" type="text/JavaScript">
alert("“<%=strPoolName%>”连接池不存在,重置失败!");
history.back();
</script>
<%
  }
}
else
{
%>
<html>
<head>
<title>数据库连接池监视修复器</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="pragma" content="no-cache">
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="REFRESH" content="1;URL=<%=request.getRequestURI()%>">
<script language="JavaScript">
  setTimeout("self.location.reload();",1000);
</script>
</head>
<body>
<%
    Hashtable pools = ConnectionPool.getConnPools();
    out.println("<p align=\"center\"><font size=\"32px\" color=\"#008800\">数据库连接池监视修复器</font></p><p>当前共有" + pools.size() + "个连接池被激活!</p>");
    for(int i=0;i<pools.size();i++)
    {
      DBConnectionPool connPool = (DBConnectionPool)pools.values().toArray()[i];
      out.println("<hr>");
      out.println("<p>连接池名称:" + connPool.Name + "</p>");
      out.println("<p>最大连接数:" + connPool.intMaxConn + "</p>");
      out.println("<p>当前连接总数:" + connPool.ConnCount + "</p>");
      out.println("<p>空闲连接数:" + connPool.FreeConn.size() + "</p>");
      out.println("<p>繁忙连接数:" + connPool.BusyConn.size() + "</p>");
      out.println("<p align='right'><a href='" + request.getRequestURI() + "?PoolName=" + connPool.Name + "'>重置“" + connPool.Name + "”连接池</a></p>");
    }
%>
</body>
<html>
<%
}
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -