jdbc (desktop)

Constants

CLOSE_ALL_RESULTS : number = 3

CLOSE_CURRENT_RESULT : number = 1

CLOSE_CURSORS_AT_COMMIT : number = 2

CONCUR_READ_ONLY : number = 1007

CONCUR_UPDATABLE : number = 1008

EXECUTE_FAILED : number = -3

FETCH_FORWARD : number = 1000

FETCH_REVERSE : number = 1001

FETCH_UNKNOWN : number = 1002

HOLD_CURSORS_OVER_COMMIT : number = 1

KEEP_CURRENT_RESULT : number = 2

NO_GENERATED_KEYS : number = 2

RETURN_GENERATED_KEYS : number = 1

SUCCESS_NO_INFO : number = -2

TRANSACTION_NONE : number = 0

TRANSACTION_READ_COMMITTED : number = 2

TRANSACTION_READ_UNCOMMITTED : number = 1

TRANSACTION_REPEATABLE_READ : number = 4

TRANSACTION_SERIALIZABLE : number = 8

TYPE_FORWARD_ONLY : number = 1003

TYPE_SCROLL_INSENSITIVE : number = 1004

TYPE_SCROLL_SENSITIVE : number = 1005

Functions

getConnection(...) — getConnection(connectionUrl)

getConnection(connectionUrl, driverClassName)

getConnection(connectionUrl, user, password)

getConnection(connectionUrl, user, password, driverClassName)

Creates connection and returns ConnectionValue.

mysql(connectionUrl) — creates mysql connection

sqlite(connectionUrl) — creates sqlite connection

Types

ConnectionValue

Functions

clearWarnings()

close()

commit()

createStatement()

getAutoCommit()

getCatalog()

getHoldability()

getNetworkTimeout()

getSchema()

getTransactionIsolation()

getUpdateCount()

isClosed()

isReadOnly()

prepareStatement()

rollback()

setHoldability()

setTransactionIsolation()

ResultSetValue

Functions

absolute()

afterLast()

beforeFirst()

cancelRowUpdates()

clearWarnings()

close()

deleteRow()

findColumn()

first()

getArray()

getBigDecimal()

getBoolean()

getByte()

getBytes()

getConcurrency()

getCursorName()

getDate()

getDouble()

getFetchDirection()

getFetchSize()

getFloat()

getHoldability()

getInt()

getLong()

getNString()

getRow()

getRowId()

getShort()

getStatement()

getString()

getTime()

getTimestamp()

getType()

getURL()

insertRow()

isAfterLast()

isBeforeFirst()

isClosed()

isFirst()

isLast()

last()

moveToCurrentRow()

moveToInsertRow()

next()

previous()

refreshRow()

relative()

rowDeleted()

rowInserted()

rowUpdated()

setFetchDirection()

setFetchSize()

updateBigDecimal()

updateBoolean()

updateByte()

updateBytes()

updateDate()

updateDouble()

updateFloat()

updateInt()

updateLong()

updateNString()

updateNull()

updateRow()

updateShort()

updateString()

updateTime()

updateTimestamp()

wasNull()

StatementValue

Functions

addBatch()

cancel()

clearBatch()

clearParameters()

clearWarnings()

close()

closeOnCompletion()

execute()

executeBatch()

executeLargeBatch()

executeLargeUpdate()

executeQuery()

executeUpdate()

getFetchDirection()

getFetchSize()

getGeneratedKeys()

getMaxFieldSize()

getMaxRows()

getMoreResults()

getQueryTimeout()

getResultSet()

getResultSetConcurrency()

getResultSetHoldability()

getResultSetType()

getUpdateCount()

isCloseOnCompletion()

isClosed()

isPoolable()

setBigDecimal()

setBoolean()

setByte()

setBytes()

setCursorName()

setDate()

setDouble()

setEscapeProcessing()

setFetchDirection()

setFetchSize()

setFloat()

setInt()

setLargeMaxRows()

setLong()

setMaxFieldSize()

setMaxRows()

setNString()

setNull()

setPoolable()

setQueryTimeout()

setShort()

setString()

setTime()

setTimestamp()

setURL()