--- android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java 2013/11/28 09:29:39 2090 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java 2013/12/06 08:52:00 2091 @@ -96,10 +96,11 @@ ////////////////////////////////////////////// - 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 " + + " rom trainstatistics order by departure - deperror desc limit 10"; res = stmt.executeQuery(SQL); - List top5 = convertResultset(res); + List top10 = convertResultset(res); conn.close(); @@ -108,7 +109,7 @@ request.setAttribute("avg", avgBean); request.setAttribute("avg30", avg30Bean); request.setAttribute("stats", stats); - request.setAttribute("top5", top5); + request.setAttribute("top10", top10); request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response);