<%@ 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%>&nbsp;</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%>&nbsp;</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>