Store Procedure: Result Set

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
/**
 * @see https://www.jc-mouse.net/
 * @author mouse
 */
public class Main {

    public static void main(String[] args) {
        Connection connection = conectar("jdbc:mariadb://localhost:3306/TutorialJava", "root", "");
        if (connection != null) {

            try {
                System.out.println("> Se prepara llamada a procedimiento almacenado");
                CallableStatement stmt = connection.prepareCall("{call empleadosPorCargo(?)}");
                //ingresando parametro INOUT de tipo VARCHAR
                stmt.registerOutParameter(1, Types.VARCHAR);
                stmt.setString(1, "CMO");

                System.out.println("> Ejecutando procedimiento");
                stmt.execute();
                System.out.println("> Ejecucion terminada");

                // Obtiene el Result Set
                ResultSet resultSet = stmt.getResultSet();
                //Imprime en pantalla el resultado
                System.out.printf("%-4s | %-30s | %-30s |\n", "ID", "NOMBRE", "CARGO");
                while (resultSet.next()) {
                    int id = resultSet.getInt("id");
                    String nombre = resultSet.getString("nombre");
                    String cargo = resultSet.getString("cargo");                    
                    System.out.printf("%-4s | %-30s | %-30s |\n", id, nombre, cargo);
                }
            } catch (SQLException ex) {
                System.err.println(ex.getMessage());
            }
        }
    }

    public static Connection conectar(String url, String user, String pass) {
        try {
            Connection connection = DriverManager.getConnection(url, user, pass);
            System.out.println("> Conectado a la base de datos");
            return connection;
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
        }
        return null;
    }
}