|
From: Nathaniel G. A. <nat...@ya...> - 2004-06-18 18:05:50
|
Singha,
If you are looking for the quickest response, do not email me or any of the project committers
directly; you should email the Users mail list. I will not answer emails directed at me
personally in the future. What if i am on vacation or unreachable for a period of time?
I am not sure I understand your problem.
--- Singha Amit <ks...@ho...> wrote:
> Sir,
>
> I am using jCharts in my intranet application, i am using JDBC connection to
> extract data from database, but not able to assign values dynamically, can
> you please help me, sending you the sample code:
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> connection=DriverManager.getConnection("jdbc:odbc:TEST","amit","nivedita
> );
> statement=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE
> ResultSet.CONCUR_READ_ONLY);
> ResultSet rs;
> int count=0;
> rs=statement.executeQuery("SELECT * FROM SALES");
>
> rs.last();
>
> int MAX_ROW=rs.getRow;
>
> System.out.println(MAX_ROW);
> String a=null;
> String b=null;
>
> String[] xAxisLabels=new String[MAX_ROW];
> double[][] data=new double[MAX_ROW][MAX_ROW];
>
> while(count<=MAX_ROW)
> {
> xAxisLabels[count]=rs.getString[1];
> data[count][count]=rs.getDouble[2];
> count++;
> }
>
> thanx
> amit
>
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
|