public Collection<Exchange> findByFilter(Filter iFilter)
throws StockPlayException, FilterException {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
try {
conn = OracleConnection.getConnection();
StringBuilder tQuery = new StringBuilder(SELECT_EXCHANGES);
if (!iFilter.empty()) tQuery.append(" WHERE " + (String) iFilter.compile("sql"));
stmt = conn.prepareStatement(tQuery.toString());
rs = stmt.executeQuery();
ArrayList<Exchange> list = new ArrayList<Exchange>();
while (rs.next()) {
Exchange tExchange = new Exchange(rs.getString(1));
tExchange.setName(rs.getString(2));
tExchange.setLocation(rs.getString(3));
list.add(tExchange);
}
return list;
} finally {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
}
} catch (SQLException ex) {
throw new SubsystemException(SubsystemException.Type.DATABASE_FAILURE, ex.getCause());
}
}
public boolean delete(Exchange entity) throws StockPlayException {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
try {
conn = OracleConnection.getConnection();
stmt = conn.prepareStatement(DELETE_EXCHANGE);
stmt.setString(1, entity.getSymbol());
return stmt.executeUpdate() == 1;
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
} catch (SQLException ex) {
throw new SubsystemException(SubsystemException.Type.DATABASE_FAILURE, ex.getCause());
}
}
public Exchange findById(String symbol) throws StockPlayException {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
try {
conn = OracleConnection.getConnection();
stmt = conn.prepareStatement(SELECT_EXCHANGE);
stmt.setString(1, symbol);
rs = stmt.executeQuery();
if (rs.next()) {
Exchange tExchange = new Exchange(symbol);
tExchange.setName(rs.getString(1));
tExchange.setLocation(rs.getString(2));
return tExchange;
} else {
throw new InvocationException(
InvocationException.Type.NON_EXISTING_ENTITY,
"There is no security with symbol '" + symbol + "'");
}
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
} catch (SQLException ex) {
throw new SubsystemException(SubsystemException.Type.DATABASE_FAILURE, ex.getCause());
}
}