*/
public SFamousPlaceArrayList fetchAll() throws DAOException {
SFamousPlace famousPlace = null;
SFamousPlaceArrayList famousPlaceList = new SFamousPlaceArrayList();
PreparedStatement statement = null;
ResultSet result;
Connection connection = DAOHelper.getDBConnection();
try {
try
{
statement = connection.prepareStatement(FETCHALL_QRY);
result = statement.executeQuery();
while(result.next())
{
famousPlace = new SFamousPlace();
famousPlace.setObjId(result.getString("id"));
famousPlace.setObjClass(SFamousPlace.class.getName());
famousPlace.setName(result.getString("name"));
famousPlace.setDescr(result.getString("description"));
famousPlace.setRa(result.getBigDecimal("ra"));
famousPlace.setDec(result.getBigDecimal("dec"));
famousPlaceList.add(famousPlace);
}
}
catch(SQLException exc)
{
throw new FamousPlaceDAOException(exc.getMessage());