showSalaries method

showSalaries.java

public static void showSalaries(Connection conn, String dept) {
    String sql = "SELECT name, salary FROM employees WHERE department = ?";
    try (PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, dept);
        ResultSet rs = stmt.executeQuery();
        while (rs.next()) {
            String name = rs.getString("name");
            double salary = rs.getDouble("salary");
            System.out.println(name + " - " + salary);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}