DOC PREVIEW
DePaul
IS 313 -
JDBC II
View full document
Premium Document
Do you want full access? Go Premium and unlock all 7 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 7 pages.
Access to all documents
Download any document
Ad free experience
Unformatted text preview:
View Full Document
JDBC IITypesNumeric SQL typesMore SQL typesNew SQL (99) TypesTypes in JDBCData accessorsJDBC IIIS 3134.17.2003TypesJava types ≠ SQL typesSQL typeshistoricalneed for backwards compatibilityNumeric SQL typesIntegerstiny intsmall intintegerbig intReal numbersrealfloatdecimalnumericMore SQL typesBooleanbitStringcharvarcharlong var charBinarybinaryvar binarylong var binaryTimeDateTimeTimestampNew SQL (99) TypesBinary Large ObjectBLOBCharacter Large ObjectCLOBArraycan manipulate without copyingTypes in JDBCAccessors to ResultSetWith column nameString name = rs.getString (“Name”);With column number int id = rs.getInt(1);Data
View Full Document
Unlocking...