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 |