JavaBeans - An Introduction to Network Programming with Java - page 324

{
int colType = metaData.getColumnType(i);
switch (colType)
{
case Types.INTEGER:
queryResults.add(results.getInt(i));
dataTypes.add("integer");
break;
case Types.VARCHAR:
queryResults.add(
results.getString(i));
dataTypes.add("string");
break;
case Types.NUMERIC:
queryResults.add(
results.getFloat(i));
dataTypes.add("fl oat");
break;
default: //Hopefully, will never happen!
queryResults.add(
results.getString(i));
dataTypes.add("string");
}
}
}
return queryResults;
}