private static Schedule getSchedule(Schedule bean, PreparedStatement stmt, ResultSet rs) throws SQLException{
		
		stmt.setDate(1, bean.getWorkDay());
		stmt.setString(2, bean.getUsername());
		
		rs = stmt.executeQuery();
		if (rs.next()) {
			Schedule newBean = new Schedule();
			newBean.setWorkDay(rs.getDate("work_day"));
			newBean.setFrom(rs.getTime("work_from"));
			newBean.setTo(rs.getTime("work_till"));
			newBean.setHourRate(rs.getBigDecimal("hourly_rate"));
			newBean.setVacationDays(rs.getInt("vac_days"));
			newBean.setUsername(rs.getString("username"));
			return newBean;
		} else {
			System.out.println("unable to retrieve schedule info");
			return null;
		}
	}