package csis626;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;

/**
   Taken from BigJava Cay Horstmann (http://www.horstmann.com/bigjava.html)
   A simple data source for getting database connection
*/
public class SimpleDataSource
{
   /**
      Initialize the data source
      @param fileName the name of the property file that
      contains the database driver, url, username, and password
   */
   public static void init(String fileName) throws IOException, ClassNotFoundException
   {
      Properties props = new Properties();
      FileInputStream in = new FileInputStream(fileName);
      props.load(in);

      String driver = props.getProperty("jdbc.driver");
      url = props.getProperty("jdbc.url");
      username = props.getProperty("jdbc.username");
      password = props.getProperty("jdbc.password");

      Class.forName(driver);
   }

   /**
      Gets a connection to the database
      @return the database connection
   */
   public static Connection getConnection() throws SQLException
   {
      return DriverManager.getConnection(url, username, password);
   }

   private static String url;
   private static String username;
   private static String password;

}