Mega Code Archive

 
Categories / Java Tutorial / Database
 

ResultSets Methods to Access Columns by Name

String getString(String columnName); boolean getBoolean(String columnName); byte getByte(String columnName); short getShort(String columnName); int getInt(String columnName); long getLong(String columnName); float getFloat(String columnName); double getDouble(String columnName); byte[] getBytes(String columnName); java.sql.Date getDate(String columnName); java.sql.Date getDate(String columnName, java.util.Calendar cal); java.sql.Time getTime(String columnName); java.sql.Timestamp getTimestamp(String columnName); java.sql.Timestamp getTimestamp(String columnName, java.util.Calendar cal); java.io.InputStream getAsciiStream(String columnName); java.io.InputStream getBinaryStream(String columnName); Object getObject(String columnName); Object getObject(String columnName, java.util.Map map); java.sql.Array getArray(String columnName); java.math.BigDecimal getBigDecimal(String columnName); java.sql.Blob getBlob(String columnName); java.sql.Clob getClob(String columnName); java.io.Reader getCharacterStream(String columnName); java.sql.Ref getRef(String columnName); java.net.URL getURL(String columnName);