/[projects]/android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java
ViewVC logotype

Diff of /android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2090 by torben, Sat Jun 9 11:35:22 2012 UTC revision 2091 by torben, Fri Dec 6 08:52:00 2013 UTC
# Line 96  public class SavedStatistics extends Htt Line 96  public class SavedStatistics extends Htt
96    
97                          //////////////////////////////////////////////                          //////////////////////////////////////////////
98                                                    
99                          SQL = "select statisticsdate,location+name+favorites AS station,location,name,favorites,departure,depcache,deperror,timetable,timecache,timeerror from trainstatistics order by departure - deperror desc limit 5";                                              SQL = "select statisticsdate,location+name+favorites AS station,location,name,favorites,departure,depcache,deperror,timetable,timecache,timeerror " +
100                            " rom trainstatistics order by departure - deperror desc limit 10";                    
101                          res = stmt.executeQuery(SQL);                          res = stmt.executeQuery(SQL);
102                                                    
103                          List<SavedStatBean> top5 = convertResultset(res);                          List<SavedStatBean> top10 = convertResultset(res);
104    
105    
106                          conn.close();                                            conn.close();                  
# Line 108  public class SavedStatistics extends Htt Line 109  public class SavedStatistics extends Htt
109                          request.setAttribute("avg", avgBean);                          request.setAttribute("avg", avgBean);
110                          request.setAttribute("avg30", avg30Bean);                          request.setAttribute("avg30", avg30Bean);
111                          request.setAttribute("stats", stats);                          request.setAttribute("stats", stats);
112                          request.setAttribute("top5", top5);                          request.setAttribute("top10", top10);
113                          request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response);                          request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response);
114                                                    
115                                                    
Legend:
Removed from v.2090  
changed lines
  Added in v.2091
  ViewVC Help
Powered by ViewVC 1.1.20