📄 weekstat.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[8][5];
iUid = request.getParameter("uid");
%>
<%
if ((iUid==null)||(iUid.equals(""))) {
%>
<p align=center>所需参数没有传递</p>
<%
return;
}
try {
db = new Db_sql(DBConnStat.host,DBConnStat.port,DBConnStat.sid,DBConnStat.user,DBConnStat.password);
// strSql ="select sum(monday+tuesday+wednesday+thursday+friday+saturday+sunday) as snum from weekstat where puid="+iUid;
strSql ="select sum(monday+tuesday+wednesday+thursday+friday+saturday+sunday) as snum from weekstat where puid='"+iUid + "'";
db.query(strSql);
while(db.next()){
total_rec_num=db.getInt("snum");
}
// out.println("sum="+total_rec_num);
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=<%="\"daystat.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 * from weekstat where puid="+iUid;
strSql="select * from weekstat where puid='"+iUid + "'";
db.query(strSql);
while(db.next()){
msg[1][1]="星期一";
msg[1][2]=db.getString("monday");
msg[1][3]=String.valueOf(Integer.parseInt(msg[1][2])*100/total_rec_num);
msg[1][4]=String.valueOf(Integer.parseInt(msg[1][3])*maxbarlength/100);
msg[2][1]="星期二";
msg[2][2]=db.getString("tuesday");
msg[2][3]=String.valueOf(Integer.parseInt(msg[2][2])*100/total_rec_num);
msg[2][4]=String.valueOf(Integer.parseInt(msg[2][3])*maxbarlength/100);
msg[3][1]="星期三";
msg[3][2]=db.getString("wednesday");
msg[3][3]=String.valueOf(Integer.parseInt(msg[3][2])*100/total_rec_num);
msg[3][4]=String.valueOf(Integer.parseInt(msg[3][3])*maxbarlength/100);
msg[4][1]="星期四";
msg[4][2]=db.getString("thursday");
msg[4][3]=String.valueOf(Integer.parseInt(msg[4][2])*100/total_rec_num);
msg[4][4]=String.valueOf(Integer.parseInt(msg[4][3])*maxbarlength/100);
msg[5][1]="星期五";
msg[5][2]=db.getString("friday");
msg[5][3]=String.valueOf(Integer.parseInt(msg[5][2])*100/total_rec_num);
msg[5][4]=String.valueOf(Integer.parseInt(msg[5][3])*maxbarlength/100);
msg[6][1]="星期六";
msg[6][2]=db.getString("saturday");
msg[6][3]=String.valueOf(Integer.parseInt(msg[6][2])*100/total_rec_num);
msg[6][4]=String.valueOf(Integer.parseInt(msg[6][3])*maxbarlength/100);
msg[7][1]="星期日";
msg[7][2]=db.getString("sunday");
msg[7][3]=String.valueOf(Integer.parseInt(msg[7][2])*100/total_rec_num);
msg[7][4]=String.valueOf(Integer.parseInt(msg[7][3])*maxbarlength/100);
}
i=0;
while (i<7){
i++;
%>
<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>
<%
}
}
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 + -