int columns, pos; String column[]=new String[4]; // We have to initialize the column String variable even though we re- // declare it below. The reason is because the declaration below is in a // try{} statement, and the compiler will complain that the variable may // not be initialized. boolean more; try { Statement stmt = con.createStatement(); // Create a Statement object from the // Connection.createStatement method. ResultSet rs = stmt.executeQuery(QueryLine); // Execute the passed in query, and get // the ResultSet for the query. columns=(rs.getMetaData()).getColumnCount(); // Get the number of columns in the resulting table so we can // declare the column String array, and so we can loop // through the results and retrieve them. column = new String[columns]; // Create the column variable to be the exact number of // columns that are in the result table. // Initialize the column array to be blank since we’ll be adding // directly to them later. for(pos=1; pos<=columns; pos++) { column[pos-1]=""; } more=rs.next(); // Get the first row of the ResultSet. Loop through the ResultSet // and get the data, row-by-row, column-by-column. while(more) { for (pos=1; pos<=columns; pos++) { column[pos-1]+=(rs.getString(pos)); // Add each column to the respective column[] String array. } more=rs.next(); // Get the next row of the result if it exists. // Now add a comma to each array element to delimit this row is // done. for (pos=1; pos<=columns; pos++) { if(more) { // We only want to do this if this isn't the last row of the // table! column[pos-1]+=(",");
Here java web hosting you will find professional-grade java web hosting at affordable prices.