ResultSet's Methods to Access Columns by Index : Query ResultSet « Database « Java Tutorial

  1. String getString(int columnIndex);
  2. boolean getBoolean(int columnIndex);
  3. byte getByte(int columnIndex);
  4. short getShort(int columnIndex);
  5. int getInt(int columnIndex);
  6. long getLong(int columnIndex);
  7. float getFloat(int columnIndex);
  8. double getDouble(int columnIndex);
  9. byte[] getBytes(int columnIndex);
  10. java.sql.Date getDate(int columnIndex);
  11. java.sql.Date getDate(int columnIndex, java.util.Calendar cal);
  12. java.sql.Time getTime(int columnIndex);
  13. java.sql.Timestamp getTimestamp(int columnIndex);
  14. java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal);
  15. getAsciiStream(int columnIndex);
  16. getBinaryStream(int columnIndex);
  17. Object getObject(int columnIndex);
  18. Object getObject(int columnIndex, java.util.Map map);
  19. java.sql.Array getArray(int columnIndex);
  20. java.math.BigDecimal getBigDecimal(int columnIndex);
  21. java.sql.Blob getBlob(int columnIndex);
  22. java.sql.Clob getClob(int columnIndex);
  23. getCharacterStream(int columnIndex);
  24. java.sql.Ref getRef(int columnIndex);
  25. getURL(int columnIndex);

20.6.Query ResultSet
20.6.1.ResultSet's Methods to Access Columns by Index
20.6.2.ResultSet's Methods to Access Columns by Name
20.6.3.ResultSet: A SQL query returns a ResultSet containing the requested data
20.6.4.Get Data from a ResultSet
20.6.5.Retrieving the Value of a Column Using the Index Number
20.6.6.Retrieving the Value of a Column Using the Column Name
20.6.7.Selecting all rows from a table and creates a result set:
20.6.8.If you Do Not Know the Name, Position, and Type of Each Column, how to get value from ResultSet
20.6.9.Determine If a Fetched Value Is NULL
20.6.10.Get int value from ResultSet
20.6.11.Get the Number of Rows in a Database Table
20.6.12.Limit the Number of Rows Returned from a SQL Query
20.6.13.Checking for a Warning Using a ResultSet Object
20.6.14.Convert a ResultSet to XML
20.6.15.Converting types: DATE to String