?? daystat.jsp
字號:
<%@ page import="java.sql.*,Db_sql"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="com.stevesoft.pat.*"%>
<%@ page import="DBConnStat"%>
<%
String iUid="";
String email = "";
String webname = "";
String url = "";
String username = "";
String sTemp = "";
Db_sql db = null;
int total_rec_num=0;
String strSql="";
String day1="";
String day2="";
int i=0;
int j=0;
int k=0;
int maxbarlength=0;
String msg[][]=new String[200][5];
iUid = request.getParameter("uid");
%>
<%
if ((iUid==null)||(iUid.equals(""))) {
%>
<p align=center>所需參數沒有傳遞</p>
<%}
try {
db = new Db_sql(DBConnStat.host,DBConnStat.port,DBConnStat.sid,DBConnStat.user,DBConnStat.password);
//strSql ="select count(*) as snum from statdetail where uid="+iUid+" and SYSDATE-THEDATE<=1";
strSql ="select count(*) as snum from statdetail where puid='"+iUid+"' ";
db.query(strSql);
db.next();
total_rec_num=db.getInt("snum");
if (total_rec_num<=0){
total_rec_num=1;%>
沒有該用戶最近幾天的記錄！<%
}
//-----------得到用戶的郵件和名字 站名 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";
}
%>
<HTML>
<HEAD>
<TITLE>home4u.china.com</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<LINK
href="images/cool.css" rel=stylesheet title=cool type=text/css>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<style type="text/css">
<!--
-->
</style>
</HEAD>
<BODY bgColor=#FFFFFF link="#003366" vlink="#003366" alink="#003366">
<div align="center"><center>
<table width="611" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="163"><a href="http://home4u.china.com/" target=_blank><img src="images/logohome.gif" width="143" height="87" border="0"></a></td>
<td width="437"><a href="http://home4u.china.com/" target=_blank><img
alt=申請home4u border=0 height=60 src="http://home4u.china.com/images/home4ubanner.gif"
width=468></a></td>
</tr>
</table>
<table width="611" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/topedge.gif" width="611" height="9"></td>
</tr>
</table>
<table width="611" border="0" align="center" cellspacing="0" bgcolor="#FFE8D0">
<tr>
<td width="292"><font color="#FFE8D0">--</font>
<a href=<%="\"view.jsp?uid=" + iUid + "\""%>>總體數據</a>
<a href=<%="\"hourstat.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>
</td>
<td width="315">
<div align="right">
<%
sTemp = "站名:<a href=\"" + url + "\">";
sTemp += webname + "</a> ";
sTemp += "站長:" + "<a href=\"mailto:" + email + "\">";
sTemp += username + "</a>";
out.println(sTemp);
%>
</div>
</td>
</tr>
<tr>
<TD colSpan=2>
<TABLE align=center border=1 borderColor=#ffb56a cellPadding=0
cellSpacing=0 class=tt3 width="96%">
<TBODY>
<TR>
<TD>
<TABLE border=0 cellPadding=3 cellSpacing=0 class=tt3 height=155
width="100%">
<TBODY>
<tr>
<TD bgColor=#ffb56a colSpan=6 width="100%"><font
color="#ffffff">最近幾天訪問人數分析</font></td>
</tr>
<tr bgColor="#cccccc">
<td align="middle" width="80">日期</td>
<td align="middle" width="80"><p align="center">訪問人數</td>
<td align="middle" width="80"><p align="center">比率</td>
<td align="middle" width="220"><p align="center">圖示</td>
</tr>
<%
maxbarlength=200;
strSql="select TO_CHAR(THEDATE,'YYYY-MM-DD') as day1,THEDATE from statdetail where puid='"+iUid+"' order by THEDATE desc";
db.query(strSql);
i=0;
if (db.next())
{
day1=db.getString("day1");
msg[i][1]=day1;
msg[i][2]="1";}
while (db.next())
{
day2=db.getString("day1");
if (day2.equals(day1))
{
msg[i][2]=String.valueOf((Integer.parseInt(msg[i][2])+1));
}
else
{
day1=day2;
i++;
msg[i][1]=day1;
msg[i][2]="1";
}
}
k=0;
while (k<=i){
%>
<tr bgColor="#ffffff">
<td align="middle" width="110"><% out.println(msg[k][1]);%></td>
<td align="right" width="70"><% out.println( msg[k][2]);%> </td>
<td align="right" width="70"><% out.println( (Integer.parseInt(msg[k][2])*100/total_rec_num));%>% </td>
<td align="left" width="220"><img src=indbar.gif height=10 width=<% out.println( (Integer.parseInt(msg[k][2])*maxbarlength/total_rec_num));%>></td></tr>
<%k++;
}
} catch(Exception e)
{
//out.println(e);
} finally {
try { db.close(); } catch(Exception e) {}
}
%>
</TBODY>
</table>
</td>
</tr>
</TBODY>
</table>
</td>
</tr>
</table>
<TABLE align=center border=0 cellPadding=8 cellSpacing=0 width=510>
<TBODY>
<TR>
<TD>
<DIV align=center>
<DIV align=left></DIV>Copyright2000 <A href="http://www.china.com/"
target=_blank>http://www.china.com/</A> All Rights
Reserved</DIV></TD></TR></TBODY></TABLE>
<p><p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -