📄 hourstat.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"%>
<% //include "./db_mysql.inc" ;
//int iUid=0;
String iUid="";
String email = "";
String webname = "";
String url = "";
String username = "";
String sTemp = "";
Db_sql db = null;
int total_rec_num=0;
String strSql="";
int i=0;
int j=0;
int maxbarlength=0;
int msg[][]=new int[24][5];
//iUid = Integer.parseInt(request.getParameter("uid"));
iUid = request.getParameter("uid");
%>
<%
// if (iUid==0){
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+" and SYSDATE-THEDATE<=1";
strSql ="select count(*) as snum from statdetail where puid='"+iUid+"' and SYSDATE-THEDATE<=1";
// out.println(strSql);
//$newdb=new DB_Sql;
// $sql="select count(*) as snum from statdetail where uid='$uid' and to_days(now())-to_days(date)<=1";
// $newdb->query($sql);
db.query(strSql);
// while($newdb->next_record()){
while(db.next()){
// $total_rec_num=$newdb->Record["snum"];}
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=<%="\"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>
</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,'HH') as hour1 from statdetail where puid="+iUid+" and SYSDATE-THEDATE<=1";
strSql="select TO_CHAR(THEDATE,'HH') as hour1 from statdetail where puid='"+iUid+"' and SYSDATE-THEDATE<=1";
// $result=$newdb->query($sqlstr);
db.query(strSql);
j=0;
while (j<24){
msg[j][1]=j;
msg[j][2]=0;
msg[j][3]=0;
j++;}
// while($newdb->next_record()){
while(db.next()){
//i=newdb->Record["hour1"];
i=db.getInt("hour1");
msg[i][2]=msg[i][2]+1;
msg[i][3]=(msg[i][2]*100/total_rec_num);
msg[i][4]=(msg[i][3]*maxbarlength/100);
}
i=0;
while (i<24){
%>
<tr bgColor="#ffffff">
<td align="middle" width="80"><% out.println( msg[i][1]);%></td>
<td align="right" width="80"><% out.println( msg[i][2]);%> </td>
<td align="right" width="80"><% out.println(msg[i][3]);%>% </td>
<td align="left" width="220"><img src=indbar.gif height=10 width=<% out.println( msg[i][4]);%>></td></tr>
<%i=i+1;
}
} 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 + -