10 |
import java.util.List; |
import java.util.List; |
11 |
|
|
12 |
import javax.servlet.ServletException; |
import javax.servlet.ServletException; |
|
import javax.servlet.annotation.WebServlet; |
|
13 |
import javax.servlet.http.HttpServlet; |
import javax.servlet.http.HttpServlet; |
14 |
import javax.servlet.http.HttpServletRequest; |
import javax.servlet.http.HttpServletRequest; |
15 |
import javax.servlet.http.HttpServletResponse; |
import javax.servlet.http.HttpServletResponse; |
16 |
|
|
17 |
|
|
18 |
@WebServlet(urlPatterns={"/SavedStatistics"}) |
|
19 |
public class SavedStatistics extends HttpServlet { |
public class SavedStatistics extends HttpServlet { |
20 |
private static final long serialVersionUID = 1L; |
private static final long serialVersionUID = 1L; |
21 |
|
|
52 |
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, " + |
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, " + |
53 |
"round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " + |
"round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " + |
54 |
"round(avg(timetable),1) as timetable, round(avg(timecache),1) as timecache, round(avg(timeerror),1) as timeerror " + |
"round(avg(timetable),1) as timetable, round(avg(timecache),1) as timecache, round(avg(timeerror),1) as timeerror " + |
55 |
"FROM trainstatistics"; |
"FROM trainstatistics " + |
56 |
|
"WHERE statisticsdate <> now()::date "; |
57 |
|
|
58 |
ResultSet resAvg = stmt.executeQuery(sqlAvg); |
ResultSet resAvg = stmt.executeQuery(sqlAvg); |
59 |
resAvg.next(); |
resAvg.next(); |