private static boolean insertSchedule(Schedule bean, PreparedStatement stmt) throws SQLException{
		
		stmt.setDate(1, bean.getWorkDay());
		stmt.setTime(2, bean.getFrom());
		stmt.setTime(3, bean.getTo());
		stmt.setBigDecimal(4, bean.getHourRate());
		stmt.setInt(5, bean.getVacationDays());
		stmt.setString(6, bean.getUsername());

		int affected = stmt.executeUpdate();
		if(affected == 1){
			System.out.println("new schedule added successfully");
		}else{
			System.out.println("error adding schedule");
			return false;
		}
		return true;
	}