24 |
protected SavedStatBean convertRow(ResultSet res) throws SQLException { |
protected SavedStatBean convertRow(ResultSet res) throws SQLException { |
25 |
SavedStatBean bean = new SavedStatBean(); |
SavedStatBean bean = new SavedStatBean(); |
26 |
|
|
27 |
bean.statisticsdate = res.getString(1); |
bean.label = res.getString(1); |
28 |
bean.station = res.getString(2); |
bean.station = res.getString(2); |
29 |
bean.location = res.getString(3); |
bean.location = res.getString(3); |
30 |
bean.name = res.getString(4); |
bean.name = res.getString(4); |
58 |
ResultSet resAvg = stmt.executeQuery(sqlAvg); |
ResultSet resAvg = stmt.executeQuery(sqlAvg); |
59 |
resAvg.next(); |
resAvg.next(); |
60 |
SavedStatBean avgBean = convertRow(resAvg); |
SavedStatBean avgBean = convertRow(resAvg); |
|
stats.add(avgBean); |
|
61 |
|
|
62 |
//////////////////////////////////////////////// |
//////////////////////////////////////////////// |
63 |
|
|
78 |
|
|
79 |
|
|
80 |
|
|
81 |
// request.setAttribute("avg", avgBean); |
request.setAttribute("avg", avgBean); |
82 |
request.setAttribute("stats", stats); |
request.setAttribute("stats", stats); |
83 |
request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response); |
request.getRequestDispatcher("/savedstatistics.jsp").forward(request, response); |
84 |
|
|