package com.vote.service;

import java.net.InetAddress;
import java.net.UnknownHostException;
import java.sql.ResultSet;
import java.sql.SQLException;

public class VoteService {

	public String showUser() throws SQLException {
		String sql = "select * from vote_user";
		StringBuffer result = new StringBuffer();
		ResultSet rs = DBService.getConnection().createStatement().executeQuery(sql);
		while(rs.next()) {
			result.append("{\"uid\":\"").append(rs.getString("uid")).append("\",");
			result.append("\"username\":\"").append(rs.getString("username")).append("\"},");
		}
		return result.deleteCharAt(result.length() - 1).toString();
	}
	
	public boolean vote(String uid) throws UnknownHostException, SQLException {
		
		InetAddress addr = InetAddress.getLocalHost();
		String ip=addr.getHostAddress().toString();	//获得本机IP
		
		String findSql = "select ip from vote_vote where ip = '" + ip + "'";
		ResultSet rs = DBService.getConnection().createStatement().executeQuery(findSql);
		if(rs.next()) {
			return false;
		} else {
			String insertSql = "insert into vote_vote(uid, ip, votedate) values ('" + uid + "','" + ip + "','" + new java.sql.Date(System.currentTimeMillis()) + "')";
			int res = DBService.getConnection().createStatement().executeUpdate(insertSql);
			if(res > 0) 
				return true;
		}
		return false;
	}
}