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
|
public class Serv extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException {
Connection con = new ConnexionBD().createCon();
String t= request.getParameter("dept");
if (t== null)
t="ACCOUNTING";
String sql ="select ename,sal from emp, dept where emp.deptno = dept.deptno AND dname ='"+t+"'";
Statement st= con.createStatement();
ResultSet res = st.executeQuery(sql);
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
String a ;
int b;
while(res.next()){
a= res.getString(1);
b=Integer.parseInt(res.getString(2));
dataset.setValue(b, "Number", a);
}
JFreeChart chart = ChartFactory.createBarChart("Employés par Location",
"Location", "Number", dataset, PlotOrientation.VERTICAL,
false, true, false);
ServletOutputStream out = response.getOutputStream();
response.setContentType("image/png");
ChartUtilities.writeChartAsPNG(out, chart, 400, 300);
out.close();
} |
Partager