In this section, we will show you how to use FusionCharts and JSP to plot charts from data contained in a database. Here, we will do the following:
Create a pie chart to show "Production by Factory" by initially using the dataStr method first.
TConvert the chart to use the dataURL method.
Next, we will create a multi-series line chart from database.
For the sake of ease, we will use MySQL Database. The database is present in Download Package > Code > J2EE > DB folder. You can, however, use any database with FusionCharts including MS Access, MySQL, MS SQL, Oracle. Database creation script for MySQL is also present in the same folder.