Advertisement
Guest User

Untitled

a guest
Oct 18th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. <%
  2.  
  3. try{
  4. DefaultPieDataset data = new DefaultPieDataset();
  5. while(rs.next()){
  6. data.setValue(rs.getString("marca"), rs.getInt("TOTAL"));
  7. }
  8.  
  9. JFreeChart grafico = ChartFactory.createPieChart("Cantidad Productos", data, true, true, true);
  10.  
  11. response.setContentType("image/JPEG");
  12. OutputStream sa = response.getOutputStream();
  13.  
  14. ChartUtilities.writeChartAsJPEG(sa, grafico, 600,600 );
  15.  
  16. }catch(Exception ex){
  17. }
  18. %>
  19.  
  20. <%
  21. Class.forName("com.mysql.jdbc.Driver").newInstance();
  22. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/producto","root","123");
  23. Statement cmd= cn.createStatement();
  24. String sql = "SELECT MARCA, SUM(CANTIDAD) AS TOTAL FROM PRODUCTO_CANTIDAD GROUP BY MARCA";
  25. ResultSet rs = cmd.executeQuery(sql);
  26.  
  27.  
  28. %>[![inserir a descrição da imagem aqui][2]][2]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement