📄 purl.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" ;
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 clientnum=0;
String day1="";
//String REFERER="";
int snum=0;
//int msg[][]=new int[24][5];
iUid = request.getParameter("uid");
%>
<%if (iUid==null){%>
<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 puid='"+iUid + "'";
db.query(strSql);
while(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=<%="\"daystat.jsp?uid=" + iUid + "\""%>>日统计</a>
<a href=<%="\"weekstat.jsp?uid=" + iUid + "\""%>>周统计</a>
<a href=<%="\"monthstat.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">最近25位访问者来路分析</font></td>
</tr>
<tr bgColor="#cccccc">
<td align="middle">日期时间</td>
<td align="middle"><p align="center">URL</td>
</tr><%
maxbarlength=200;
strSql="select TO_CHAR(THEDATE,'YYYY-MM-DD') as day1,REFERER from statdetail where puid='"+iUid+"' ORDER BY THEDATE DESC";
db.query(strSql);
i=0;
clientnum=25;
while(db.next() && i<clientnum){
// out.println("i="+i);
// out.println("thedate="+db.getString(day1));
i++;
%>
<tr bgColor="#ffffff">
<td align="middle" nowrap><% out.println(db.getString("day1"));%></td>
<td align="right" nowrap><% out.println( db.getString("REFERER"));%></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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -