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

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

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