Basic HTML version of Foils prepared May 19 99

Foil 12 Data from ResultSets

From Overview of JDBC: Java Database Connectivity Basic Information Track Computational Science Course CPS616 -- Spring Semester 1999. by Nancy McCracken,(Sangetta Aggarwal, Meryem Ispirli, Udayan Parvate, Tom Pulikal, Chao-Wei Ou)
JDBC use of SQL types for Foil 12
1 The getxxx methods, where xxx is a Java type, can take column labels or column position numbers for an argument. (findColumn ("label") can return column position.)
2 JDBC API contains a table telling which getxxx methods can be used with particular SQL types.
3 ResultSet.getMetaData returns a ResultSetMetaData object which gives the number, types and properties of the ResultSet object's columns.
4 Can use streams on LONG SQL types.
5 For optional or multiple ResultSets, there are methods getResultSet, getUpdateCount, and getMoreResults.
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Mon Jul 5 1999