package com.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

import com.toolsbean.DB;

public class VoterDao {
	public Date getLastVoteTime(long ip) throws SQLException{
		Date time=null;
		String sql="select max(voter_votetime) from tb_voter where voter_ip=?";
		Object[] params={ip};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		ResultSet rs=mydb.getRs();
		if(rs!=null&&rs.next()){
			time=rs.getTimestamp(1);
			rs.close();
		}
		mydb.closed();
		return time;
	}
	public void saveVoteTime(Object[] params){
		String sql="insert into tb_voter values(?,?,?)";
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		try {
			int i=mydb.getCount();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		mydb.closed();
	}
}