stmt.setInt(1, this.personId);
stmt.setDate(2, new java.sql.Date(this.startDate.getTime()));
stmt.setDate(3, new java.sql.Date(this.endDate.getTime()));
ResultSet results = stmt.executeQuery();
for (boolean isRow = results.next(); isRow; isRow = results.next()) {
DailyTimesheetEntry time = new DailyTimesheetEntry();
time.setEntryDate(results.getDate("report_date"));
time.setTotalDuration(results.getDouble("total_duration"));
timesheet.addDailyEntry(time);
}
} finally {
stmt.close();
}