import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.*;

public class GetMinionNames {
    private static final String URL = "jdbc:mysql://localhost:3306/minions_db";
    private static final String USER = "root";
    private static final String PASSWORD = "1234";

    public static void main(String[] args) throws IOException {
        BufferedReader bfr = new BufferedReader(new InputStreamReader(System.in));

        int villainID = Integer.parseInt(bfr.readLine());

        String query = "SELECT v.name, m.name, m.age FROM minions AS m" +
        "INNER JOIN villains AS v" +
        "ON v.id = ?" +
        "WHERE m.id IN (SELECT vm.minion_id FROM villains_minions AS vm" +
        "WHERE vm.villain_id = ?)";

        try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
             PreparedStatement prepStatement = connection.prepareStatement(query)){

            prepStatement.setInt(1, villainID);
            prepStatement.setInt(2, villainID);
            ResultSet resultSet = prepStatement.executeQuery();

            if (resultSet.next()){
                String villainName = resultSet.getString("vil_name");
                System.out.printf("Villain: %s\n", villainName);
            } else {
                System.out.printf("No villain with ID %d exists in the database.\n", villainID);
            }

            int number = 1;

            while (resultSet.next()){
                String minionName = resultSet.getString("name");

                if  (minionName == null){
                    System.out.printf("<no minions>");
                }
                int minAge = resultSet.getInt("age");
                System.out.printf("%d. %s %s", number, minionName, minAge);
                number++;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}