In this section, you will learn how to create a x-y line graph by retrieving the values from the database.
In this section, you will learn how to create a x-y line graph by retrieving the values from the database.JFreeChart library has made programming very easy. Using its classes and their methods, you can create various charts. It also provides a way to create a chart with the values that has been retrieved from the database. In this section, you will learn how to create a x-y line graph by retrieving the values from the database.
Here is the code:
import java.sql.*; import java.io.*; import org.jfree.ui.*; import org.jfree.chart.ChartPanel; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartUtilities; import org.jfree.chart.JFreeChart; import org.jfree.chart.plot.PlotOrientation; import org.jfree.data.*; import org.jfree.data.jdbc.JDBCCategoryDataset; public class Chart { public static void main(String[] args) throws Exception { String query = "SELECT * from chart"; JDBCCategoryDataset dataset = new JDBCCategoryDataset( "jdbc:mysql://localhost:3306/test", "com.mysql.jdbc.Driver", "root", "root"); dataset.executeQuery(query); JFreeChart chart = ChartFactory.createLineChart("Test", "Id", "Score", dataset, PlotOrientation.VERTICAL, true, true, false); ChartPanel chartPanel = new ChartPanel(chart); chartPanel.setPreferredSize(new java.awt.Dimension(500, 270)); ApplicationFrame f = new ApplicationFrame("Chart"); f.setContentPane(chartPanel); f.pack(); f.setVisible(true); } }
Output: