my.jsp<%@ page language="java" contentType="text/html; charset=gb2312" %>
<%@ include file="a.jsp"%>
<% int count=0;
String PId=request.getParameter("PId");
String sql="select * from T_P where T_Code = "+PId+"";
myBean mySearch = new myBean();
mySearch.setConnection();
mySearch.setQuerystatement(sql);
ResultSet myRst=mySearch.getResult();
myRst.first();
myRst.previous();
%>
...
<td height="32"></td>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0></OBJECT>
<td colspan="4"><div align="center">
[ <%out.print("<a href='upload/");%>
<%= myRst.getString("T_Name") %>
<%out.print("' onclick='wb.execwb(4,9)'>"); %>下 载</a>]
[ <a href="javascript:window.close();">关 闭</a> ]</div></td>
...
现在我想统计,简单的,就是统计"下载"的点击次数,想法是在数据库中建一个T表,有个字段为downcount,初始值为0,每次在下载页面获得该字段值赋给变量count,只要点击"下载"一次,count就加1,然后更新该字段,可我是初学者不知道在我上述部分代码如何检测点击"下载"事件,然后使count++;是用javascript还是java,该怎么着手呢?
...
<tr>
<td height="32"></td>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0></OBJECT>
<td colspan="4"><div align="center">[
<%out.print("<a href='upload/");%>
<%= sqlRst.getString("T_Name") %>
<%out.print("' onclick='wb.execwb(4,9)'>"); %>
<%count=Integer.parseInt(sqlRst.getString("T_DownTime"));count++;%>下 载</a>][ <a href="javascript:window.close();">关 闭</a> ]</div></td>
</tr><tr>
<%try{
String sql1="update T_P set T_DownTime="+count+" where T_Code = "+PId+"";
myBean myUpdate = new myBean();
myUpdate.setConnection();
myUpdate.setQuerystatement(sql1);
myUpdate.updateRecord();
}
catch(Exception e){
out.println(e.getMessage());
}%>
...
以上是初步想法,可是数据表字段只要是该页面加载就自增,根本不用点"下载"的超链接.我想要点"下载"后才统计,请问有办法解决吗,恳求各位指点了...
<%@ include file="a.jsp"%>
<% int count=0;
String PId=request.getParameter("PId");
String sql="select * from T_P where T_Code = "+PId+"";
myBean mySearch = new myBean();
mySearch.setConnection();
mySearch.setQuerystatement(sql);
ResultSet myRst=mySearch.getResult();
myRst.first();
myRst.previous();
%>
...
<td height="32"></td>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0></OBJECT>
<td colspan="4"><div align="center">
[ <%out.print("<a href='upload/");%>
<%= myRst.getString("T_Name") %>
<%out.print("' onclick='wb.execwb(4,9)'>"); %>下 载</a>]
[ <a href="javascript:window.close();">关 闭</a> ]</div></td>
...
现在我想统计,简单的,就是统计"下载"的点击次数,想法是在数据库中建一个T表,有个字段为downcount,初始值为0,每次在下载页面获得该字段值赋给变量count,只要点击"下载"一次,count就加1,然后更新该字段,可我是初学者不知道在我上述部分代码如何检测点击"下载"事件,然后使count++;是用javascript还是java,该怎么着手呢?
...
<tr>
<td height="32"></td>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 id=wb name=wb width=0></OBJECT>
<td colspan="4"><div align="center">[
<%out.print("<a href='upload/");%>
<%= sqlRst.getString("T_Name") %>
<%out.print("' onclick='wb.execwb(4,9)'>"); %>
<%count=Integer.parseInt(sqlRst.getString("T_DownTime"));count++;%>下 载</a>][ <a href="javascript:window.close();">关 闭</a> ]</div></td>
</tr><tr>
<%try{
String sql1="update T_P set T_DownTime="+count+" where T_Code = "+PId+"";
myBean myUpdate = new myBean();
myUpdate.setConnection();
myUpdate.setQuerystatement(sql1);
myUpdate.updateRecord();
}
catch(Exception e){
out.println(e.getMessage());
}%>
...
以上是初步想法,可是数据表字段只要是该页面加载就自增,根本不用点"下载"的超链接.我想要点"下载"后才统计,请问有办法解决吗,恳求各位指点了...
if(request.getParameter("download") != null){你的数据库操作}
{
location.href=url+"?"+"&downurl="+downurl+"&seed="+new Date().getTime();
}
在tongji.jsp处理下载统计,再跳转到下载页.
download脚本用window.open也可以。