Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
JDBC
JdbcStatement
Interface JdbcStatement
A JDBC Statement. For documentation of this class, see java.sql.Statement .
interface
JdbcStatement
{
addBatch
(
sql
:
string
)
:
void
;
cancel
()
:
void
;
clearBatch
()
:
void
;
clearWarnings
()
:
void
;
close
()
:
void
;
execute
(
sql
:
string
)
:
boolean
;
execute
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
boolean
;
execute
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
boolean
;
execute
(
sql
:
string
,
columnNames
:
string
[]
)
:
boolean
;
executeBatch
()
:
number
[]
;
executeQuery
(
sql
:
string
)
:
JdbcResultSet
;
executeUpdate
(
sql
:
string
)
:
number
;
executeUpdate
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
number
;
executeUpdate
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
number
;
executeUpdate
(
sql
:
string
,
columnNames
:
string
[]
)
:
number
;
getConnection
()
:
JdbcConnection
;
getFetchDirection
()
:
number
;
getFetchSize
()
:
number
;
getGeneratedKeys
()
:
JdbcResultSet
;
getMaxFieldSize
()
:
number
;
getMaxRows
()
:
number
;
getMoreResults
()
:
boolean
;
getMoreResults
(
current
:
number
)
:
boolean
;
getQueryTimeout
()
:
number
;
getResultSet
()
:
JdbcResultSet
;
getResultSetConcurrency
()
:
number
;
getResultSetHoldability
()
:
number
;
getResultSetType
()
:
number
;
getUpdateCount
()
:
number
;
getWarnings
()
:
string
[]
;
isClosed
()
:
boolean
;
isPoolable
()
:
boolean
;
setCursorName
(
name
:
string
)
:
void
;
setEscapeProcessing
(
enable
:
boolean
)
:
void
;
setFetchDirection
(
direction
:
number
)
:
void
;
setFetchSize
(
rows
:
number
)
:
void
;
setMaxFieldSize
(
max
:
number
)
:
void
;
setMaxRows
(
max
:
number
)
:
void
;
setPoolable
(
poolable
:
boolean
)
:
void
;
setQueryTimeout
(
seconds
:
number
)
:
void
;
}
Index
Methods
add
Batch
cancel
clear
Batch
clear
Warnings
close
execute
execute
Batch
execute
Query
execute
Update
get
Connection
get
Fetch
Direction
get
Fetch
Size
get
Generated
Keys
get
Max
Field
Size
get
Max
Rows
get
More
Results
get
Query
Timeout
get
Result
Set
get
Result
Set
Concurrency
get
Result
Set
Holdability
get
Result
Set
Type
get
Update
Count
get
Warnings
is
Closed
is
Poolable
set
Cursor
Name
set
Escape
Processing
set
Fetch
Direction
set
Fetch
Size
set
Max
Field
Size
set
Max
Rows
set
Poolable
set
Query
Timeout
Methods
add
Batch
addBatch
(
sql
:
string
)
:
void
Parameters
sql
:
string
Returns
void
cancel
cancel
()
:
void
Returns
void
clear
Batch
clearBatch
()
:
void
Returns
void
clear
Warnings
clearWarnings
()
:
void
Returns
void
close
close
()
:
void
Returns
void
execute
execute
(
sql
:
string
)
:
boolean
Parameters
sql
:
string
Returns
boolean
execute
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
boolean
Parameters
sql
:
string
autoGeneratedKeys
:
number
sql_
:
string
columnIndexes
:
number
[]
Returns
boolean
execute
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
boolean
Parameters
sql
:
string
autoGeneratedKeys
:
number
sql_
:
string
columnIndexes
:
number
[]
Returns
boolean
execute
(
sql
:
string
,
columnNames
:
string
[]
)
:
boolean
Parameters
sql
:
string
columnNames
:
string
[]
Returns
boolean
execute
Batch
executeBatch
()
:
number
[]
Returns
number
[]
execute
Query
executeQuery
(
sql
:
string
)
:
JdbcResultSet
Parameters
sql
:
string
Returns
JdbcResultSet
execute
Update
executeUpdate
(
sql
:
string
)
:
number
Parameters
sql
:
string
Returns
number
executeUpdate
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
number
Parameters
sql
:
string
autoGeneratedKeys
:
number
sql_
:
string
columnIndexes
:
number
[]
Returns
number
executeUpdate
(
sql
:
string
,
autoGeneratedKeys
:
number
,
sql_
:
string
,
columnIndexes
:
number
[]
,
)
:
number
Parameters
sql
:
string
autoGeneratedKeys
:
number
sql_
:
string
columnIndexes
:
number
[]
Returns
number
executeUpdate
(
sql
:
string
,
columnNames
:
string
[]
)
:
number
Parameters
sql
:
string
columnNames
:
string
[]
Returns
number
get
Connection
getConnection
()
:
JdbcConnection
Returns
JdbcConnection
get
Fetch
Direction
getFetchDirection
()
:
number
Returns
number
get
Fetch
Size
getFetchSize
()
:
number
Returns
number
get
Generated
Keys
getGeneratedKeys
()
:
JdbcResultSet
Returns
JdbcResultSet
get
Max
Field
Size
getMaxFieldSize
()
:
number
Returns
number
get
Max
Rows
getMaxRows
()
:
number
Returns
number
get
More
Results
getMoreResults
()
:
boolean
Returns
boolean
getMoreResults
(
current
:
number
)
:
boolean
Parameters
current
:
number
Returns
boolean
get
Query
Timeout
getQueryTimeout
()
:
number
Returns
number
get
Result
Set
getResultSet
()
:
JdbcResultSet
Returns
JdbcResultSet
get
Result
Set
Concurrency
getResultSetConcurrency
()
:
number
Returns
number
get
Result
Set
Holdability
getResultSetHoldability
()
:
number
Returns
number
get
Result
Set
Type
getResultSetType
()
:
number
Returns
number
get
Update
Count
getUpdateCount
()
:
number
Returns
number
get
Warnings
getWarnings
()
:
string
[]
Returns
string
[]
is
Closed
isClosed
()
:
boolean
Returns
boolean
is
Poolable
isPoolable
()
:
boolean
Returns
boolean
set
Cursor
Name
setCursorName
(
name
:
string
)
:
void
Parameters
name
:
string
Returns
void
set
Escape
Processing
setEscapeProcessing
(
enable
:
boolean
)
:
void
Parameters
enable
:
boolean
Returns
void
set
Fetch
Direction
setFetchDirection
(
direction
:
number
)
:
void
Parameters
direction
:
number
Returns
void
set
Fetch
Size
setFetchSize
(
rows
:
number
)
:
void
Parameters
rows
:
number
Returns
void
set
Max
Field
Size
setMaxFieldSize
(
max
:
number
)
:
void
Parameters
max
:
number
Returns
void
set
Max
Rows
setMaxRows
(
max
:
number
)
:
void
Parameters
max
:
number
Returns
void
set
Poolable
setPoolable
(
poolable
:
boolean
)
:
void
Parameters
poolable
:
boolean
Returns
void
set
Query
Timeout
setQueryTimeout
(
seconds
:
number
)
:
void
Parameters
seconds
:
number
Returns
void
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
add
Batch
cancel
clear
Batch
clear
Warnings
close
execute
execute
Batch
execute
Query
execute
Update
get
Connection
get
Fetch
Direction
get
Fetch
Size
get
Generated
Keys
get
Max
Field
Size
get
Max
Rows
get
More
Results
get
Query
Timeout
get
Result
Set
get
Result
Set
Concurrency
get
Result
Set
Holdability
get
Result
Set
Type
get
Update
Count
get
Warnings
is
Closed
is
Poolable
set
Cursor
Name
set
Escape
Processing
set
Fetch
Direction
set
Fetch
Size
set
Max
Field
Size
set
Max
Rows
set
Poolable
set
Query
Timeout
Google Apps Script API
Loading...
A JDBC Statement. For documentation of this class, see java.sql.Statement .