--- android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java	2011/04/28 16:55:52	1399
+++ android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java	2011/04/28 18:50:24	1400
@@ -42,6 +42,16 @@
 		
 	}
 	
+	List<SavedStatBean> convertResultset(ResultSet res) throws SQLException{
+		List<SavedStatBean> stats = new ArrayList<SavedStatBean>();
+		while (res.next()) {
+			SavedStatBean bean = convertRow(res);								
+			stats.add(bean);
+			
+		}		
+		return stats;
+	}
+	
 	
 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 		
@@ -49,7 +59,8 @@
 		try {
 			conn = DBConnection.getConnection();
 			Statement stmt = conn.createStatement();
-			List<SavedStatBean> stats = new ArrayList<SavedStatBean>();
+			
+			
 			
 			
 			String sqlAvg = "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, " +
@@ -69,21 +80,23 @@
 			
 			
 			ResultSet res = stmt.executeQuery(SQL);
+			List<SavedStatBean> stats = convertResultset(res);					
 			
+
+			//////////////////////////////////////////////
 			
-		
+			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";			
+			res = stmt.executeQuery(SQL);
 			
-			while (res.next()) {
-				SavedStatBean bean = convertRow(res);								
-				stats.add(bean);
-				
-			}
+			List<SavedStatBean> top5 = convertResultset(res); 
+
 
 			conn.close();			
 			
 			
 			request.setAttribute("avg", avgBean);
 			request.setAttribute("stats", stats);
+			request.setAttribute("top5", top5);
 			request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response);