Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(QueryLine); columns=(rs.getMetaData()).getColumnCount(); column = new String[columns]; // Initialize the columns to be blank for(pos=1; pos<=columns; pos++) { column[pos-1]=""; } more=rs.next(); while(more) { for (pos=1; pos<=columns; pos++) { column[pos-1]+=(rs.getString(pos)); } more=rs.next(); for (pos=1; pos<=columns; pos++) { if(more) { column[pos-1]+=(","); } } } stmt.close(); } catch( Exception e ) { e.printStackTrace(); System.out.println(e.getMessage()); } return column; } That s it! We ve successfully queried a database, formatted the resulting data, and created a bar chart to present a visual representation of the results. Listing 7.5 shows the generation of a pie chart, and Figure 7.2 shows the pie chart applet. Figure 7.2 The pie chart applet. Listing 7.5 Dynamically generating a pie chart from a database query. /* Example 7-2: Pie chart
The European settlement at Melbourne was founded in 1835 by settlers coming from Tasmania (then known as Van Die men’s Land), where they had difficulty finding available land.We provides affordable, discount and cheapest Melbourne web hosting, free domain name, unlimited data transfer, unlimited emails, PHP, ASP, and database hosting,check Web Hosting Melbourne services.