<%@ page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.cscimport.*,java.util.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <META http-equiv="Content-Style-Type" content="text/css"> <TITLE>TEST.jsp</TITLE> <link href="CSS/MYNOTE.css" rel="stylesheet" type="text/css"> </HEAD> <BODY> <% //Runtime.getRuntime().gc(); //System.runFinalization(); HashMap conMap=StaticProperties.connectionMap; Iterator it=conMap.keySet().iterator(); String database =""; ConnectionPools pools=null; Vector em =null; CscConnection con=null; CscCalendar cs=null; %> <form name="cscform" > <br> <br> <a href="./clear.jsp">Clear (clear Item ที่ทำงานนานเกิน 1,800,000 ms.[ประมาณ 30 นาที])</a> <br> <br> <table width="90%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#000000"> <tr> <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#000000"> <tr> <td width="88" class="title1"><div align="center">No</div></td> <td width="90" class="title1"><div align="center">DataBase</div></td> <td width="150" class="title1"><div align="center">Connection</div></td> <td width="146" class="title1"><div align="center">IsUsed</div></td> <td width="273" class="title1"><div align="center">Starttime</div></td> <td class="title1"><div align="center">IsClosed</div></td> </tr> <% int runno=0; while(it.hasNext()){ database =(String)it.next(); pools=(ConnectionPools)conMap.get(database); em = pools.getConnectionsused(); for (int i=0;i<em.size();i++) { con = (CscConnection) em.get(i); runno++; %> <tr> <td align="right" bgcolor="#FFFFFF"><%=runno%> </td> <td bgcolor="#FFFFFF" class="desc2"><%=database%></td> <td nowrap bgcolor="#FFFFFF"><%=con%></td> <td bgcolor="#FFFFFF"><%=con.isUses()%></td> <td bgcolor="#FFFFFF" nowrap><%=new CscCalendar(con.getStarttime()).getYYYYMMDDHHMMSS()%></td> <td bgcolor="#FFFFFF"><%=con.isClosed()%>[<%=con.getCscTransaction()%>][prepare= <% Vector vc1=con.getPrepare(); for(int s=0;s<vc1.size();s++){ CscPreparedStatement pre=(CscPreparedStatement)vc1.get(s); out.println(pre+"="+pre.isClose()+"<br>"); } %> ][stm= <% vc1=con.getStm(); for(int s=0;s<vc1.size();s++){ CscStatement pre=(CscStatement)vc1.get(s); out.println(pre+"="+pre.isClose()+"<br>"); } %> ]</td> </tr> <% } em = pools.getConnectionsnoused(); for (int i=0;i<em.size();i++) { con = (CscConnection) em.get(i); runno++; %> <tr> <td align="right" bgcolor="#FFFFFF"><%=runno%> </td> <td bgcolor="#FFFFFF"><%=database%></td> <td nowrap bgcolor="#FFFFFF"><%=con%></td> <td bgcolor="#FFFFFF"><%=con.isUses()%></td> <td bgcolor="#FFFFFF"><%=new CscCalendar(con.getStarttime()).getYYYYMMDDHHMMSS()%></td> <td bgcolor="#FFFFFF"><%=con.isClosed()%>[<%=con.getCscTransaction()%>][prepare= <% Vector vc1=con.getPrepare(); for(int s=0;s<vc1.size();s++){ CscPreparedStatement pre=(CscPreparedStatement)vc1.get(s); out.println(pre+"="+pre.isClose()+"<br>"); } %> ][stm= <% vc1=con.getStm(); for(int s=0;s<vc1.size();s++){ CscStatement pre=(CscStatement)vc1.get(s); out.println(pre+"="+pre.isClose()+"<br>"); } %> ]</td> </tr> <% } } %> </table></td> </tr> </table> </form> </BODY> </HTML>