Êþº¾2¦+dk/thoerup/traininfoservice/SavedStatisticsjavax/servlet/http/HttpServletserialVersionUIDJ ConstantValue()VCode  LineNumberTableLocalVariableTablethis-Ldk/thoerup/traininfoservice/SavedStatistics; convertRowA(Ljava/sql/ResultSet;)Ldk/thoerup/traininfoservice/SavedStatBean; Exceptionsjava/sql/SQLException)dk/thoerup/traininfoservice/SavedStatBean  java/sql/ResultSet   getString(I)Ljava/lang/String; " #$labelLjava/lang/String; & '$station ) *$location , -$name / 0$ favorites 2 3$ departure 5 6$depcache 8 9$deperror ; <$ timetable > ?$ timecache A B$ timeerrorresLjava/sql/ResultSet;bean+Ldk/thoerup/traininfoservice/SavedStatBean;doGetR(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)VJjavax/servlet/ServletExceptionLjava/io/IOException NPO(dk/thoerup/traininfoservice/DBConnection QR getConnection()Ljava/sql/Connection; TVUjava/sql/Connection WXcreateStatement()Ljava/sql/Statement;Zjava/util/ArrayList Y]ÊSELECT count(*) AS count, round(avg(location+name+favorites),1) AS station, round(avg(location),1) as location, round(avg(name),1) as name, round(avg(favorites),1) as favorites, round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, round(avg(timetable),1) as timetable, round(avg(timecache),1) as timecache, round(avg(timeerror),1) as timeerror FROM trainstatistics WHERE statisticsdate <> now()::date _a`java/sql/Statement bc executeQuery((Ljava/lang/String;)Ljava/sql/ResultSet; e fgnext()Z i kÇSELECT statisticsdate, location+name+favorites AS station, location,name,favorites,departure,depcache,deperror,timetable,timecache,timeerror FROM trainstatistics ORDER BY statisticsdate DESC limit 14 monjava/util/List pqadd(Ljava/lang/Object;)Z Ts t closevavg xzy%javax/servlet/http/HttpServletRequest {| setAttribute'(Ljava/lang/String;Ljava/lang/Object;)V~stats€/savedstatistics.jsp x‚ ƒ„getRequestDispatcher5(Ljava/lang/String;)Ljavax/servlet/RequestDispatcher; †ˆ‡javax/servlet/RequestDispatcher ‰Šforward@(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V IŒ (Ljava/lang/Throwable;)Vrequest'Ljavax/servlet/http/HttpServletRequest;response(Ljavax/servlet/http/HttpServletResponse;connLjava/sql/Connection;stmtLjava/sql/Statement;Ljava/util/List;sqlAvgresAvgavgBeanSQLeLjava/sql/SQLException;LocalVariableTypeTable=Ljava/util/List; StackMapTable¡&javax/servlet/http/HttpServletResponse£java/lang/String SourceFileSavedStatistics.java!  /*· ±  ÷‰»Y·M,+¹µ!,+¹µ%,+¹µ(,+¹µ+,+¹µ.,+¹µ1,+¹µ4,+¹µ7,+ ¹µ:,+ ¹µ=,+ ¹µ@,°6 )4?K W!c"o#{$‡& ‰‰CDEFGHIK  ¬N¸MN-¹S:»YY·[:\:¹^:¹dW*¶h:j:  ¹^: §* ¶h:  ¹lW ¹dšÿç-¹r+u¹w+}¹w+¹+,¹…§:-Æ-¹r§:»IY·‹¿±’œŸ^-/014:&;.<6@:DEIHJPKZIdOjRtS~TW’YŸZ¡[«]„ ¬¬Ž¬‘ª’“‚”•y~–u—$&j˜D6Z™F:Vš$ EKCD P EF ’›œ y~žŸOÿH x T_m¢¢ÿ5x Tü Bú ¤¥