package com.tld.dao;

import java.sql.DriverManager;
import java.util.List;

import com.mysql.jdbc.Connection;
import com.tld.beans.Forecast;

public class ForecastDaoImpl implements ForecastDAO {

	@Override
	public List<Forecast> getAllForecasts() {
		Connection conn = null;
		try
        {
            String userName = "root";
            String password = "turnleaf";
            String url = "jdbc:mysql://localhost/weather";
            Class.forName ("com.mysql.jdbc.Driver").newInstance ();
            conn = (Connection) DriverManager.getConnection (url, userName, password);
            System.out.println ("Database connection established");
        }
        catch (Exception e)
        {
            System.err.println ("Cannot connect to database server");
        }
        finally
        {
            if (conn != null)
            {
                try
                {
                    conn.close ();
                    System.out.println ("Database connection terminated");
                }
                catch (Exception e) { /* ignore close errors */ }
            }
        }

		return null;
	}

}