ol.jsp

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

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>

<%  String admin=request.getParameter("id");

  if (session.getValue("UserName")==null){
    response.sendRedirect("login.jsp");  
}
else {
	
    if (session.getValue("admin")==null){
       if (session.getValue("UserName").equals(admin))
       {
      
       }else
        response.sendRedirect("err.jsp?id=3");
	   }
    }
%>
<jsp:include page="left.jsp" flush="true"/>

                        </TBODY>
                      </TABLE>
                    </TD>
                  </TR>
                  <TR> 
                    <TD height=10 vAlign=top width=150><IMG height=10 src="images/menu3.jpg" width=150></TD>
                  </TR>
                  <TR> 
                    <TD background="images/menu4.jpg" height=80 width=150>&nbsp;</TD>
                  </TR>
                  <TR> 
                    <TD height=14 vAlign=top width=150><IMG height=14 src="images/menu5.jpg" width=150></TD>
                  </TR>
                  </TBODY>
                </TABLE>
              </TD>
              <TD align=middle vAlign=top width=588><BR>
                <TABLE border=0 cellPadding=0 cellSpacing=0>
                  <TBODY> 
                  <TR> 
                    <TD colSpan=2 rowSpan=2 vAlign=top> 
                      <TABLE bgColor=#000000 border=0 cellPadding=0 cellSpacing=0 width=488">
                        <TBODY> 
                        <TR> 
                          <TD bgColor=#ffffff vAlign=top> 
                            <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
                              <TBODY> 
                              <TR> 
                                
<br>

<table width="460" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td background="images/graph_border1.gif" height="25" valign="top">
      <b style="font-family: 宋体;line-height: 21px">&nbsp;&nbsp;最新30位当前在线访问者</b>
    </td>
  </tr>
  <tr>

    <td background="images/graph_border2.gif">
      <table width="460" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="11">&nbsp;</td>
          <td background="images/tablebg.gif" align="center"> 
            <table width="98%" border="0" cellspacing="0" cellpadding="0">
               <tr>
                 <td height="20" align="center" nowrap>&nbsp;来访IP&nbsp;</td>
                 <td height="20" width="1"></td>
                 <td height="20" align="center" nowrap>&nbsp;&nbsp;&nbsp;活动时间&nbsp;&nbsp;&nbsp;</td>
                 <td height="20" width="1"></td>
                 <td height="20" align="center" nowrap>&nbsp;操作系统&nbsp;</td>
                 <td height="20" width="1"></td>
                 <td height="20" align="center" nowrap>&nbsp;&nbsp;来访页面&nbsp;&nbsp;</td>
                 <td height="20" width="1"></td>
               </tr>
 <jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
//  String admin=request.getParameter("id");

String sql="select Top 30 temps.id,logtime,ipre,System,Referer from Visitor left join temps on temps.ipre=Visitor.Ip and temps.admin=Visitor.admin where datediff('n',logtime,now())<10 and temps.admin='"+admin+"' Order By temps.id DESC";
Connection con = feng.getConn() ;
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())
{
String logtime=rs.getString("logtime");
String Ip=rs.getString("ipre");
String FSystem=rs.getString("System");
String Referer=rs.getString("Referer");
%>
               <tr>
                           
                 <td height="20" align="center" class="small" nowrap><%=Ip%>

            </td>
                 <td height="20" width="1" bgcolor="#F7EF72"></td>
                 <td height="20" align="center" class="small" nowrap><%=logtime%></td>
                 <td height="20" width="1" bgcolor="#F7EF72" nowrap></td>
                 <td height="20" align="center" nowrap><%=FSystem%></td>
                 <td height="20" width="1" bgcolor="#F7EF72"></td>
                   <td height="20" align="center" class="small" nowrap><%=Referer%>          
          </td>          
               </tr>
<%
    };
		 try {
              rs.close();
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }

%>  
               <tr>
               </tr>
            </table>
          </td>
          <td width="5"></td>
          <td width="11" background="images/graph_border5.gif">&nbsp;</td>
          <td width="9"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td background="images/graph_border4.gif" height="10"></td>
  </tr>
</table>


                                  
                                  <BR>
                                  <BR>
                                </TD>
                              </TR>
                              </TBODY>
                            </TABLE>
                          </TD>
                        </TR>
                        </TBODY>
                      </TABLE>
                    </TD>
                    <TD bgColor=#394a5a height=9 vAlign=top width=10><IMG height=9 src="./images/cooltable_rt.gif" width=10></TD>
                  </TR>
                  <TR>
                    <TD bgColor=#394a5a width=10></TD>
                  </TR>
                  <TR> 
                    <TD bgColor=#8c949c height=10 vAlign=top width=11><IMG height=10 src="./images/cooltable_lb.gif" width=11></TD>
                    <TD bgColor=#8c949c height=10></TD>
                    <TD height=10 vAlign=top width=10><IMG height=10 src="./images/cooltable_rb.gif" width=10></TD>
                  </TR>
                  </TBODY>
                </TABLE>
              </TD>
            </TR>
            </TBODY>
          </TABLE>
        </TD>
      </TR>
      <TR> 
        <TD> 
          <div align="center"></div>
        </TD>
      </TR>
      <TR>
        <TD bgcolor=#CCCCCC>
          <div align="center">copy right by www.hxwa.net 湖湘网安版权所有</div>
        </TD>
      </TR>
      </TBODY>
    </TABLE>
    <BR></BODY></HTML>
<center></center>