How to display database values in JFreeChart linechart

Question

I have a question about a JFreeChart issue. I want to display a chart with a line from the values out of my database. This is the code I have now:

public void drawachart(){
    try{
        String sql= "select status,date from luggage";
        JDBCCategoryDataset dataset = new JDBCCategoryDataset(
            "jdbc:mysql://localhost/corendon", "com.mysql.jdbc.Driver", "root", "root");
        dataset.executeQuery(sql);
        JFreeChart chart = ChartFactory.createLineChart("chart","date", "status",
            dataset,PlotOrientation.VERTICAL,false,true,true);
        BarRenderer bar= null;
        bar = new BarRenderer();
        CategoryPlot plot =null;
        ChartFrame frame = new ChartFrame("shart", chart);
        frame.setVisible(true);
        frame.setSize(500, 500);
    }
    catch(Exception e){
        e.printStackTrace();
    }
}

After executing the code, it gives me a chart with no lines in it. Only a x and y axis. What should I do to get a line in the chart.

So is it working or not.Are you getting any error ?What is your question? — user2948112
– user2948112, Commented Dec 8, 2013 at 12:58
After executing the code it gives me a chart with no lines in it. Only a x and y axis. What should i do to get a line in the chart. — user3079825
– user3079825, Commented Dec 8, 2013 at 14:35

Community · Accepted Answer · 2017-05-23 11:49:44Z

1

Try JDBCXYDataset, mentioned here. Because "the first column will be the x-axis," change your query to "select date, status from luggage". JDBCXYDataset can detect a time series based on metadata, so ChartFactory.createTimeSeriesChart() may be a suitable choice.

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Dec 8, 2013 at 18:21

trashgod

206k33 gold badges264 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3079825 Over a year ago

I have tried, but i want the graph to select all the number 0s from my status column in the DB. I am getting a weird graph right now.

trashgod Over a year ago

You might also need to check for NULL, for example.

Collectives™ on Stack Overflow

How to display database values in JFreeChart linechart

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related