计数1

String ip=request.getRemoteAddr();

获取用户ip

记录新用户

<jsp:useBean id="mycount" class="com.pp.db.CountOnline "></jsp:useBean> <%
     String ip=request.getRemoteAddr();
    
    
     //获得用户ip地址
     mycount.setUserip(ip);
     ResultSet rs=mycount.checkuser();
     rs.last();
     int num=rs.getRow();
   %>
   <table>
  
    <tr bgcolor="lightgrey">
     <td>
      访问者ip地址
     </td>
       <td>
       访问次数
     </td>
   
    </tr>  
    <%
     rs.beforeFirst();
     while(rs.next()){
     %>
   
     <tr>
     <td>
       <%=rs.getString("user_ip") %>
     </td>
      <td>
     <%=rs.getInt("user_times") %>
     </td>
   
    </tr>  
  
   <%} %>
   <tr>
    <td colspan="2">
       你的ip为:<%=ip %>
       <br>
       你的访问次数为:<%=mycount.getTimes() %>次
       共有<%=num %>个新用户访问过本页
     </td>
  
   </tr>
   </table>

    package com.pp.db;
import java.sql.*;
import java.sql.SQLException;

public class CountOnline {
 
 private String userip;
 private String nowdate;
 private int times;
 private DBOperation db=new DBOperation();
 public CountOnline()
 {}
 public ResultSet checkuser(){
  ResultSet rs=null;
  String sql="select * from usercount where user_ip='"+this.userip+"'";
 
  try {
   rs=  db.executeQuery(sql);
   if(rs.next())
   {
    this.times=rs.getInt("user_times")+1;
    sql="update usercount set user_times="+this.times+" where user_ip='"+this.userip+"'";
    db.executeUpdate(sql);
   }
   
   else
   {
    this.times=1;
    sql="insert into usercount(user_ip,user_times) values('"+this.userip+"',1)";
    db.executeUpdate(sql);
   }
   rs=db.executeQuery("select * from usercount");
   
   
  } catch (SQLException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  }
  
  
  return rs;
  
 }

 
 public void dbclose()
 {
  db.closeConnection();
  
 }
 public String getNowdate() {
  return nowdate;
 }
 public void setNowdate(String nowdate) {
  this.nowdate = nowdate;
 }
 public int getTimes() {
  return times;
 }
 public void setTimes(int times) {
  this.times = times;
 }
 public String getUserip() {
  return userip;
 }
 public void setUserip(String userip) {
  this.userip = userip;
 }

}

String ip=request.getRemoteAddr();

获取用户ip

记录新用户

<jsp:useBean id="mycount" class="com.pp.db.CountOnline "></jsp:useBean> <%
     String ip=request.getRemoteAddr();
    
    
     //获得用户ip地址
     mycount.setUserip(ip);
     ResultSet rs=mycount.checkuser();
     rs.last();
     int num=rs.getRow();
   %>
   <table>
  
    <tr bgcolor="lightgrey">
     <td>
      访问者ip地址
     </td>
       <td>
       访问次数
     </td>
   
    </tr>  
    <%
     rs.beforeFirst();
     while(rs.next()){
     %>
   
     <tr>
     <td>
       <%=rs.getString("user_ip") %>
     </td>
      <td>
     <%=rs.getInt("user_times") %>
     </td>
   
    </tr>  
  
   <%} %>
   <tr>
    <td colspan="2">
       你的ip为:<%=ip %>
       <br>
       你的访问次数为:<%=mycount.getTimes() %>次
       共有<%=num %>个新用户访问过本页//用一个ip来算一个计数,用此num来表示
     </td>
  
   </tr>
   </table>

    package com.pp.db;
import java.sql.*;
import java.sql.SQLException;

public class CountOnline {
 
 private String userip;
 private String nowdate;
 private int times;
 private DBOperation db=new DBOperation();
 public CountOnline()
 {}
 public ResultSet checkuser(){
  ResultSet rs=null;
  String sql="select * from usercount where user_ip='"+this.userip+"'";
 
  try {
   rs=  db.executeQuery(sql);
   if(rs.next())
   {
    this.times=rs.getInt("user_times")+1;
    sql="update usercount set user_times="+this.times+" where user_ip='"+this.userip+"'";
    db.executeUpdate(sql);
   }
   
   else
   {
    this.times=1;
    sql="insert into usercount(user_ip,user_times) values('"+this.userip+"',1)";
    db.executeUpdate(sql);
   }
   rs=db.executeQuery("select * from usercount");
   
   
  } catch (SQLException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  }
  
  
  return rs;
  
 }

 
 public void dbclose()
 {
  db.closeConnection();
  
 }
 public String getNowdate() {
  return nowdate;
 }
 public void setNowdate(String nowdate) {
  this.nowdate = nowdate;
 }
 public int getTimes() {
  return times;
 }
 public void setTimes(int times) {
  this.times = times;
 }
 public String getUserip() {
  return userip;
 }
 public void setUserip(String userip) {
  this.userip = userip;
 }

}