Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet Charts in JSP
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Ragavendran
Charts in JSP
1 Answer(s)      4 years and 10 months ago
Posted in : JSP-Servlet


Hi,

Thanks for replying for the chart query I made 2 days back.. Can u plz provide me an example for creating a series bar chart with the datas coming from the database? Series chart in the sense, If I have x axis as months(Jan, Feb, Mar,.......) and y axis some values say.. For january month itself, there must be three comparisions say one showing the population, other showing the commodity prices and other showing the temperature.. These three has to be differentiated with 3 different colors.. Like wise for all the months....

Plz reply asap...

Regards,
ragav..

Advertisement
View Answers

February 25, 2010 at 11:23 AM


Hi Friend,

Try the following code:

<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%@page import="org.jfree.chart.*"%>
<%@page import="org.jfree.chart.plot.*"%>
<%@page import="org.jfree.data.category.*"%>
<%
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from barchart");
while(rs.next()){
dataset.addValue(Double.parseDouble(rs.getString(1)), "Population", rs.getString(4));
dataset.addValue(Double.parseDouble(rs.getString(2)), "Prices", rs.getString(4));
dataset.addValue(Double.parseDouble(rs.getString(2)), "Temperature", rs.getString(4));
}
JFreeChart chart = ChartFactory.createBarChart(
"Bar Chart ",
"Months",
"Value",
dataset,
PlotOrientation.VERTICAL,
true,
true,
false
);
String f="C:/chart.jpg";
ChartUtilities.saveChartAsJPEG(new File(f), chart, 600, 300);
}
catch(Exception e){}
%>

Thanks


Related Tutorials/Questions & Answers:
generate charts using JSP
generate charts using JSP  any one know coding for generate bar chart or pie chart using JSP
java bar charts and jsp
java bar charts and jsp  Hi, Can any one help me out in how to create java bar charts using jsp with the help of data base table values? thanks.../jsp/draw-statistical-chart-jsp.shtml
Advertisements
java charts - JSP-Servlet
java charts  Hi,can any one tell me how to create dyanamic charts wrt database contents by using jsp-servlet
Bar charts and jsp
Bar charts and jsp  Hi, How to generate Dynamic Bar Chart Images using jsp with placing any image location in weebroots? Thanks in advance
Charts in JSP - JSP-Servlet
of charts in JSP.. So, Can i know the pre requirement for that? Do i need...Charts in JSP  Hi Roseindia team, This is ragav.. I... the following link: http://www.roseindia.net/jsp/draw-statistical-chart
Doubt regarding charts and jsp
Doubt regarding charts and jsp  Hi, I successfully executed... in web application(jsp). So,please help me out in how to connect the normal java application output to an jsp page? thanks in advance   Put the jar
Charts in JSP - JSP-Servlet
Charts in JSP  Hi, Thanks for replying for the chart query I made 2 days back.. Can u plz provide me an example for creating a series bar chart with the datas coming from the database? Series chart in the sense, If I have x
Doubt regarding charts and jsp
Doubt regarding charts and jsp  Hi in the http://www.roseindia.net/chartgraphs/barchart-jsppage.shtml of the code (new StandardEntityCollection()); final File file1 = new File("../webapps/jspchart/web/barchart.png
Statistical charts in JSP - problem
Statistical charts in JSP - problem  hey! i get this error when i run... org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred... An error occurred at line: 11 in the jsp file: /BarChart.jsp
java with jsp and dynamic database retrival for bar charts
java with jsp and dynamic database retrival for bar charts  Hi, I am having a table name tablelogin,it consists of columns userid,logintime,sessionid,ip_address,logout. so,can any one help me out how to get the bar chart
java charts - Development process
java charts  Hi,i want to create charts wrt database by using jsp?please help me
flow charts
flow charts   draw a flow chart program with a user prompt of 5 numbers computing the maximum, minimum and average
jree charts
jree charts  i have to use jfree charts how to download its api and where to keep it in jdk order to execute   Please visit the following link: Download JFreechart Download jfreechart-1.0.13.zip from the given link
fusion charts
fusion charts  hi i have to use the fusion chart. i don't know how to use and code in jsp and i have to create the chart by using the data from db. please help me doing that with exapmles. thank you
How to create charts in Java?
How to create charts in Java?  Is there any example of creating charts and graphs in Java? thanks   Hi, check the tutorial: Chart & Graphs Tutorials in Java Thanks
Doubt Regarding Charts
Doubt Regarding Charts  Hi, Can you please help me out by answering "hoe to include charts in core java code and struts code" thanks in advance... charts and graphs
Merge XYLine and XYArea Charts
Merge XYLine and XYArea Charts  I wonder how to merge two charts... (this website) how to use two XYLine Charts and display them. Please, see screenshot... appreciate any help. Please, bear in mind I am new to charts plotting in java
Good Looking Java Charts and Graphs
Good Looking Java Charts and Graphs  Is there a java chart library that will generate charts and graphs with the quality of visifire or fusion charts? The JFreeChart graph quality is not professional looking. Unless it can
Introduction to Graphs and Charts
Introduction to Graphs and Charts       Why Charts and Graphs?  Graphs and Charts is the most efficient method for displaying information in a simple manner
Types of Graphs and Charts
Types of Graphs and Charts   ... the different charts invented and being used for representing the data in various formats in the applications. These charts helps the developers to easily
jsp code - JSP-Servlet
jsp code  I need code for bar charts using jsp. I searched some code but they are contain some of their own packages. Please give me asimple code for bar charts and what are the topics required for that charts.  Hi
How to export chart(graph) generated by jsp into a excel?
How to export chart(graph) generated by jsp into a excel?  How to export chart(graph) generated by jsp into a excel? I have a jsp page which generates charts . Now I need those charts to be exported into an excel.please help
Draw Statistical chart in jsp
Draw Statistical chart in jsp   ... chart in jsp by getting values from database.. To draw a bar chart, we have... variety of charts. Download jar file: jfreechart.jar and jcommon.jar Create
Flex with JSP
Flex with JSP  i want to draw chart in jsp page using flex. how can i do that? any solution??   Flex charts You can visit the following links: http://www.roseindia.net/tutorial/flex/flex4/components/charteffect.html
Bar Chart in JSP - JSP-Servlet
Bar Chart in JSP  Hi I am creating Bar chart using Jfree charts in JSP. Please advise me how to customize it. Like controlling the colors, width for each bar, showing values above the bar .  hi friend, Use
Create multiple pie chart in single frame using JFreeChart
you how to create a multiple pie charts in a single frame in jsp page using JFreeChart. Code given below creates a simple pie charts for given values.../Q", data);  final JFreeChart chart = 
regarding images in jsp
regarding images in jsp  Hi, When I am trying to display an image in jsp, i am getting the image of bar charts in webroots/jspchart/web/jspbarchart.jsp.. But actually I am not getting any image in the browser.. Can any one help
 

 

 

DMCA.com