?? view.jsp.bak
字號:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*,Db_sql"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%
String strSql;
Db_sql db = null;
Hashtable countresult = new Hashtable();
String typename = "";
String username = "";
String email = "";
String webname = "";
String url = "";
String sTemp = "";
int iCount = 0;
int perdayhits = 0;
int pdayhits = 0;
int iTemp = 0;
int torder = 0;
int order = 0;
//int iUid = 0;
String iUid = "";
Date dTemp = null;
Hashtable[] client = new Hashtable[25];
try {
iUid = request.getParameter("uid");
db = new Db_sql("10.1.1.202","1521","oracle8","home4u","home4u");
// db = new Db_sql("202.84.10.191","7137","appdb","liu","liujie8");
strSql = " update stat set avghits=round(totalhits/(round(SYSDATE-starttime)+1)) ";
db.query(strSql);
strSql = " select id,puid,starttime,totalhits,sitetype,maxhits,todayhits, ";
strSql += " round(SYSDATE-starttime)+1 as days, avghits from stat ";
strSql += " where puid= '" + iUid + "'";
db.query(strSql);
if (db.next())
{
countresult.put("id",new Integer(db.getInt("id")));
countresult.put("puid",db.getString("puid"));
countresult.put("starttime",db.getDate("starttime"));
countresult.put("totalhits",new Integer(db.getInt("totalhits")));
countresult.put("sitetype",db.getString("sitetype"));
countresult.put("todayhits",new Integer(db.getInt("todayhits")));
countresult.put("maxhits",new Integer(db.getInt("maxhits")));
countresult.put("avghits",new Integer(db.getInt("avghits")));
countresult.put("days",new Integer(db.getInt("days")));
//-------------取得站點類型-------------------------
typename = (String)countresult.get("sitetype");
//------------計算平均每天瀏覽量----------------------
iTemp = ((Integer)countresult.get("days")).intValue();
if (iTemp != 0)
perdayhits = ((Integer)countresult.get("totalhits")).intValue()/iTemp;
else
perdayhits = ((Integer)countresult.get("todayhits")).intValue();
//-----------得到用戶的郵件和名字 站名 url----------------------
strSql = " select username,email,title ";
strSql += " from userinfo where username= '" + iUid + "'";
db.query(strSql);
if (db.next())
{
username = db.getString("username");
email = db.getString("email");
webname = db.getString("title");
url = "http://" + iUid + ".at.china.com";
}
//-----------計算在同類網站中目前平均排名-----------------
strSql = "select count(*) as above_count from stat where avghits>";
strSql += (Integer)countresult.get("avghits");
strSql += " and sitetype='" + (String)countresult.get("sitetype") + "'";
db.query(strSql);
db.next();
torder = db.getInt("above_count") + 1;
//----------計算在所有網站中平均排名--------------------
strSql = "select count(*) as above_count from stat where avghits>";
strSql += (Integer)countresult.get("avghits");
db.query(strSql);
db.next();
order = db.getInt("above_count") + 1;
//-----------預計本日瀏覽人數-----------------------
dTemp = new Date();
iTemp = ((Integer)countresult.get("todayhits")).intValue();
if ((dTemp.getHours()*60 + dTemp.getMinutes()) != 0)
{
pdayhits = (new Float(((float)iTemp/(dTemp.getHours()*60 + dTemp.getMinutes())) *24*60)).intValue();
}
else
{
pdayhits = perdayhits;
}
//-----------讀取最近25位訪問者--------------------
strSql = "select id,puid,ip,browser,os,ip,to_char(thedate,'yyyy-mm-dd') as thedate, ";
strSql += " to_char(thedate,'hh24:mi:ss') as thetime from statdetail ";
strSql += "where puid='" + iUid + "' order by thedate desc";
db.query(strSql);
for (iCount = 0;db.next();iCount++)
{
if (iCount >= 25) break;
client[iCount] = new Hashtable();
sTemp = db.getString("thedate");
client[iCount].put("thedate",sTemp);
sTemp = db.getString("thetime");
client[iCount].put("thetime",sTemp);
client[iCount].put("ip",db.getString("ip"));
client[iCount].put("browser",db.getString("browser"));
client[iCount].put("os",db.getString("os"));
}
}
} catch(Exception e)
{
out.println(e);
} finally
{
try { db.close(); } catch(Exception e) {}
}
%>
<html>
<head>
<title>中華網---個人主頁統計</title>
<style type="text/css">
<!--
body.t{ font-family: "宋體", "Arial", "Times New Roman"; font-size: 9pt;
line-height: 150%; letter-spacing: 1px}
.tt3{ font-family: "!宋體", "!Arial", "!Times New Roman"; font-size:11pt;
line-height: 130%; color: #000000;}
a:hover {color:red;text-decoration:underline}
-->
</style></head>
<body class="tt3">
<div align="center"><center>
<table border="0" width="513" bgcolor="#FCFDDB" cellspacing="0"
cellpadding="2" class="tt3">
<tr>
<td width="18" height="86"></td>
<td width="462" height="86" valign="top"><p align="center"><img src="logohome.gif"
width="303" height="84" alt="logohome.gif (6077 bytes)"></td>
<td width="29" height="86"></td>
</tr>
<tr>
<td width="18" height="28"></td>
<td width="511" height="28" valign="top">
<p align="center">
<a href=<%="\"hourstat.jsp?uid=" + iUid + "\""%>>小時統計</a>
<a href=<%="\"daystat.jsp?uid=" + iUid + "\""%>>日統計</a>
<a href=<%="\"weekstat.jsp?uid=" + iUid + "\""%>>周統計</a>
<a href=<%="\"monthstat.jsp?uid=" + iUid + "\""%>>月統計</a>
<a href=<%="\"purl.jsp?uid=" + iUid + "\""%>>來路顯示</a> </font></td>
<td width="29" height="28"></td>
</tr>
<tr>
<td width="18" height="28"></td>
<td width="511" height="28" valign="top">
<p align="center">
<%
sTemp = "站名:<a href=\"" + url + "\">";
sTemp += webname + "</a> ";
sTemp += "站長:" + "<a href=\"mainto:" + email + "\">";
sTemp += username + "</a>";
out.println(sTemp);
%>
<td width="29" height="28"></td>
</tr>
<tr>
<td width="18" rowspan="2"></td>
<td width="462" valign="top"><table border="0" cellPadding="2" width="100%"
cellspaccing="2">
<TBODY>
<tr>
<td><table class="tt3" border="1" borderColor="#336600" cellPadding="0" cellSpacing="0" width="100%">
<TBODY>
<tr>
<td><table class="tt3" border="0" cellPadding="3" cellSpacing="0" width="100%">
<TBODY>
<tr bgColor="#336600">
<td align="middle" bgColor="#336600" colSpan="2" width="100%"><font color="#ffffff">綜
合 數 據</font></td>
</tr>
<tr bgColor="#cccccc">
<td align="left" width="60%"><p class="sureyeah">開始統計日期 </td>
<td align="right" width="40%"><font color="#336699" >
<%
try {
out.println((Date)countresult.get("starttime"));
} catch (Exception e) { out.println(e); }
%>
</font></td>
</tr>
<tr bgColor="#ffffff">
<td align="left" width="60%">總統計天數</td>
<td align="right" width="40%"><font color="#336699" ><% out.println((Integer)countresult.get("days")); %></font></td>
</tr>
<tr bgColor="#cccccc">
<td align="left" width="60%">總瀏覽人數</td>
<td align="middle" width="40%"><p align="right"><font color="#336699" ><% out.println((Integer)countresult.get("totalhits")); %></font></td>
</tr>
<tr bgColor="#ffffff">
<td align="left" width="60%">平均每天訪問人數</td>
<td align="right" width="40%"><font color="#336699" ><% out.println(perdayhits); %></font></td>
</tr>
<tr bgColor="#cccccc">
<td align="left" width="60%">站點性質</td>
<td align="right" width="40%"><font color="#336699" ><% out.println(typename); %></font></td>
</tr>
<tr bgColor="#cccccc">
<td align="left" width="60%">目前同類站點中平均排名</td>
<td align="right" width="40%"><font color="#336699" >第 <% out.println(torder); %> 名</font></td>
</tr>
<tr bgColor="#ffffff">
<td align="left" width="60%">目前總平均排名</td>
<td align="right" width="40%"><font color="#336699" >第 <% out.println(order); %> 名</font></td>
</tr>
<tr bgColor="#ffffff">
<td align="left" width="60%">今日總瀏覽人數</td>
<td align="right" width="40%"><font color="#336699" ><% out.println((Integer)countresult.get("todayhits")); %></font></td>
</tr>
<tr bgColor="#cccccc">
<td align="left" width="60%">預計本日瀏覽人數</td>
<td align="right" width="40%"><font color="#336699" ><% out.println(pdayhits); %></font></td>
</tr>
<tr bgColor="#ffffff">
<td align="left" width="60%">最高一天瀏覽量</td>
<td align="right" width="40%"><font color="#336699" ><% out.println((Integer)countresult.get("maxhits")); %></font></td>
</tr>
</TBODY>
</table>
</td>
</tr>
</TBODY>
</table>
</td>
</tr>
</table>
</td>
<td width="29" height="60" rowspan="2"></td>
</tr>
<tr>
<td width="462"><table class="tt3" border="1" borderColor="#336600" cellPadding="0"
cellSpacing="0" width="100%">
<TBODY>
<tr>
<td><table class="tt3" border="0" cellPadding="1" cellSpacing="0" height="155" width="100%">
<TBODY>
<tr>
<td colspan="6" align="middle" bgColor="#336600" colSpan="5" width="100%"><font
color="#ffffff"><% out.println("最 后 " + iCount + " 位 訪 問 者"); %></font></td>
</tr>
<tr bgColor="#cccccc">
<td align="middle">日期</td>
<td align="left"><p align="center">時間</td>
<td align="left"><p align="enter">訪客IP</td>
<td align="left"><p align="center">瀏覽器</td>
<td align="right"><p align="center">操作系統</td>
</tr>
<% int i=0; %>
<% while(i<iCount) {%>
<%try {%>
<tr bgColor="#ffffff">
<td align="middle" noWrap ><% out.println((String)client[i].get("thedate")); %></td>
<td align="middle" noWrap ><% out.println((String)client[i].get("thetime")); %></td>
<td align="left" noWrap ><p align="center"><% out.println((String)client[i].get("ip")); %></td>
<td align="left" noWrap ><p align="center"><font color="#000000"><% out.println((String)client[i].get("browser")); %></font></td>
<td align="left" noWrap ><p align="center"><font color="#336699"><% out.println((String)client[i].get("os")); %></font></td>
<%} catch (Exception e) { out.println(e); } %>
</tr>
<% i++;
} %>
</TBODY>
</table>
</td>
</tr>
</TBODY>
</table>
</td>
</tr>
<tr>
<td height="28" width="18"></td>
<td height="28" width="462"></td>
<td height="28" width="29"></td>
</tr>
</table>
</center></div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -