PieChart/BarGraph

PieChart/BarGraph

Hii..i have developed an application and i want to display the values from the database in the piechart/barchart but the problem is that it is taking only 5 values from database and i have 10 values in it.how to display all values. plzz help..itz urgent.. my code is:

try {

            DefaultCategoryDataset dataset = new DefaultCategoryDataset();
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            Connection conn = DriverManager.getConnection("jdbc:odbc:LeadManagementSystem", "", "");
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery("SELECT * from ProjectDetails");
            while (rs.next()) {
                dataset.setValue(rs.getInt("NoOfLeads"), "NoOfLeads", rs.getString("ProjectName"));
            }
            JFreeChart chart = ChartFactory.createBarChart3D("LEAD REPORT (PROJECT)", "Project Name", "Leads",
                    dataset, PlotOrientation.VERTICAL, true, true, false);
            chart.setBackgroundPaint(Color.yellow);
            chart.getTitle().setPaint(Color.blue);
            CategoryPlot p = chart.getCategoryPlot();
            p.setRangeGridlinePaint(Color.red);
            ChartPanel chartPanel = new ChartPanel(chart);
            chartPanel.setPreferredSize(new java.awt.Dimension(500, 270));
            ApplicationFrame f = new ApplicationFrame("AllocationDB");
            f.setContentPane(chartPanel);
            f.pack();
            f.setVisible(true);
            try {
                ChartUtilities.saveChartAsJPEG(new File("C:/chart1.jpg"),
                        chart, 400, 300);
            } catch (IOException e) {
                System.out.println("Problem in creating chart.");
            }
        } catch (Exception e) {
        }
View Answers









Related Tutorials/Questions & Answers:
PieChart/BarGraph
PieChart/BarGraph  Hii..i have developed an application and i want to display the values from the database in the piechart/barchart but the problem is that it is taking only 5 values from database and i have 10 values in it.how

Ads