Main2

import java.sql.*;
import java.util.Scanner;

public class Main2 {

    private static final String QUERY1 = "SELECT * FROM departments";

    public static void main(String[] args) {
        showAllDepartments();

        Scanner scanner = new Scanner(System.in);
        int id = scanner.nextInt();
        showWorkersFromDepartmentId(id);
    }

    public static void showAllDepartments() {
        try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/exam2poprawa?useSSL=false", "root", "coderslab")) {
            PreparedStatement ps = con.prepareStatement(QUERY1);

            ResultSet resultSet = ps.executeQuery();
            while (resultSet.next()) {
                System.out.println(resultSet.getInt("id") + " " + resultSet.getString("name"));
            }

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

    public static void showWorkersFromDepartmentId(int id) {

    }
}