/** * Queries persons older than provided age. * * @param conn JDBC connection. * @param minAge Minimum age. * @throws SQLException In case of SQL error. */ private static void queryPersons(Connection conn, int minAge) throws SQLException { PreparedStatement stmt = conn.prepareStatement("select name, age from Person where age >= ?"); stmt.setInt(1, minAge); ResultSet rs = stmt.executeQuery(); X.println(">>> Persons older than " + minAge + ":"); while (rs.next()) X.println(">>> " + rs.getString("NAME") + " (" + rs.getInt("AGE") + " years old)"); }
/** * Queries persons working in provided organization. * * @param conn JDBC * @param orgName Organization name. * @throws SQLException In case of SQL error. */ private static void queryPersonsInOrganization(Connection conn, String orgName) throws SQLException { PreparedStatement stmt = conn.prepareStatement( "select p.name from Person p, Organization o where p.orgId = o.id and o.name = ?"); stmt.setString(1, orgName); ResultSet rs = stmt.executeQuery(); X.println(">>> Persons working in " + orgName + ":"); while (rs.next()) X.println(">>> " + rs.getString(1)); }