Hi,

I am am looking for and help in getting multi line chart with Jfree chart, i had manage to write a singe line chart but i need multy line can you please help.

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%@ page import="java.io.*"%>

<%@ page import="java.awt.*" %>

<%@ page import="java.io.*" %>

<%@ page import="java.sql.*" %>

<%@ page import="org.jfree.data.jdbc.JDBCPieDataset" %>

<%@ page import="org.jfree.chart.plot.PlotOrientation" %>

<%@ page import="org.jfree.chart.JFreeChart" %>

<%@ page import="org.jfree.chart.ChartUtilities" %>

<%@ page import="org.jfree.chart.ChartFactory" %>

<%@ page import="org.jfree.data.general.DefaultPieDataset" %>

<%@ page import="org.jfree.chart.*"%>

<%@ page import="org.jfree.chart.entity.*"%>

<%@ page import="org.jfree.data.general.*"%>

<%@ page import="org.jfree.chart.plot.PiePlot" %>

<%@ page import="org.jfree.data.jdbc.JDBCCategoryDataset"%>

<%@page import="org.jfree.chart.plot.CategoryPlot"%>

<%@page import="org.jfree.chart.plot.XYPlot"%> <%@page import="org.jfree.data.xy.XYDataset"%> ?

<%

String query="select Time, mem_free from server_status where server_name like 'z2bizadmin01.zlt'";

JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:mysql://localhost/server_info", "com.mysql.jdbc.Driver","root", "optus123");

dataset.executeQuery(query);


//(final XYDataset dataset){
final JFreeChart chart = ChartFactory.createLineChart("zlt Admin server memory status", "Time", "MEM Free", dataset, PlotOrientation.VERTICAL, true, true, false);

final CategoryPlot plot = (CategoryPlot) chart.getPlot();

plot.setBackgroundPaint(Color.white);

try

{

    final ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());

    final File file1 = new File(getServletContext().getRealPath(".") + "/linechart.png");

    ChartUtilities.saveChartAsPNG(file1, chart, 1000, 800, info);

} catch (Exception e) {

System.out.println(e);

}

%>

<h1>Hello World!</h1>

<IMG SRC="linechart.png" WIDTH="1500" HEIGHT="500" style="border:4px solid orange;" USEMAP="#chart" alt="image">