stmt.setDate(3, new java.sql.Date(this.startDate.getTime()));
stmt.setDate(4, new java.sql.Date(this.endDate.getTime()));
stmt.setInt(5, this.personId);
ResultSet results = stmt.executeQuery();
for (boolean isRow = results.next(); isRow; isRow = results.next()) {
TimesheetEntry time = new TimesheetEntry();
time.setPersonName(results.getString("person_name"));
time.setProjectId(results.getInt("project_id"));
time.setProjectName(results.getString("project_name"));
time.setIterationId(results.getInt("iteration_id"));
time.setIterationName(results.getString("iteration_name"));
time.setStoryId(results.getInt("story_id"));
time.setStoryName(results.getString("story_name"));
time.setTotalDuration(results.getDouble("total_duration"));
timesheet.addEntry(time);
}
stmt.close();
doDailyQuery(conn, timesheet, dailyQueryByReportDate);