QuestionAsk Questions?
Sujay Gandham
Using JSP and Jfreechart displays the chart fine on an internal browser in eclipse but doesnt display it on Chrome nor on Firefox. Chart.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page import="org.jfree.*" %>
<%@page import="org.jfree.chart.axis.CategoryAxis" %>
<%@page import="org.jfree.chart.plot.CategoryPlot" %>
<%@page import="org.jfree.chart.axis.NumberAxis" %>
<%@page import="java.awt.BasicStroke" %>
<%@page import="java.awt.Color" %>
<%@page import="java.awt.Polygon" %>
<%@page import="java.awt.Shape" %>
<%@page import="java.awt.geom.Rectangle2D" %>
<%@page import="org.jfree.chart.renderer.category.CategoryItemRenderer" %>
<%@page import="org.jfree.chart.renderer.category.LineAndShapeRenderer" %>
<%@page import="org.jfree.chart.plot.DefaultDrawingSupplier" %>
<%@page import ="org.jfree.chart.plot.DrawingSupplier" %>
<%@ page import="org.jfree.chart.ChartFactory" %>
<%@ page import="org.jfree.chart.ChartUtilities" %>
<%@ page import="org.jfree.chart.JFreeChart" %>
<%@ page import="org.jfree.chart.*" %>
<%@ page import="javax.swing.JFrame" %>
<%@ page import="org.jfree.chart.plot.PlotOrientation"%>
<%@ page import="org.jfree.data.*" %>
<%@ page import="java.awt.image.*" %>
<%@ page import="org.jfree.data.jdbc.JDBCCategoryDataset"%>
<%@page import="java.awt.Paint" %>
<%@page import="org.jfree.chart.title.LegendTitle" %>
<%@page import="org.jfree.chart.block.LabelBlock" %>
<%@page import="java.awt.GradientPaint" %>
<%
int value=Integer.parseInt(request.getParameter("q"));
String query="select dateof,dayinprice,company from stockprice where stockid="+value+" ORDER BY dateof";
JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:odbc:login","sun.jdbc.odbc.JdbcOdbcDriver","root","root");
dataset.executeQuery(query);
JFreeChart chart = ChartFactory.createLineChart("Company","date","Day In Price",dataset,PlotOrientation.VERTICAL, true, true, false);
//chart.setBackgroundPaint(Color.black);
Paint p = new GradientPaint(0,0, Color.white, 1000,0, new Color(0,106,78));
chart.setBackgroundPaint(p);
CategoryPlot plot= chart.getCategoryPlot();
plot.setBackgroundPaint(Color.white);
plot.setRangeGridlinePaint(Color.black);
CategoryItemRenderer cir = plot.getRenderer();
cir.setSeriesPaint(0,new Color(0,106,78));
LineAndShapeRenderer renderer = (LineAndShapeRenderer)plot.getRenderer();
renderer.setShapesVisible(true);
renderer.setUseFillPaint(false);
renderer.setFillPaint(new Color(0,106,78));
renderer.setStroke(new BasicStroke(2f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL));
try
{
ChartUtilities.saveChartAsJPEG(new File("C:/chart.jpg"), chart, 800, 500);
out.println("<img src=\"C:\\chart.jpg \"></img>");
}
catch (IOException e)
{
System.out.println("Problem in creating chart.");
}
%>
Stock1.jsp
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>CHART</title>
<script type="text/javascript">
function showCustomer(str)
{
var currentTime = new Date();
var d=currentTime.getMilliseconds();
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("im").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","chart.jsp?q="+str+"&d="+d,true);
xmlhttp.send();
}
</script>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:login");
Statement st=con.createStatement();
String str="select * from stock";
ResultSet rs=st.executeQuery(str);
%>
<form>
Choose Quote: <select name="stocksel" onclick="showCustomer(this.value)">
<%while(rs.next())
{
%>
<option value="<%=rs.getString("stockid")%>"><%=rs.getString("stockname")%></option>
<%
}
rs.close();
con.close();
%>
</select>
</form>
<br />
<div id="im" ></div>
</body>
</html>
View Answers
April 17, 2012 at 10:16 PM
Pls Help!!!
Related Pages:
