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;
}
}