Databases Reference
In-Depth Information
BigDecimal upc = rs.getBigDecimal(10);
int quantity = rs.getInt(11);
String description = rs.getString(12);
Clob longDescription = rs.getClob(13);
Blob thumbnailPicture = rs.getBlob(14);
Blob picture = rs.getBlob(15);
String otherOffers = rs.getString(16);
String rebateInfo = rs.getString(17);
BigDecimal userRating = rs.getBigDecimal(18);
}
rs.close ();
rs = null;
}
try
{
stmt.close ();
}
finally
{
stmt = null;
}
// Stop the timer and calculate/record the
// actual time elapsed and current CPU time
end = System.currentTimeMillis();
cpuEnd = tb.getCurrentThreadCpuTime();
ThreadInfo.actualTime = (end - start) / 1000.;
}
catch (SQLException e)
{
e.printStackTrace();
System.out.println ("Thread " + threadNumber +
" failed with " + e);
}
