jdbc (desktop)

Константы

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()