import java.util.*;
import java.sql.*;


public class FanData
{
	public static void main(String args[])
	{
		ArrayList<Fan> fans = new ArrayList<Fan>();


		try
		{
			//database connection
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = DriverManager.getConnection(
				"jdbc:mysql://localhost:3306/f9n", "root", "");

			Statement stat = conn.createStatement();
			ResultSet results = stat.executeQuery("select * from fans");

			while(results.next())
			{
				Fan fan =
					new Fan((Integer)(results.getObject(1)),
							results.getString(2),
							results.getString(3),
							results.getString(4));

				fans.add(fan);
			}

			conn.close();

			for(Fan f:fans)
			{
				System.out.println(f);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}