数据库中date类是以String类型存储的 所以代码如下

++++++++++++++++++++++++++result.java+++++++++++++++++++++++++++++++++++++++

package com.zy.javabean;

public class result {
private int resultID;
private String IP;
private String time;  //时间存入数据库是以String类型存的 
public int getResultID() {
return resultID;
}
public void setResultID(int resultID) {
this.resultID = resultID;
}
public String getIP() {
return IP;
}
public void setIP(String iP) {
IP = iP;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}

}

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++resultImpl.java+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

package com.zy.Impl;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


import com.zy.javabean.DBconnection;
import com.zy.javabean.result;


public class resultImpl {

public boolean addResult(result results){  //插入数据
boolean flag = false;
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String addSql = "insert into result (IP,Time) values(?,?)";
try {
connection  = conn.getConn();
pre = connection.prepareStatement(addSql);
pre.setString(1, results.getIP());
pre.setString(2, results.getTime()); //时间的类型。。。
flag = (pre.executeUpdate()==1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}

public boolean delResult(int  results){     //删除数据
boolean flag = false;
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String delSql = "delete from result where resultID=?";
try {
connection = conn.getConn();
pre = connection.prepareStatement(delSql);
pre.setInt(1, results);
flag = (pre.executeUpdate()==1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}

@SuppressWarnings("null")
public List<result> selResults(result sResult){   //查找数据
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String selSql = "select * from result where resultID = ?";
List<result> results = new ArrayList<result>();
ResultSet rSet = null;
try {
connection = conn.getConn();
pre = connection.prepareStatement(selSql);
pre.setInt(1, sResult.getResultID());
rSet = pre.executeQuery();
while(rSet.next()){
result result = new result();
result.setResultID(rSet.getInt("resultID"));
result.setIP(rSet.getString("IP"));
result.setTime(rSet.getString("time"));
results.add(result);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return results;
}

@SuppressWarnings("null")
public List<result> selResults(){   //查找数据
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String selSql = "select * from result";
List<result> results = new ArrayList<result>();
ResultSet rSet = null;
try {
connection = conn.getConn();
pre = connection.prepareStatement(selSql);
rSet = pre.executeQuery();
while(rSet.next()){
result result = new result();
result.setResultID(rSet.getInt("resultID"));
result.setIP(rSet.getString("IP"));
result.setTime(rSet.getString("time"));
results.add(result);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return results;
}

public int  selResults(String key){   //查找数据
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String selSql = "select resultID from result where Time = ?";
ResultSet rSet = null;
int type = 0;
try {
connection = conn.getConn();
pre = connection.prepareStatement(selSql);
pre.setString(1, key);
rSet = pre.executeQuery();
while(rSet.next()){
type = rSet.getInt(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return type;
}

@SuppressWarnings("null")
public List<result> selResults(int currentPage,int pageSize,String key){   //得到当前页的所以记录
Connection connection = null;
DBconnection conn = new DBconnection();
PreparedStatement pre = null;
String selSql = "select * from result where resultID like ? order by resultID asc limit ?,?";
List<result> results = new ArrayList<result>();
ResultSet rSet = null;
try {
connection = conn.getConn();
pre = connection.prepareStatement(selSql);
pre.setString(1, "%"+key+"%");
pre.setInt(2, (currentPage-1)*pageSize);
pre.setInt(3, pageSize);
rSet = pre.executeQuery();
while(rSet.next()){
result result = new result();
result.setResultID(rSet.getInt("resultID"));
result.setIP(rSet.getString("IP"));
result.setTime(rSet.getString("time"));
results.add(result);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
connection.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return results;
}

@SuppressWarnings("null")
public int getTotal(){  //得到总的记录数
Connection connection = null;
DBconnection conn = new DBconnection();
Statement pre =null;
ResultSet rSet =null;
int total=0;
String selSql = "select count(*) from result ";
try {
connection = conn.getConn();
pre=connection.createStatement();
rSet=pre.executeQuery(selSql);
while(rSet.next()){
total=rSet.getInt(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return total;

}


}