gantt charts

Ads

 
 
 

Share on Google+Share on Google+

amrutha
gantt charts
1 Answer(s)      8 years ago
Posted in : Java Beginners
Ads
View Answers

May 18, 2009 at 1:38 PM


Hi Friend,

Take 3 fields in your database table, task,date1,date2 whose data types are varchar, date and date respectively.

Now try the following code:

import java.awt.Color;
import java.util.Date;
import java.util.Calendar;
import org.jfree.ui.ApplicationFrame;
import org.jfree.ui.RefineryUtilities;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.*;
import org.jfree.chart.JFreeChart;
import org.jfree.data.category.IntervalCategoryDataset;
import org.jfree.data.gantt.Task;
import org.jfree.data.gantt.TaskSeries;
import org.jfree.data.gantt.TaskSeriesCollection;
import org.jfree.data.time.SimpleTimePeriod;
import java.sql.*;

public class GanttChartExample {

public static void main( String[] args) {
JFreeChart chart=null ;
TaskSeries schedule1 = new TaskSeries("Scheduled Tasks");
TaskSeries schedule2 = new TaskSeries("Actual Done");
Connection con = null;
String url = "jdbc:mysql://192.168.10.112:3306/";;
String db = "mysql";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM chart");
while (rs.next()) {
schedule1.add(new Task(rs.getString(1), new SimpleTimePeriod((rs.getDate(2)),(rs.getDate(3)))));

schedule2.add(new Task(rs.getString(1), new SimpleTimePeriod((rs.getDate(2)), (rs.getDate(2)))));
TaskSeriesCollection collection = new TaskSeriesCollection();
collection.add(schedule1);
collection.add(schedule2);
IntervalCategoryDataset dataset= collection;

chart = ChartFactory.createGanttChart(
"Gantt Chart Example",
"Task",
"Date",
dataset,
true,
true,
false
);
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
chart.setBackgroundPaint(new Color(0xff,0xff,0xcc));
ChartFrame frame=new ChartFrame("Gantt Chart",chart);
frame.setVisible(true);
frame.setSize(400,350);
}
}
Thanks

Ads









Related Tutorials/Questions & Answers:
gantt charts - Swing AWT
gantt charts  Hello, i am doing project on project management tool there i need to generate a gantt chart for daily activity done by developer regarding how many hours they have spent for each activity. If the database contains
gantt charts - Java Beginners
gantt charts  Actually while generating the gantt chart it has...( "Gantt Chart Example", "Task", "Date...)); ChartFrame frame=new ChartFrame("Gantt Chart",chart); frame.setVisible
Advertisements
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
Regarding Gantt chart generation - Java Beginners
Regarding Gantt chart generation  how to generate a jdbc gantt chart..., To create a simple Gantt chart, try the following code: import...; JFreeChart chart = ChartFactory.createGanttChart( "Gantt Chart
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
generate charts using JSP
generate charts using JSP  any one know coding for generate bar chart or pie chart using JSP
java charts - Development process
java charts  Hi,i want to create charts wrt database by using jsp?please help me
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
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 in advance   Have a look at the given link: http://www.roseindia.net
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
java charts - JSP-Servlet
java charts  Hi,can any one tell me how to create dyanamic charts wrt database contents by using jsp-servlet
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
Charts in JSP - JSP-Servlet
Charts in JSP  Hi Roseindia team, This is ragav.. I am currently in a project where i must display the database results in terms of charts in JSP.. So, Can i know the pre requirement for that? Do i need
Doubt regarding charts and jsp
Doubt regarding charts and jsp  Hi, I successfully executed the bar chart in normal java application. But I want the Bar Chart to be executed in web application(jsp). So,please help me out in how to connect the normal
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
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
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
Statistical charts in JSP - problem
Statistical charts in JSP - problem  hey! i get this error when i run the code (with slight changes in query)! HTTP Status 500 - type Exception report message description The server encountered an internal error
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
jaret timebars
containing rows of intervals. The viewer displays the intervals in a Gantt chart... (classic gantt) and vertical orientation addon package supports using
Chart & Graphs Tutorials in Java
, Bar Charts, Bubble Charts, Gantt Charts. Developers get a better choice to add...;     Best collection of Graphs and Charts Tutorials... to Charts & Graphs Graphs and Charts is the most efficient method
Draw Statistical chart in jsp
variety of charts. Download jar file: jfreechart.jar and jcommon.jar Create... the utility methods for creating charts. The method createBarChart3D() creates... methods for converting charts to image formats (PNG and JPEG). The method
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 = 
Eclipse Trader
pricing watch, intraday and history charts with technical analysis indicators, level... Intraday Charts History Charts Technical Analisys Indicators Price Patterns
Draw Pie Chart
Charts in Java. This Java Pie Chart example is drawing a pie chart to show...: g2.draw(new Line2D.Double(cp, cq, p, q)) The angle... + (9*pie/24) * Math.cos(theta + phi/2); q = cq + (9*pie/24
Tutorials   
Java Spring Hibernate Struts Training ClassNotFoundException HttpRequestInterceptor java.lang.noclassdeffounderror: org/apache/http/httprequest noclassdeffounderror: org/apache/http/client/methods/httpurirequest java.lang.NoClassDefFoundError: org/apache/http/client/HttpClient How do I resolve this Java Class not found exception? httpclient java.lang.NoClassDefFoundError Apache Commons ioutils maven dependency Read/Convert an inputStream to a String What is the meaning of Java Platform? Why Java is a platform independent language? What is the benefits of learning Core Java? Which technology should I learn after Java? What is array in java with example? How to Convert ArrayList to Array? How to substring in Java? How to format number in Java? What is instance variable in Java? How to download MySQL JDBC driver? What is Calendar class in Java? Which is the best Java tutorials for beginners? How to rename a file in Java? How to delete file in Java code? How to get day from date in Java using Calendar? How to get day of week in Java? How to calculate Date Difference in Java? How to compare date in Java? How to declare array in Java? How to calculate average of array in Java? What is Array in Java? write a java program to find the summation of all the integers entered on command line Sum of two numbers using command line arguments in Java How to create and use Array in Java? How to pass command line arguments in Java? How to create Applet Hello World? Appending String efficiently in Java How to append String in Java? How to list even numbers between 1 and 100? How to add BigDecimal in Java? What is Abstraction In Java? Which is best Beginners Java Tutorial? What is java.util package? Create list from array in Java Filter collection in Java 8 What is the best way to filter a Java Collection? Easy way to transform Collection to Array? How to convert Collection to Array in Java? What are Basic Java Language Elements? Advanced Java Tutorials in 2017 Java brief history Best Reasons to learn Java

Ads

 
Advertisement null

Ads