package database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import logging.LogType;
import logging.SLog;

import config.SProperties;

public class UserDatabase {
    private static final Properties properties = SProperties.getProperties();

    private static final String host = properties.getProperty("DBHost");
    private static final String port = properties.getProperty("DBPort");
    private static final String database = properties.getProperty("DBDatabase");
    private static final String username = properties.getProperty("DBUsername");
    private static final String password = properties.getProperty("DBPassword");

    public synchronized static Connection getInstance() {

	Connection conn = null;
	try {
	    Class.forName("com.mysql.jdbc.Driver");
	    if (conn == null)
		conn = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
	} catch (final ClassNotFoundException e) {
	    SLog.Entry(LogType.Halt, "The MYSQL Connection driver could not be loaded!");
	    e.printStackTrace();
	    System.exit(1);
	} catch (final SQLException e) {
	    SLog.Entry(LogType.Halt, "Some error occured while creating a database connection.");
	    e.printStackTrace();
	    System.exit(1);
	}
	return conn;
    }
}