count.jsp

【首语】 非常感谢你能够对季风流量统计系统感兴趣。不管你是JAVA的初学者、还是JAVA的高手

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者：季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:[e-mail]                             
     网站:http://www.hxwa.net       
*/	 
String ok=request.getParameter("ok");
if (ok.equals("1")) {
String admin=request.getParameter("id");
String curURL=request.getParameter("curURL");
String Ip=request.getRemoteAddr();//request.getParameter("ip");

Connection con = feng.getConn() ;
Statement stmt=con.createStatement();
Statement stmt2=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs =null;
String ip1,ip2,ip3,ip4;

 int i=Ip.indexOf(".");
 ip1=Ip.substring(0,i);
 Ip=Ip.substring(i+1,Ip.length());

 i=Ip.indexOf(".");
 ip2=Ip.substring(0,i);
 Ip=Ip.substring(i+1,Ip.length());

 i=Ip.indexOf(".");
 ip3=Ip.substring(0,i);
 ip4=Ip.substring(i+1,Ip.length());

String Ipone=ip1;
String Iptwo=ip1+"."+ip2;
long IpOK;
IpOK=(long)Integer.valueOf(ip1).intValue()*256*256*256+Integer.valueOf(ip2).intValue()*256*256+Integer.valueOf(ip3).intValue()*256+Integer.valueOf(ip4).intValue();

String SIp="pp";
SIp=Long.toString(IpOK);
Ip=request.getRemoteAddr();


String sql="Select Top 1 country,city From address Where  ip1<="+SIp+" and ip2>="+SIp+" Order By ip1";
rs=stmt2.executeQuery(sql) ;

String   country="地区不详";
String   city="地址不详";
rs.last();
if (rs.getRow()>0){
country=rs.getString("country");
city=rs.getString("city");
}

if (city==null)
  city="";

sql="Select Top 1 Scope From IpScope Where StartIp<='"+SIp+"' and EndIp>='"+SIp+"' Order By Scope DESC";
String ChinaNum="OtherNum";
rs.last();
if (rs.getRow()>0){
  ChinaNum="ChinaNum";
}

//sql="update InfoList set TotalNum=TotalNum+1,"+ChinaNum+"="+ChinaNum+"+1 where admin='"+admin+"'";
//stmt.executeUpdate(sql);
sql="update InfoList set "+ChinaNum+"="+ChinaNum+"+1 where admin='"+admin+"'";
stmt.executeUpdate(sql);

String Referer=request.getParameter("Referer");//request.getServerName();//
if (Referer==null)
  Referer="直接输入";
else
   if (Referer.equals("")) 
  Referer="直接输入";

String Width=request.getParameter("Width");
String Height=request.getParameter("Height");

String Screen=Width+"X"+Height;

String userAgent="";
userAgent=request.getHeader("User-Agent");

String Browser = "unknown";
String os = "unknown";

Browser=userAgent.split(";")[1].trim();
os     =userAgent.split(";")[2].trim();
userAgent=userAgent.toLowerCase();

if (userAgent.indexOf("win") > -1)
{
 
if (userAgent.indexOf("windows nt 5.0") > -1 || userAgent.indexOf("winnt5.0") > -1)
{
  os = "Windows 2000";
}
if (userAgent.indexOf("windows nt 5.1") > -1 || userAgent.indexOf("winnt5.1") > -1)
{
  os = "Windows XP";
}
if (userAgent.indexOf("win16") > -1 || userAgent.indexOf("windows 3.") > -1)
{
  os = "Windows 3.x";
}
}

userAgent=request.getHeader("User-Agent");

sql="insert into Visitor(admin,IP,Address,Browser,System,Screen,Referer,curURL) values('"+admin+"','"+Ip+"','"+country+city+
  "','"+Browser+"','"+os+"','"+Screen+"','"+Referer+"','"+curURL+"')" ; 
stmt.executeUpdate(sql);

Cookie[] cookies=request.getCookies();
Cookie VisiCount=null;
boolean find=false;
for (i=0;i<cookies.length;i++){
	VisiCount=cookies[i];
  if( VisiCount.getName().equals("VisiCount")){
	  find=true;
	  break;
  }
 // VisiCount.setValue("1");
}
if (!find){
  VisiCount= new Cookie("VisiCount","1");
} 

int Count=Integer.valueOf(VisiCount.getValue()).intValue();
String Str=Integer.toString(Count+1);
VisiCount.setValue(Str);
VisiCount.setMaxAge(10*24*60*60);
response.addCookie(VisiCount);

//out.println("Cookie:"+Count);
if (Count>9)
  Count=10;

String Visit[]={"首次","二次","三次","四次","五次","六次","七次","八次","九次","十次以上"};
String StrVisit=Visit[Count-1];
feng.AddNum("feng","FVisit","jf",StrVisit,admin);


String StrHour      ="时"+feng.getHour();
String StrDay       ="日"+feng.getStrDay();
String StrMonth     ="月"+feng.getStrMonth();

String StrWeek      =feng.getWeek();
String StrDayLong   =feng.getDay();
String StrMonthLong =feng.getMonth();
String StrHourLong  =feng.gettime()+":00:00";
String StrYear      =StrDayLong.substring(0,4);

feng.ModiMaxNum(StrMonthLong,"OldMonth","MonthNum","MonthMaxDate","MonthMaxNum",admin);
feng.ModiMaxNum(StrDayLong,"OldDay","DayNum","DayMaxDate","DayMaxNum",admin);
feng.ModiMaxNum(StrHourLong,"OldHour","HourNum","HourMaxTime","HourMaxNum",admin);


feng.AddNum(os,"FSystem","TSystem","TSysNum",admin);
feng.AddNum(Browser,"FBrowser","TBrowser","TBrwNum",admin);
feng.AddNum(userAgent,"FMozilla","TMozilla","TMozNum",admin);
feng.AddNum(Screen,"FScreen","TScreen","TScrNum",admin);
feng.AddNum(Referer,"FRefer","TRefer","TRefNum",admin);
//feng.AddNum(curURL,"FWeburl","TWeburl","TWebNum",admin);
feng.AddNum(country,"FAddress","TAddress","TAddNum",admin);
feng.AddNum(city,"FArea","TArea","TAreNum",admin);
feng.AddNum(Ipone,"FIpone","TIpone","TOneNum",admin);
feng.AddNum(Iptwo,"FIptwo","TIptwo","TTwoNum",admin);

  

feng.AddNum(StrYear,"StatYear","TYear",StrMonth,admin);
feng.AddNum("ALL","StatMonth","TMonth",StrDay,admin);
feng.AddNum(StrMonthLong,"StatMonth","TMonth",StrDay,admin);
feng.AddNum("ALL","StatDay","TDay",StrHour,admin);
feng.AddNum(StrDayLong,"StatDay","TDay",StrHour,admin);

feng.AddNum("ALL","StatWeek","TWeek",StrWeek,admin);
sql="Delete From StatWeek where datediff('Ww',Fdate,now())>0 and admin='"+admin+"' and  TWeek='Now'";
stmt.executeUpdate(sql) ;
feng.AddNum("Now","StatWeek","TWeek",StrWeek,admin);

		 try {
              rs.close();
              stmt.close();
			  stmt2.close();
              con.close();
            }
            catch (Exception ex) {
            }

}
%>