@throws java.sql.SQLException
*************************************/
private Data getDataFromResultSet(ResultSet rs) throws SQLException
{
ResultSetMetaData meta;
Data data=new Data();
meta=rs.getMetaData();
int numColumns = meta.getColumnCount();
String[] dbCols=new String[numColumns];
for(int count = 1;count<=numColumns;count++)
{
dbCols[count-1]=meta.getColumnName(count);
data.addHeader(dbCols[count-1]);
}
while(rs.next())
{
data.next();
for(int count = 0;count<numColumns;count++)
{
Object o=rs.getObject(count+1);
end = System.currentTimeMillis();
time += end - start;
data.addColumnValue(dbCols[count],o);
start = System.currentTimeMillis();
}
}
return data;
}// end method