package net.TargonStore.Suporte.Utils.Storage;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;

import org.bukkit.plugin.Plugin;

public class MySQL {

    private Plugin pl;
    private Connection conn;
    private Statement st;
    private ResultSet rs;

    public MySQL(Plugin pl) {
        this.pl = pl;
        conn = null;
        st = null;
        rs = null;
    }

    public void connect(String hostname, String user, String password, String database) {

        try {

            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://" + hostname + "/" + database, user, password);
            log("MySQL Conectado");
            log("Host: " + hostname);
            log("User: " + user);
            log("Database: " + database);

        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }

    }

    public ResultSet query(String query) {

        try {

            st = conn.createStatement();
            rs = st.executeQuery(query);

        } catch (SQLException e) {
            e.printStackTrace();
        }

        return rs;

    }

    public void update(String update) {

        try {

            st = conn.createStatement();
            st.executeUpdate(update);

        } catch(Exception e) {
            e.printStackTrace();
        }

    }

    public void log(String msg) {
        pl.getLogger().log(Level.INFO, "[TargonSuporte] MySQL * " + msg);
    }

}