Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%
- try{
- DefaultPieDataset data = new DefaultPieDataset();
- while(rs.next()){
- data.setValue(rs.getString("marca"), rs.getInt("TOTAL"));
- }
- JFreeChart grafico = ChartFactory.createPieChart("Cantidad Productos", data, true, true, true);
- response.setContentType("image/JPEG");
- OutputStream sa = response.getOutputStream();
- ChartUtilities.writeChartAsJPEG(sa, grafico, 600,600 );
- }catch(Exception ex){
- }
- %>
- <%
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/producto","root","123");
- Statement cmd= cn.createStatement();
- String sql = "SELECT MARCA, SUM(CANTIDAD) AS TOTAL FROM PRODUCTO_CANTIDAD GROUP BY MARCA";
- ResultSet rs = cmd.executeQuery(sql);
- %>[![inserir a descrição da imagem aqui][2]][2]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement