@Override
	public Collection<MyUser> getAll() {
		ArrayList<MyUser> res = new ArrayList<MyUser>();
		String sql = "SELECT * from users";
		Connection conn = null;
		try {
			conn = dataSource.getConnection();
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				String name = rs.getString("username");
				long cnt = rs.getLong("votes");
				MyUser myuser = new MyUser();
				myuser.setUserName(name);
				myuser.setTotalVotes(cnt);
				res.add(myuser);
			}
			
		} catch (SQLException e) {
			throw new RuntimeException(e);
		} finally {
			if (conn != null) {
				try {
				conn.close();
				} catch (SQLException e) {}
			}
		}
		return res;
	}