| 1 |
Êþº¾ 2 ¦ +dk/thoerup/traininfoservice/SavedStatistics javax/servlet/http/HttpServlet serialVersionUID J
ConstantValue <init> ()V Code |
| 2 |
|
| 3 |
LineNumberTable LocalVariableTable this -Ldk/thoerup/traininfoservice/SavedStatistics; |
| 4 |
convertRow A(Ljava/sql/ResultSet;)Ldk/thoerup/traininfoservice/SavedStatBean; |
| 5 |
Exceptions java/sql/SQLException )dk/thoerup/traininfoservice/SavedStatBean |
| 6 |
java/sql/ResultSet getString (I)Ljava/lang/String; " # $ label Ljava/lang/String; & ' $ station ) * $ location , - $ name / 0 $ favorites 2 3 $ departure 5 6 $ depcache 8 9 $ deperror ; < $ timetable > ? $ timecache A B $ timeerror res Ljava/sql/ResultSet; bean +Ldk/thoerup/traininfoservice/SavedStatBean; doGet R(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V J javax/servlet/ServletException L java/io/IOException |
| 7 |
N P O (dk/thoerup/traininfoservice/DBConnection Q R
getConnection ()Ljava/sql/Connection; T V U java/sql/Connection W X createStatement ()Ljava/sql/Statement; Z java/util/ArrayList |
| 8 |
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 b c executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; e f g next ()Z |
| 9 |
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 m o n java/util/List p q add (Ljava/lang/Object;)Z T s t close v avg x z y %javax/servlet/http/HttpServletRequest { | setAttribute '(Ljava/lang/String;Ljava/lang/Object;)V ~ stats € /savedstatistics.jsp x ‚ ƒ „ getRequestDispatcher 5(Ljava/lang/String;)Ljavax/servlet/RequestDispatcher; † ˆ ‡ javax/servlet/RequestDispatcher ‰ Š forward @(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V |
| 10 |
I Π|
| 11 |
(Ljava/lang/Throwable;)V request 'Ljavax/servlet/http/HttpServletRequest; response (Ljavax/servlet/http/HttpServletResponse; conn Ljava/sql/Connection; stmt Ljava/sql/Statement; Ljava/util/List; sqlAvg resAvg avgBean SQL e Ljava/sql/SQLException; LocalVariableTypeTable =Ljava/util/List<Ldk/thoerup/traininfoservice/SavedStatBean;>;
StackMapTable ¡ &javax/servlet/http/HttpServletResponse £ java/lang/String |
| 12 |
SourceFile SavedStatistics.java ! |
| 13 |
/ *·
± ÷ ‰» Y· M,+¹ µ !,+¹ µ %,+¹ µ (,+¹ µ +,+¹ µ .,+¹ µ 1,+¹ µ 4,+¹ µ 7,+ ¹ µ :,+ |
| 14 |
¹ µ =,+ ¹ µ @,° 6
) 4 ? K W ! c " o # { $ ‡ & ‰ ‰ C D E F G H I K ¬N¸ MN-¹ S :» YY· [:\:¹ ^ :¹ d W*¶ h:j: ¹ ^ : |
| 15 |
§ * |
| 16 |
¶ h: ¹ l W |
| 17 |
¹ d šÿç-¹ r +u¹ w +}¹ w +¹ +,¹ … § :-Æ -¹ r § :» IY· ‹¿± ’ œ Ÿ ^ - / 0 1 4 : & ; . < 6 @ : D E I H J P K Z I d O j R t S ~ T W ’ Y Ÿ Z ¡ [ « ] „
¬ ¬ Ž ¬ ‘ ª ’ “ ‚ ” • y ~ – u — $ & j ˜ D 6 Z ™ F : V š $ E K C D |
| 18 |
P |
| 19 |
E F ’ › œ y ~ ž Ÿ O ÿ H x T _ m ¢ ¢ ÿ 5 x T ü B ú ¤ ¥ |
Parent Directory
| 
Revision Log