stat.jsp

【首语】 非常感谢你能够对季风流量统计系统感兴趣。不管你是JAVA的初学者、还是JAVA的高手

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者：季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:[e-mail]                             
     网站:http://www.hxwa.net       
*/	 
String id=request.getParameter("id");
String Ip=request.getRemoteAddr();
String admin=id;
Connection con = feng.getConn() ;
Statement stmt=con.createStatement();
Statement stmt2=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs =null;

int ExTime=5;
String sql="delete from temps where datediff('n',logtime,now())>="+ExTime+" and admin='"+admin+"'";
stmt.executeUpdate(sql) ;

 sql="update InfoList set cnetNum=cnetNum+1 where admin='"+admin+"'";
stmt.executeUpdate(sql);

sql="select * from temps where datediff('n',logtime,now())<"+ExTime+" and admin='"+admin+"'and ipre='"+Ip+"'";
rs=stmt2.executeQuery(sql) ;
rs.last();
int ok=0;
if (rs.getRow()>0){

 sql="update temps set logtime=now() where datediff('n',logtime,now())<"+ExTime+" and admin='"+admin+"'and ipre='"+Ip+"'";
 stmt.executeUpdate(sql);
 ok=0;
} 
else{
sql="insert into temps(admin,ipre) values('"+admin+"','"+Ip+"')" ; 
stmt.executeUpdate(sql) ;
sql="update InfoList set TotalNum=TotalNum+1 where admin='"+admin+"'";
stmt.executeUpdate(sql);
ok=1;

%>
<script language="JavaScript">
document.write ('<a target=blank href="ph.jsp" >');
document.write("<img src='count.jsp?id=<%=id%>&ok=<%=ok%>&Referer="+escape(top.document.referrer)+"&curURL="+escape(top.document.URL)+"&Width="+escape(screen.width)+"&Height="+escape(screen.height)+"' border=0 width=20 height=17 alt='季风统计' style='display:none' >");
document.write("</a>");

</script>

<%}

 sql="Select * From infolist where admin='"+admin+"'";
 rs = stmt2.executeQuery(sql) ;

String  TotalNum="0";
String cnetNum="0";
if (rs.next()){
 TotalNum=rs.getString("TotalNum");
  cnetNum=rs.getString("cnetNum");
}
 sql="Select count(*) From temps where admin='"+admin+"'";
rs = stmt2.executeQuery(sql);
String onlineNum="0";
if (rs.next()){
 onlineNum=rs.getString(1);
}		   
		 try {
              rs.close();
              stmt.close();
			  stmt2.close();
              con.close();
            }
            catch (Exception ex) {
            }
%>
<script language="JavaScript">
document.write ('<table border=0 cellpadding=3 cellspacing=1 width=92 height=1 style=\"font-size: 9pt;display:inline\" bgcolor=#000000 >');
document.write ("<tr><td><a onclick=jscript:window.location='info.jsp?id=<%=id%>' ><marquee style='cursor:hand;color:#ffffff' width=92 height=12 align=middle scrollamount=3>当前在线:<%=onlineNum%>人...... ");
document.write ("总计访问:<%=TotalNum%>次......总计页面访问:<%=cnetNum%>次......◇湖湘网安统计◇</marquee></a></td></tr></table>");
</script>