Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
JDBC
JdbcConnection
Interface JdbcConnection
A JDBC Connection. For documentation of this class, see java.sql.Connection.
interface
JdbcConnection
{
clearWarnings
()
:
void
;
close
()
:
void
;
commit
()
:
void
;
createArrayOf
(
typeName
:
string
,
elements
:
any
[]
)
:
JdbcArray
;
createBlob
()
:
JdbcBlob
;
createClob
()
:
JdbcClob
;
createNClob
()
:
JdbcClob
;
createSQLXML
()
:
JdbcSQLXML
;
createStatement
()
:
JdbcStatement
;
createStatement
(
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcStatement
;
createStatement
(
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcStatement
;
createStruct
(
typeName
:
string
,
attributes
:
any
[]
)
:
JdbcStruct
;
getAutoCommit
()
:
boolean
;
getCatalog
()
:
string
;
getHoldability
()
:
number
;
getMetaData
()
:
JdbcDatabaseMetaData
;
getTransactionIsolation
()
:
number
;
getWarnings
()
:
string
[]
;
isClosed
()
:
boolean
;
isReadOnly
()
:
boolean
;
isValid
(
timeout
:
number
)
:
boolean
;
nativeSQL
(
sql
:
string
)
:
string
;
prepareCall
(
sql
:
string
)
:
JdbcCallableStatement
;
prepareCall
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcCallableStatement
;
prepareCall
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcCallableStatement
;
prepareStatement
(
sql
:
string
)
:
JdbcPreparedStatement
;
prepareStatement
(
sql
:
string
,
autoGeneratedKeys
:
number
,
)
:
JdbcPreparedStatement
;
prepareStatement
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcPreparedStatement
;
prepareStatement
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcPreparedStatement
;
prepareStatementByIndex
(
sql
:
string
,
indices
:
number
[]
,
)
:
JdbcPreparedStatement
;
prepareStatementByName
(
sql
:
string
,
columnNames
:
string
[]
,
)
:
JdbcPreparedStatement
;
releaseSavepoint
(
savepoint
:
JdbcSavepoint
)
:
void
;
rollback
()
:
void
;
rollback
(
savepoint
:
JdbcSavepoint
)
:
void
;
setAutoCommit
(
autoCommit
:
boolean
)
:
void
;
setCatalog
(
catalog
:
string
)
:
void
;
setHoldability
(
holdability
:
number
)
:
void
;
setReadOnly
(
readOnly
:
boolean
)
:
void
;
setSavepoint
()
:
JdbcSavepoint
;
setSavepoint
(
name
:
string
)
:
JdbcSavepoint
;
setTransactionIsolation
(
level
:
number
)
:
void
;
}
Index
Methods
clear
Warnings
close
commit
create
Array
Of
create
Blob
create
Clob
create
N
Clob
create
SQLXML
create
Statement
create
Struct
get
Auto
Commit
get
Catalog
get
Holdability
get
Meta
Data
get
Transaction
Isolation
get
Warnings
is
Closed
is
Read
Only
is
Valid
native
SQL
prepare
Call
prepare
Statement
prepare
Statement
By
Index
prepare
Statement
By
Name
release
Savepoint
rollback
set
Auto
Commit
set
Catalog
set
Holdability
set
Read
Only
set
Savepoint
set
Transaction
Isolation
Methods
clear
Warnings
clearWarnings
()
:
void
Returns
void
close
close
()
:
void
Returns
void
commit
commit
()
:
void
Returns
void
create
Array
Of
createArrayOf
(
typeName
:
string
,
elements
:
any
[]
)
:
JdbcArray
Parameters
typeName
:
string
elements
:
any
[]
Returns
JdbcArray
create
Blob
createBlob
()
:
JdbcBlob
Returns
JdbcBlob
create
Clob
createClob
()
:
JdbcClob
Returns
JdbcClob
create
N
Clob
createNClob
()
:
JdbcClob
Returns
JdbcClob
create
SQLXML
createSQLXML
()
:
JdbcSQLXML
Returns
JdbcSQLXML
create
Statement
createStatement
()
:
JdbcStatement
Returns
JdbcStatement
createStatement
(
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcStatement
Parameters
resultSetType
:
number
resultSetConcurrency
:
number
Returns
JdbcStatement
createStatement
(
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcStatement
Parameters
resultSetType
:
number
resultSetConcurrency
:
number
resultSetHoldability
:
number
Returns
JdbcStatement
create
Struct
createStruct
(
typeName
:
string
,
attributes
:
any
[]
)
:
JdbcStruct
Parameters
typeName
:
string
attributes
:
any
[]
Returns
JdbcStruct
get
Auto
Commit
getAutoCommit
()
:
boolean
Returns
boolean
get
Catalog
getCatalog
()
:
string
Returns
string
get
Holdability
getHoldability
()
:
number
Returns
number
get
Meta
Data
getMetaData
()
:
JdbcDatabaseMetaData
Returns
JdbcDatabaseMetaData
get
Transaction
Isolation
getTransactionIsolation
()
:
number
Returns
number
get
Warnings
getWarnings
()
:
string
[]
Returns
string
[]
is
Closed
isClosed
()
:
boolean
Returns
boolean
is
Read
Only
isReadOnly
()
:
boolean
Returns
boolean
is
Valid
isValid
(
timeout
:
number
)
:
boolean
Parameters
timeout
:
number
Returns
boolean
native
SQL
nativeSQL
(
sql
:
string
)
:
string
Parameters
sql
:
string
Returns
string
prepare
Call
prepareCall
(
sql
:
string
)
:
JdbcCallableStatement
Parameters
sql
:
string
Returns
JdbcCallableStatement
prepareCall
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcCallableStatement
Parameters
sql
:
string
resultSetType
:
number
resultSetConcurrency
:
number
Returns
JdbcCallableStatement
prepareCall
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcCallableStatement
Parameters
sql
:
string
resultSetType
:
number
resultSetConcurrency
:
number
resultSetHoldability
:
number
Returns
JdbcCallableStatement
prepare
Statement
prepareStatement
(
sql
:
string
)
:
JdbcPreparedStatement
Parameters
sql
:
string
Returns
JdbcPreparedStatement
prepareStatement
(
sql
:
string
,
autoGeneratedKeys
:
number
)
:
JdbcPreparedStatement
Parameters
sql
:
string
autoGeneratedKeys
:
number
Returns
JdbcPreparedStatement
prepareStatement
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
)
:
JdbcPreparedStatement
Parameters
sql
:
string
resultSetType
:
number
resultSetConcurrency
:
number
Returns
JdbcPreparedStatement
prepareStatement
(
sql
:
string
,
resultSetType
:
number
,
resultSetConcurrency
:
number
,
resultSetHoldability
:
number
,
)
:
JdbcPreparedStatement
Parameters
sql
:
string
resultSetType
:
number
resultSetConcurrency
:
number
resultSetHoldability
:
number
Returns
JdbcPreparedStatement
prepare
Statement
By
Index
prepareStatementByIndex
(
sql
:
string
,
indices
:
number
[]
)
:
JdbcPreparedStatement
Parameters
sql
:
string
indices
:
number
[]
Returns
JdbcPreparedStatement
prepare
Statement
By
Name
prepareStatementByName
(
sql
:
string
,
columnNames
:
string
[]
,
)
:
JdbcPreparedStatement
Parameters
sql
:
string
columnNames
:
string
[]
Returns
JdbcPreparedStatement
release
Savepoint
releaseSavepoint
(
savepoint
:
JdbcSavepoint
)
:
void
Parameters
savepoint
:
JdbcSavepoint
Returns
void
rollback
rollback
()
:
void
Returns
void
rollback
(
savepoint
:
JdbcSavepoint
)
:
void
Parameters
savepoint
:
JdbcSavepoint
Returns
void
set
Auto
Commit
setAutoCommit
(
autoCommit
:
boolean
)
:
void
Parameters
autoCommit
:
boolean
Returns
void
set
Catalog
setCatalog
(
catalog
:
string
)
:
void
Parameters
catalog
:
string
Returns
void
set
Holdability
setHoldability
(
holdability
:
number
)
:
void
Parameters
holdability
:
number
Returns
void
set
Read
Only
setReadOnly
(
readOnly
:
boolean
)
:
void
Parameters
readOnly
:
boolean
Returns
void
set
Savepoint
setSavepoint
()
:
JdbcSavepoint
Returns
JdbcSavepoint
setSavepoint
(
name
:
string
)
:
JdbcSavepoint
Parameters
name
:
string
Returns
JdbcSavepoint
set
Transaction
Isolation
setTransactionIsolation
(
level
:
number
)
:
void
Parameters
level
:
number
Returns
void
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
clear
Warnings
close
commit
create
Array
Of
create
Blob
create
Clob
create
N
Clob
create
SQLXML
create
Statement
create
Struct
get
Auto
Commit
get
Catalog
get
Holdability
get
Meta
Data
get
Transaction
Isolation
get
Warnings
is
Closed
is
Read
Only
is
Valid
native
SQL
prepare
Call
prepare
Statement
prepare
Statement
By
Index
prepare
Statement
By
Name
release
Savepoint
rollback
set
Auto
Commit
set
Catalog
set
Holdability
set
Read
Only
set
Savepoint
set
Transaction
Isolation
Google Apps Script API
Loading...
A JDBC Connection. For documentation of this class, see java.sql.Connection.