?? monthstat.jsp
字號(hào):
<%@ 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="";
String day1="";
String day2="";
int i=0;
int j=0;
int k=0;
int maxbarlength=0;
String msg[][]=new String[13][5];
//iUid = Integer.parseInt(request.getParameter("uid"));
iUid = request.getParameter("uid");
%>
<%
//if (iUid==0){
if ((iUid==null)||(iUid.equals(""))) {
%>
<p align=center>所需參數(shù)沒(méi)有傳遞</p>
<%}
try{
db = new Db_sql(DBConnStat.host,DBConnStat.port,DBConnStat.sid,DBConnStat.user,DBConnStat.password);
strSql ="select sum(Jan+Feb+Mar+Apr+May+Jun+Jul+Aug+Sep+Oct+Nov+Dec) as snum from yearstat where puid='"+iUid + "'";
db.query(strSql);
while(db.next()){
total_rec_num=db.getInt("snum");}
if (total_rec_num<=0){
total_rec_num=1;%>
沒(méi)有該用戶的月記錄！<%
}
//-----------得到用戶的郵件和名字 站名 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=申請(qǐng)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 + "\""%>>總體數(shù)據(jù)</a>
<a href=<%="\"hourstat.jsp?uid=" + iUid + "\""%>>小時(shí)統(tǒng)計(jì)</a>
<a href=<%="\"daystat.jsp?uid=" + iUid + "\""%>>日統(tǒng)計(jì)</a>
<a href=<%="\"weekstat.jsp?uid=" + iUid + "\""%>>周統(tǒng)計(jì)</a>
<a href=<%="\"purl.jsp?uid=" + iUid + "\""%>>來(lái)路顯示</a>
</td>
<td width="315">
<div align="right">
<%
sTemp = "站名:<a href=\"" + url + "\">";
sTemp += webname + "</a> ";
sTemp += "站長(zhǎng):" + "<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">星 期 訪 問(wèn) 人 數(shù) 分 析</font></td>
</tr>
<tr bgColor="#cccccc">
<td align="middle" width="80">時(shí)間</td>
<td align="middle" width="80"><p align="center">訪問(wèn)人數(shù)</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 yearstat where puid="+iUid;
strSql="select * from yearstat where puid='"+iUid + "'";
db.query(strSql);
while(db.next()){
msg[1][1]="一月";
msg[1][2]=String.valueOf(db.getInt("Jan"));
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]=String.valueOf(db.getInt("Feb"));
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]=String.valueOf(db.getInt("Mar"));
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]=String.valueOf(db.getInt("Apr"));
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]=String.valueOf(db.getInt("May"));
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]=String.valueOf(db.getInt("Jun"));
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]=String.valueOf(db.getInt("Jul"));
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);
msg[8][1]="八月";
msg[8][2]=String.valueOf(db.getInt("Aug"));
msg[8][3]=String.valueOf(Integer.parseInt(msg[8][2])*100/total_rec_num);
msg[8][4]=String.valueOf(Integer.parseInt(msg[8][3])*maxbarlength/100);
msg[9][1]="九月";
msg[9][2]=String.valueOf(db.getInt("Sep"));
msg[9][3]=String.valueOf(Integer.parseInt(msg[9][2])*100/total_rec_num);
msg[9][4]=String.valueOf(Integer.parseInt(msg[9][3])*maxbarlength/100);
msg[10][1]="十月";
msg[10][2]=String.valueOf(db.getInt("Oct"));
msg[10][3]=String.valueOf(Integer.parseInt(msg[10][2])*100/total_rec_num);
msg[10][4]=String.valueOf(Integer.parseInt(msg[10][3])*maxbarlength/100);
msg[11][1]="十一月";
msg[11][2]=String.valueOf(db.getInt("Nov"));
msg[11][3]=String.valueOf(Integer.parseInt(msg[11][2])*100/total_rec_num);
msg[11][4]=String.valueOf(Integer.parseInt(msg[11][3])*maxbarlength/100);
msg[12][1]="十二月";
msg[12][2]=String.valueOf(db.getInt("Dec"));
msg[12][3]=String.valueOf(Integer.parseInt(msg[12][2])*100/total_rec_num);
msg[12][4]=String.valueOf(Integer.parseInt(msg[12][3])*maxbarlength/100);
}
i=0;
while (i<12){
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>
<%
}
} 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>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -