mysql get names

package pr03.GetMinionName;

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

public class Main {

    private static final String URL = "jdbc:mysql://localhost:3306/minions_db?useSSL=false";

    private static final String USER = "root";

    private static final String PASSWORD = "admin";

    public static void main(String[] args) {

        Scanner scanner = new Scanner(System.in);

        int villainId = Integer.parseInt(scanner.nextLine());
        String query = "SELECT v.name AS villain_name,m.id,m.name AS minions_name,m.age FROM villains AS v "
                + "INNER JOIN minions_villains AS mv "
                + "ON v.id = mv.villain_id "
                + "INNER JOIN minions AS m "
                + "ON m.id = mv.minion_id " + "WHERE v.id = " + villainId + ";";

        try (Connection connection = DriverManager.getConnection(URL, USER,PASSWORD);
                Statement statement = connection.createStatement();
                ResultSet resultSet = statement.executeQuery(query);) {
            int counter = 0;
            if (resultSet.next()) {
                String villainName = resultSet.getString("villain_name");
                int id = resultSet.getInt("id");
                String minionName = resultSet.getString("minions_name");
                int age = resultSet.getInt("age");
                System.out.printf("Villain: %s%n", villainName);
                if (minionName != null) {
                    System.out.printf("%d %s %d%n", id, minionName, age);
                }
                while (resultSet.next()) {
                    id = resultSet.getInt("id");
                    minionName = resultSet.getString("minions_name");
                    age = resultSet.getInt("age");
                    System.out.printf("%d %s %d%n", id, minionName, age);
                    counter++;
                }
                if (counter == 0) {
                    System.out.println("<no minions>");
                }
            }else {
                System.out.println("No villain with ID " + villainId + " exists in the database.");
            }

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

        }
    }
}