Java Reference
In-Depth Information
firstName = rs.getString(2);
membershipYear = rs.getInt(3);
} else {
String error = "ejbFindByPrimaryKey: Member (" + pk + ") not
found";
System.out.println(error);
throw new ObjectNotFoundException (error);
}
} catch (SQLException sqe) {
System.out.println("SQLException: " + sqe);
throw new EJBException (sqe);
} finally {
cleanup(con, ps);
}
return pk;
}
public Collection ejbFindByMembershipYear(int minYear)
throws ObjectNotFoundException {
Connection con = null;
PreparedStatement ps = null;
Vector v = new Vector(); // returing object
try {
con = getConnection();
ps = con.prepareStatement("SELECT memberId FROM member " +
"WHERE membershipYear>?");
ps.setInt(1, minYear);
ps.executeQuery();
ResultSet rs = ps.getResultSet();
String pk;
while (rs.next()) {
pk = rs.getString(1);
v.addElement(pk);
}
} catch (SQLException sqe) {
System.out.println("SQLException: " + sqe);
throw new EJBException (sqe);
} finally {
cleanup(con, ps);
}
return v;
}
