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.checkclass="tags" href="/tags/USER.html" title=user>user();
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("class="tags" href="/tags/USER.html" title=user>user_ip") %>
</td>
<td>
<%=rs.getInt("class="tags" href="/tags/USER.html" title=user>user_times") %>
</td>
</tr>
<%} %>
<tr>
<td colspan="2">
你的ip为:<%=ip %>
<br>
你的访问次数为:<%=mycount.getTimes() %>次
共有<%=num %>个新用户访问过本页
</td>
</tr>
</table>
package com.pp.db;
class="tags" href="/tags/IMPORT.html" title=import>import java.class="tags" href="/tags/SQL.html" title=sql>sql.*;
class="tags" href="/tags/IMPORT.html" title=import>import java.class="tags" href="/tags/SQL.html" title=sql>sql.SQLException;
public class CountOnline {
private String class="tags" href="/tags/USER.html" title=user>userip;
private String nowdate;
private int times;
private DBOperation db=new DBOperation();
public CountOnline()
{}
public ResultSet checkclass="tags" href="/tags/USER.html" title=user>user(){
ResultSet rs=null;
String class="tags" href="/tags/SQL.html" title=sql>sql="select * from class="tags" href="/tags/USER.html" title=user>usercount where class="tags" href="/tags/USER.html" title=user>user_ip='"+this.class="tags" href="/tags/USER.html" title=user>userip+"'";
try {
rs= db.executeQuery(class="tags" href="/tags/SQL.html" title=sql>sql);
if(rs.next())
{
this.times=rs.getInt("class="tags" href="/tags/USER.html" title=user>user_times")+1;
class="tags" href="/tags/SQL.html" title=sql>sql="update class="tags" href="/tags/USER.html" title=user>usercount set class="tags" href="/tags/USER.html" title=user>user_times="+this.times+" where class="tags" href="/tags/USER.html" title=user>user_ip='"+this.class="tags" href="/tags/USER.html" title=user>userip+"'";
db.executeUpdate(class="tags" href="/tags/SQL.html" title=sql>sql);
}
else
{
this.times=1;
class="tags" href="/tags/SQL.html" title=sql>sql="insert into class="tags" href="/tags/USER.html" title=user>usercount(class="tags" href="/tags/USER.html" title=user>user_ip,class="tags" href="/tags/USER.html" title=user>user_times) values('"+this.class="tags" href="/tags/USER.html" title=user>userip+"',1)";
db.executeUpdate(class="tags" href="/tags/SQL.html" title=sql>sql);
}
rs=db.executeQuery("select * from class="tags" href="/tags/USER.html" title=user>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 class="tags" href="/tags/USER.html" title=user>userip;
}
public void setUserip(String class="tags" href="/tags/USER.html" title=user>userip) {
this.class="tags" href="/tags/USER.html" title=user>userip = class="tags" href="/tags/USER.html" title=user>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.checkclass="tags" href="/tags/USER.html" title=user>user();
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("class="tags" href="/tags/USER.html" title=user>user_ip") %>
</td>
<td>
<%=rs.getInt("class="tags" href="/tags/USER.html" title=user>user_times") %>
</td>
</tr>
<%} %>
<tr>
<td colspan="2">
你的ip为:<%=ip %>
<br>
你的访问次数为:<%=mycount.getTimes() %>次
共有<%=num %>个新用户访问过本页//用一个ip来算一个计数,用此num来表示
</td>
</tr>
</table>
package com.pp.db;
class="tags" href="/tags/IMPORT.html" title=import>import java.class="tags" href="/tags/SQL.html" title=sql>sql.*;
class="tags" href="/tags/IMPORT.html" title=import>import java.class="tags" href="/tags/SQL.html" title=sql>sql.SQLException;
public class CountOnline {
private String class="tags" href="/tags/USER.html" title=user>userip;
private String nowdate;
private int times;
private DBOperation db=new DBOperation();
public CountOnline()
{}
public ResultSet checkclass="tags" href="/tags/USER.html" title=user>user(){
ResultSet rs=null;
String class="tags" href="/tags/SQL.html" title=sql>sql="select * from class="tags" href="/tags/USER.html" title=user>usercount where class="tags" href="/tags/USER.html" title=user>user_ip='"+this.class="tags" href="/tags/USER.html" title=user>userip+"'";
try {
rs= db.executeQuery(class="tags" href="/tags/SQL.html" title=sql>sql);
if(rs.next())
{
this.times=rs.getInt("class="tags" href="/tags/USER.html" title=user>user_times")+1;
class="tags" href="/tags/SQL.html" title=sql>sql="update class="tags" href="/tags/USER.html" title=user>usercount set class="tags" href="/tags/USER.html" title=user>user_times="+this.times+" where class="tags" href="/tags/USER.html" title=user>user_ip='"+this.class="tags" href="/tags/USER.html" title=user>userip+"'";
db.executeUpdate(class="tags" href="/tags/SQL.html" title=sql>sql);
}
else
{
this.times=1;
class="tags" href="/tags/SQL.html" title=sql>sql="insert into class="tags" href="/tags/USER.html" title=user>usercount(class="tags" href="/tags/USER.html" title=user>user_ip,class="tags" href="/tags/USER.html" title=user>user_times) values('"+this.class="tags" href="/tags/USER.html" title=user>userip+"',1)";
db.executeUpdate(class="tags" href="/tags/SQL.html" title=sql>sql);
}
rs=db.executeQuery("select * from class="tags" href="/tags/USER.html" title=user>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 class="tags" href="/tags/USER.html" title=user>userip;
}
public void setUserip(String class="tags" href="/tags/USER.html" title=user>userip) {
this.class="tags" href="/tags/USER.html" title=user>userip = class="tags" href="/tags/USER.html" title=user>userip;
}
}