jdbc
Константы
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
Функции
getConnection(...) - getConnection(connectionUrl)
getConnection(connectionUrl, driverClassName)
getConnection(connectionUrl, user, password)
getConnection(connectionUrl, user, password, driverClassName)
Создаёт подключение и возвращает ConnectionValue.
mysql(connectionUrl) - создаёт mysql подключение
sqlite(connectionUrl) - создаёт sqlite подключение
Типы
ConnectionValue
Функции
clearWarnings()
close()
commit()
createStatement()
getAutoCommit()
getCatalog()
getHoldability()
getNetworkTimeout()
getSchema()
getTransactionIsolation()
getUpdateCount()
isClosed()
isReadOnly()
prepareStatement()
rollback()
setHoldability()
setTransactionIsolation()
ResultSetValue
Функции
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
Функции
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()