Part III: JFreeChart “Gantt” schedule

4 thoughts to “Part III: JFreeChart “Gantt” schedule”

1. Hi,
   How the same can be done on a jsp with the values from a database
   i will send my part of pgm please check that and suggest what all changes has to made
   in the action class
   if(action.trim().equalsIgnoreCase(“chart”))
   {
   DsChart dsChart=new DsChart();
   dsChart=bpp.getDataFromTable(fetchCompany, fetchStore,Integer.parseInt(month),Integer.parseInt(year));
   dsChart.setTitle(ap.getStoreName(storead));
   dsChart.setSubTitle(reportType);
   request.setAttribute(“chart”,dsChart);
   return mapping.findForward(“chart”);
   }

   in the persistence

   /for graph month range starts
   public DsChart getDataFromTable(String company,String store,int month,int year,int endmonth,int endyear){

   Connection con=null;
   PreparedStatement pst=null;
   ResultSet rs=null;
   DsChart dsChart=new DsChart();
   List li=new ArrayList();
   SimpleDateFormat format=new SimpleDateFormat(“yyyy-MM-dd”);
   SimpleDateFormat twoDigitYear=new SimpleDateFormat(“yy-MMM”);
   SimpleDateFormat monthOnly=new SimpleDateFormat(“MMM”);
   ArrayList ret=new ArrayList();
   int start=1;
   try
   {
   Calendar cal1 = Calendar.getInstance();
   Calendar cal2 = Calendar.getInstance();
   cal1.set(year, month, 01);
   cal2.set(endyear, endmonth,01);

   con=DBConnection.getConnection();
   String select=”SELECT l.receiver_date as rdate,sum(l.raw_PO_Cost) as amt,sum(l.Qty_receieved) as itmsol FROM line_item_rece_voucher l,itemmasterstore i where l.Company=i.Company and l.Store=i.Store and l.Item=i.PluId and l.Company=? and l.Store=? and l.receiver_date between ? and ? and i.DepartmentId in(SELECT Dept_Id FROM dep d where d.Category_Id=400 and d.Company=l.company and d.Store=l.store) group by month(l.receiver_date)”;
   pst=con.prepareStatement(select);
   pst.setString(1, company);
   pst.setString(2, store);
   for(Calendar c = cal1;c.compareTo(cal2)<= 0;c.add(Calendar.MONTH,1))
   {
   c.set(Calendar.DAY_OF_MONTH, c.getActualMinimum(Calendar.DAY_OF_MONTH));
   pst.setString(3, format.format(c.getTime()));
   c.set(Calendar.DAY_OF_MONTH, c.getActualMaximum(Calendar.DAY_OF_MONTH));
   pst.setString(4, format.format(c.getTime()));
   rs=pst.executeQuery();
   if(rs.next()){

   ret.add(new DsChartEntity(start, "Volume", Double.parseDouble(rs.getString(3)),"Volume[ "+rs.getString(1)+" , "+Double.parseDouble(rs.getString(3))+" ]"));
   ret.add(new DsChartEntity(start, "Amount", Double.parseDouble(rs.getString(2)),"Volume[ "+rs.getString(1)+" , "+Double.parseDouble(rs.getString(2))+" ]"));
   start++;
   }
   else{
   ret.add(new DsChartEntity(start, "Volume", 0.00,"Volume[ "+format.format(c.getTime())+" , "+0.00+" ]"));
   ret.add(new DsChartEntity(start, "Amount", 0.00,"Volume[ "+format.format(c.getTime())+" , "+0.00+" ]"));
   start++;
   }

   li.add(((year!=endyear)?twoDigitYear.format(c.getTime()):monthOnly.format(c.getTime())));
   }

   List displayInfo=new ArrayList();
   dsChart.setXAxisStartValue(1);
   dsChart.setXAxisEndValue(start-1);
   dsChart.setData(ret);
   dsChart.setShowCustomToolTip(true);
   dsChart.setTitle(“DataSoftNet”);
   dsChart.setSubTitle(“Beer Purchase Chart”);
   dsChart.setWidth(1094);//219 + 875
   dsChart.setHeight(719);//94 + 625
   dsChart.setXAxisTitle(“”);
   dsChart.setYAxistitle(“”);
   dsChart.setAction(“#”);
   dsChart.setXLabelList(li);
   dsChart.setDisplayInfo(displayInfo);
   }
   catch(Exception e)
   {
   System.out.println(“An Exception occured at BeerPurchasePersistence.getDataFromTableMonthrange”+e);
   }
   finally{
   try {

   rs.close();
   pst.close();
   con.close();
   } catch (SQLException e) {
   System.out.println(“An Exception occured in connection”);
   }
   }

   return dsChart;
   }
   //for graph month range ends

   Log in to Reply

2. Hi,
   How to add string description onto the bar?
   best regards

   Log in to Reply

3. Hello ,

   very good tutorial ! But for me it is a little bit unclear how you added the text to the bars in the second example (the blue bars) ?
   Can you give a short explanation/sample on howto add labels/text to those bars and how to change the colors ?

   Sorry I am not that familiar with JFreecharts.

   Cu

   Schoby

   Log in to Reply

4. how to add label/values inside the bar’s (not top of the bar). could please explain me.
   am new to jfreechart.

   Log in to Reply