fipone.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>
 <jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
 // String admin=request.getParameter("id");

String sql="Select Sum(TOneNum) From FIpone where admin='"+admin+"'";
Connection con = feng.getConn() ;
Statement stmt=con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
int AllCount=0;

while (rs.next())
{
 AllCount=rs.getInt(1);
};
%>
<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;访问者IP首段分析(总量：<%=AllCount%>)</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>
<%
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="Select * From FIpone where admin='"+admin+"' Order By TOneNum DESC";
rs = stmt.executeQuery(sql) ;
while (rs.next())
{
String TArea=rs.getString(1);
int   Count=rs.getInt(2);

float aPercent=(float)(Count)/AllCount*100;
int   Percent=(int)(aPercent);
int PicLong=2*Percent;
%>
               <tr>
                           
                 <td height="20" align="center" class="small" nowrap><%=TArea%></td>
                 <td height="20" width="1" bgcolor="#F7EF72"></td>
                 <td height="20" align="center" class="small" nowrap><%=Count%></td>
                 <td height="20" width="1" bgcolor="#F7EF72" nowrap></td>
                 <td height="20" align="center" nowrap><%=Percent%></td>
                 <td height="20" width="1" bgcolor="#F7EF72"></td>
                           <td height="20" align="center" class="small" nowrap><img src="Image/Bar.gif" width="<%=PicLong%> "height="12"></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>
<!--  最后10分钟最后10位访客详情 表格结束  -->

                                  
                                  <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>