Forum:

Other Open Source Projects

developing jsp page using cewolf

Greenhorn

Posts: 21

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi
I am a newbie to charts currently i am a developing a bar chart in jsp page with cewolf tag libraries but i am struggling with database connectivity i am using mssql in my system i do not know how to retrieve the code with cewolf can you please post me sample code how to connect with mssql.
Thanks in advance.

ujjwal soni

Ranch Hand

Posts: 405

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Welcome to javaranch

Here is the link for jdbc mysql which may help you...

http://www.developer.com/java/data/article.php/3417381

However, here is some code snippet that might help you.

import java.sql.*;

public class Connect
   {
       public static void main (String[] args)
       {
           Connection conn = null;

try
           {
               String userName = "root";
               String password = "testpass";
               String url = "jdbc:mysql://localhost/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
               System.out.println ("Database connection established");
           }
           catch (Exception e)
           {
               System.err.println ("Cannot connect to database server");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
       }
   }

Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"

vina kum

Greenhorn

Posts: 21

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi
Thanks for your response i have connected to mssql database but i am little bit confused how to retrieve dataset from database i am sending my code please help me how to retrieve data correctky

package com.cewolf;
import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;

import com.sellspace.util.DatabaseConnection;

import de.laures.cewolf.DatasetProducer;
import de.laures.cewolf.links.CategoryItemLinkGenerator;
public class piechart implements DatasetProducer,CategoryItemLinkGenerator, Serializable {
	 public Object produceDataset(Map params) {
		                  org.jfree.data.general.DefaultPieDataset ds = null;
		                 
		  String query=("select country,state from dbo.advertisementhits ");
		  try
			{
	  java.sql.Connection con = DatabaseConnection.getConnection();
	  Statement st = con.createStatement(); 
	  ResultSet rs = st.executeQuery(query);
	  while(rs.next())
	  {
       
	   ds.addValue(rs.getString(1));
	   ds.addValue(rs.getString(2));
       
	  }
	 // ds.setGroup(rs);
	  
			 } catch (SQLException se) {
				                         throw new RuntimeException(se);
				                  }
				                  return ds;
				          }

public String getProducerId() {
		                  return "PieDataProducer";
		          }
	 public boolean hasExpired(Map params, java.util.Date since) {
		                 return false;
		         }

}
	 
piechart.jsp file

<%@page contentType="text/html"%>
  <%@page import="org.jfree.data.*,com.sellspace.util.DatabaseConnection,com.cewolf.piechart"%>
  <%@page import="java.io.Serializable"%>
  <%@taglib uri='/WEB-INF/cewolf.tld' prefix='cewolf' %>
   
   
  
   <jsp:useBean id="pieChartView" class="com.cewolf.piechart"/>
   
  <html>
  <body>
 <table align="center" border="0" width="60%">
  <tr>
  <td colspan="2"><H2 ALIGN="CENTER">Pie Chart</H2></td>
  </tr>
  <tr>
  <td>    
  
  
  <cewolf:chart id="pieExample" type="pie" title="Employees Hired By Department" showlegend="true">
     <cewolf:data>
          <cewolf:producer id="pieChartView" />
    </cewolf:data>
     <cewolf:colorpaint color="#EEEEEF"/>
 </cewolf:chart>
 
  <cewolf:img chartid="pieExample" renderer="cewolf" border="0" width="350" height="350"/>
 </td>
 </tr>
 <table>
 
  </body>
 </html>

Thanks in advance.

ujjwal soni

Ranch Hand

Posts: 405

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

What is happening after you run your code ? Are you getting any exceptions ?

I will suggest you to have a look at the below hyperlink

http://www.vsj.co.uk/articles/display.asp?id=738

Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

It looks like the code is adding states and countries alternately to the Dataset. That doesn't make much sense - a pie chart consists of categories and values (which determine the size of the pie slice). What is it, exactly, that you want to show in the chart?
Here's an example of a pie chart Dataset producer:

vina kum

Greenhorn

Posts: 21

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi
when i run the code it is not displaying pie chart even not giving exception simply it is displaying arrow mark in the place of image in the jsp page.I think adding dataset object is the problem. Any suggestions will greatly welcome.

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

As I said, the code you posted doesn't do anything useful that would create a pie chart. Try the code I posted instead.

vina kum

Greenhorn

Posts: 21

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi
I have your code in import statement no problem with loading drivers.I have written the code by using cewolf tags.

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I can't tell from your last post if the problem is solved, or what exactly you tried and what the result of that was.