return regions;
}
public Region loadRegion(Integer id) throws RegionNotFoundException {
Region region = null;
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT * FROM regions WHERE ID=");
sqlBuffer.append(id);
ResultSet resultSet = null;
try {
resultSet = excecuteQuery(sqlBuffer.toString());
if(resultSet.next()) {
region = new Region();
region.setId(new Integer(resultSet.getInt("ID")));
region.setName(resultSet.getString("NAME"));
}
} catch (SQLException e) {
throw new RegionNotFoundException("Region " + id + " not found",e);
}
finally {