/** * Finds all EJBeans
with a balance greater than a given amount. * Returns an Enumeration of
found EJBean primary keys. * * @param balanceGreaterThan double Test
Amount * @return Enumeration EJBean Primary Keys * @exception
javax.ejb.EJBException * if there is a communications or systems failure
*/ public Enumeration ejbFindBigAccounts(double balanceGreaterThan) {
log("ejbFindBigAccounts (balance > " + balanceGreaterThan + ")");
Connection con = null; PreparedStatement ps = null;
try {
con = getConnection(); ps = con.prepareStatement("select id from
ejbAccounts where bal ?"); ps.setDouble(1, balanceGreaterThan);
ps.executeQuery(); ResultSet rs = ps.getResultSet(); Vector v = new
Vector(); String pk; while (rs.next()) { pk = rs.getString(1);
v.addElement(pk); } return v.elements(); } catch (SQLException
sqe) { log("SQLException: " + sqe); throw new EJBException (sqe); }
finally { cleanup(con, ps); } } 结论：不爽，不方便。
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
