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