package io.micbunk.dommeln;

import java.sql.*;

public class DatabaseManager
{
    private static final String DATABASE_DRIVER = "com.mysql.jdbc.Driver";
    private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/tmdb";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "";

    private static Connection conn;
    private static PreparedStatement stmt;
    private static ResultSet result;

    private DatabaseManager()
    {
    conn = null;
    stmt = null;
    result = null;
    }

    private static class DatabaseManagerInstanceHolder
    {
    private final static DatabaseManager instance = new DatabaseManager();
    }

    public static DatabaseManager getInstance()
    {
    return DatabaseManagerInstanceHolder.instance;
    }

    public static Connection getConnection()
    {
    return DatabaseManager.conn;
    }

    public static PreparedStatement getStatement()
    {
    return DatabaseManager.stmt;
    }

    public static void setStatement(PreparedStatement prepstmt)
    {
    DatabaseManager.stmt = prepstmt;
    }

    public static ResultSet getResult()
    {
    return DatabaseManager.result;
    }

    public static void setResult(ResultSet result)
    {
    DatabaseManager.result = result;
    }

    public static Connection connect()
    {
    if (conn == null)
    {
        System.out.println("Connecting...");
        try
        {
        Class.forName(DATABASE_DRIVER);
            conn = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD);

            //stmt = conn.prepareStatement("SELECT * FROM user_info");
            //result = stmt.executeQuery();

            System.out.println("Connection succeed!");
        }
        catch (ClassNotFoundException | SQLException e)
        {
        System.out.println("Connection failed!");
        e.printStackTrace();
        }
    }

    return conn;
    }

    public static void disconnect()
    {
    if(conn != null)
    {
        System.out.println("Disconnecting...");
        try
        {

        if(conn != null)
        {
            conn.close();
            conn = null;
        }

        if(stmt != null)
        {
            stmt.close();
            stmt = null;
        }


        System.out.println("Disconnecion succeed!");
        }
        catch (SQLException e)
        {
        System.out.println("Disconnection failed!");
        e.printStackTrace();
        }
    }
    }
}