package com.RS09HD.MySQL;


import com.RS09HD.model.ObjectDefinition;

import java.sql.*;

public final class SqlManager {
    // JDBC driver name and database URL
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost/rs09hd";

    //  Database credentials
    static final String USER = "server";
    static final String PASS = "Runescape09";

    private static boolean initialized;

    public SqlManager() {

    }

    public static void init() {
        Connection conn = null;
        Statement stmt = null;
        try {
            //Initialize sql manager
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            initialized = false;
            return;
        }
        initialized = true;
    }

    public static Connection getConnection() {
        try {
            return DriverManager.getConnection(DB_URL, USER, PASS);
        } catch (SQLException e) {
            System.out.println("Error: Mysql Error:" + e.getMessage());
        }
        return null;
    }



    public static void close(Connection connection) {
        try {
            connection.close();
        } catch(SQLException e) {
            e.printStackTrace();
        }
    }

    public static boolean isInitialized() { return initialized;}

    public static void setInitialized(boolean initialized) {SqlManager.initialized = initialized;}











}