<%@ 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;
%>
<form name="cscform" >
<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">Inittime</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);
try{
long now = System.currentTimeMillis();
long timein = con.getStarttime();
long timeOver = 1800000l;
out.println(((now - timein) > timeOver)+" "+con+"<br>");
if ((now - timein) > timeOver) {
out.println(con+"==Clear<br>");
con.rollbackCscTransaction();
con.setCscTransaction(null);
con.close();
}
}catch(Exception ex){}
}
em = pools.getConnectionsnoused();
for (int i=0;i<em.size();i++) {
con = (CscConnection) em.get(i);
try{
long now = System.currentTimeMillis();
long timein = con.getStarttime();
long timeOver = 1800000l;
if ((now - timein) > timeOver) {
con.rollbackCscTransaction();
con.setCscTransaction(null);
con.close();
}
}catch(Exception ex){}
}
}
response.sendRedirect("./CONNECTIONLIST.jsp");
%>
</table></td>
</tr>
</table>
</form>
</BODY>
</HTML>