pstmt.setInt(3, activityStartDay);
pstmt.setInt(4, activityEndDay);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Stat stats = new Stat();
stats.setActivityDay(rs.getInt("activity_day"));
int animalTypeID = rs.getInt("animal_type_id");
stats.setAnimalTypeId(animalTypeID);
stats.setActivityType(rs.getString("activity_type"));
stats.setCount(rs.getInt("animal_count"));
//stats.setEnvironmentScore(rs.getInt("env_score"));
//stats.setActivityMessage(rs.getString("activity_message"));
String animalName= GameServer.getAnimalName(animalTypeID);
stats.setAnimalName(animalName);
statsList.add(stats);
}
rs.close();
pstmt.close();