import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MySQL {

    private String HOST = "";
    private String PORT = "";
    private String DATABASE = "";
    private String USERNAME = "";
    private String PASSWORD = "";
    public boolean isConnected = false;

    private Connection con;

    public MySQL(String HOST, String PORT, String DATABASE, String USERNAME, String PASSWORD) {
        this.HOST = HOST;
        this.PORT = PORT;
        this.DATABASE = DATABASE;
        this.USERNAME = USERNAME;
        this.PASSWORD = PASSWORD;
    }

    public MySQL(String HOST, String PORT, String DATABASE, String USERNAME) {
        this.HOST = HOST;
        this.PORT = PORT;
        this.DATABASE = DATABASE;
        this.USERNAME = USERNAME;
    }

    public void connect() {
        try {
            con = DriverManager.getConnection(
                    "jdbc:mysql://" + HOST + ":" + PORT + "/" + DATABASE + "?autoReconnect=true", USERNAME, PASSWORD);
            System.out.println("Verbindung aufgebaut");
            isConnected = true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void disconnect() {
        try {
            if (con != null)
                con.close();
            System.out.println("Verbindung mit Datenbank getrennt");
            isConnected = false;
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public void update(String qry) {
        try {
            Statement st = con.createStatement();
            st.executeUpdate(qry);
            st.close();
        } catch (SQLException e) {
            connect();
            e.printStackTrace();
        }
    }

    public ResultSet query(String qry) {
        ResultSet rs = null;
        try {
            Statement st = con.createStatement();
            rs = st.executeQuery(qry);
        } catch (SQLException e) {
            connect();
            e.printStackTrace();
        }
        return rs;

    }

}