1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
public class Compare extends HttpServlet {
/**
*
*/int i=0;
private static final long serialVersionUID = 1L;
@SuppressWarnings("deprecation")
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException {
response.setContentType("image/png");
connexionBD con = new connexionBD();
ResultSet rs = con.execute("select table.heure,table.ftp,table2.ftp,table3.ftp from table,table2,table3 where (table.date=left(now(),10)) order by heure;");
final TimeSeries series = new TimeSeries("Débit 1", Minute.class);
final TimeSeries series1 = new TimeSeries("Débit 2", Minute.class);
final TimeSeries series2 = new TimeSeries("Débit 3", Minute.class);
while(rs.next()){
Timestamp v1;
v1 = rs.getTimestamp("heure");
double v2=rs.getDouble("table.ftp");
double v3=rs.getDouble("table2.ftp");
double v4=rs.getDouble("table3.ftp");
series.addOrUpdate( new Minute(v1), v2);
series1.addOrUpdate( new Minute(v1), v3);
series2.addOrUpdate( new Minute(v1), v4);
}
rs.close();
DateAxis domain = new DateAxis("Time");
NumberAxis range = new NumberAxis("Débit en Ko/s");
final TimeSeriesCollection dataset = new TimeSeriesCollection(series);
dataset.addSeries(series1);
dataset.addSeries(series2);
XYItemRenderer renderer = new XYLineAndShapeRenderer(true, false);
renderer.setSeriesPaint(0, Color.green);
renderer.setSeriesPaint(2, Color.red);
XYPlot plot = new XYPlot(dataset, domain, range, renderer);
plot.setBackgroundPaint(Color.lightGray);
plot.setDomainGridlinePaint(Color.white);
plot.setRangeGridlinePaint(Color.white);
plot.setAxisOffset(new RectangleInsets(5.0, 5.0, 5.0, 5.0));
range.setAutoRange(true);
range.setLowerMargin(0.0);
range.setUpperMargin(0.0);
range.setTickLabelsVisible(true);
range.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
JFreeChart chart = new JFreeChart(plot);
chart.setTitle(new TextTitle("Comparaison du débit ftp"));
XYItemRenderer r = plot.getRenderer();
if (r instanceof XYLineAndShapeRenderer) {
XYLineAndShapeRenderer renderer1 = (XYLineAndShapeRenderer) r;
renderer1.setBaseShapesVisible(true);
renderer1.setBaseShapesFilled(true);
}
final ChartPanel chartPanel = new ChartPanel(chart);
chartPanel.setPreferredSize(new java.awt.Dimension(600, 300));
chartPanel.setMouseZoomable(true, false);
OutputStream out = response.getOutputStream();
ChartUtilities.writeChartAsPNG(out, chart, 700, 500);
request.setAttribute("image",out);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} |
