if (results.next()) {
java.util.Date ratedTime = new java.util.Date(
results.getTimestamp(DatabaseConstants.RATED_TIME_FIELD).getTime());
RatingDO ratingDAO = new RatingDO();
ratingDAO.setRatedUserName(results.getString(DatabaseConstants.USER_ID_FIELD));
ratingDAO.setRatedTime(ratedTime);
ratingDAO.setRating(results.getInt(DatabaseConstants.RATING_FIELD));
// TODO:
//ratingDAO.setResourceID(results.getString(DatabaseConstants.AID_FIELD));
String resourcePath = null;
long version = results.getLong(DatabaseConstants.VERSION_FIELD);
if (version > 0) {
resourcePath = resourceDAO.getPath(version);
}
if (resourcePath != null) {
ratingDAO.setResourcePath(resourcePath);
}
return ratingDAO;
}
} finally {
if (results != null) {