Mega Code Archive

 
Categories / Java Tutorial / Database
 

ResultSets Methods to Access Columns by Index

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