lastName) { List personList = new ArrayList(); Connection conn = null; String sql = “select first_name, age from PERSON where last_name=?“; try { DataSource dataSource = DataSourceUtils.getDataSource(); conn = dataSource.getConnection(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, lastName); ResultSet rs = ps.executeQuery(); while (rs.next()) { String firstName = rs.getString(”first_name“); int age = rs.getInt(“age”); personList.add(new Person(firstName, lastName, age)); } } catch (SQLException e) { /* ??? */ } finally { try { conn.close(); } catch (SQLException e) { /* ??? */ } } return personList; } Rod Johnson: Life is too short to write JDBC code!