import java.sql.*;

public class Database {

  // Singleton-instans
  private static Database instance;

  // JDBC-forbindelsen
  private Connection connection;

  // === RET DISSE ===
  private static final String HOST = "localhost";
  private static final String DATABASE = "skole_db";
  private static final String USER = "root";
  private static final String PASSWORD = "";

  private static final String URL =
    "jdbc:mariadb://" + HOST + ":3306/" + DATABASE + "?useSSL=false";

  // Privat constructor (singleton)
  private Database() {
    try {
      connection = DriverManager.getConnection(URL, USER, PASSWORD);
      System.out.println("Database connected");
    } catch (SQLException e) {
      System.out.println("Database connection failed");
      e.printStackTrace();
    }
  }

  // Få singleton-instansen
  public static Database getInstance() {
    if (instance == null) {
      instance = new Database();
    }
    return instance;
  }

  // Giv adgang til forbindelsen
  public Connection getConnection() {
    return connection;
  }
  
  public void close() {
  try {
    if (connection != null && !connection.isClosed()) {
      connection.close();
      System.out.println("Database closed");
    }
  } catch (SQLException e) {
    e.printStackTrace();
  }
}
}