|
||||||||||
| 前のクラス 次のクラス | フレームあり フレームなし | |||||||||
| 概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド | |||||||||
java.lang.Objectorg.sqlite.jdbc.JdbcStatement
public class JdbcStatement
| フィールドの概要 | |
|---|---|
protected int |
cntUpdate
last update count. |
protected int |
currentRet
current of result |
protected Database |
db
parent Database object. |
protected java.util.List<java.lang.Object> |
results
results of multiple statement |
protected java.sql.ResultSet |
rs
current ResultSet object. |
| インタフェース java.sql.Statement から継承されたフィールド |
|---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
| コンストラクタの概要 | |
|---|---|
JdbcStatement(Database db,
java.sql.Connection owner)
|
|
| メソッドの概要 | |
|---|---|
void |
addBatch(java.lang.String sql)
|
void |
cancel()
invoke org.sqlite.Database#interrupt() method. |
void |
clearBatch()
|
void |
clearWarnings()
nothing. |
void |
close()
|
void |
close(java.sql.ResultSet drs)
ResultSetを切り離してStatementをcloseする。 |
protected void |
closeResultSets()
|
void |
detach(java.sql.ResultSet drs)
Statement#close()時にResultSetも一緒にcloseされないようにResultSetを切り離す。 |
protected boolean |
execute(Statement stmt)
|
boolean |
execute(java.lang.String sql)
|
boolean |
execute(java.lang.String sql,
int autoGeneratedKeys)
|
boolean |
execute(java.lang.String sql,
int[] columnIndexes)
Not supporetd yet. |
boolean |
execute(java.lang.String sql,
java.lang.String[] columnNames)
Not supporetd yet. |
int[] |
executeBatch()
|
java.sql.ResultSet |
executeQuery(java.lang.String sql)
|
int |
executeUpdate(java.lang.String sql)
|
int |
executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
|
int |
executeUpdate(java.lang.String sql,
int[] columnIndexes)
Not supporetd yet. |
int |
executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
Not supporetd yet. |
protected void |
finalize()
|
java.sql.Connection |
getConnection()
|
int |
getFetchDirection()
It always returns FETCH_FORWARD. |
int |
getFetchSize()
It always returns 0. |
java.sql.ResultSet |
getGeneratedKeys()
invoke executeQuery("SELECT last_insert_rowid()") method. |
long |
getLastInsertRowId()
invoke org.sqlite.Database#lastInsertRowId() method. |
int |
getMaxFieldSize()
It always returns 0. |
int |
getMaxRows()
It always returns 0. |
boolean |
getMoreResults()
invoke getMoreResults(CLOSE_CURRENT_RESULT) method. |
boolean |
getMoreResults(int current)
Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object. |
int |
getQueryTimeout()
invoke org.sqlite.Database#getBusyTimeout() method and divide by 1000. |
java.sql.ResultSet |
getResultSet()
|
int |
getResultSetConcurrency()
It always returns CONCUR_READ_ONLY. |
int |
getResultSetHoldability()
It always returns CLOSE_CURSORS_AT_COMMIT. |
int |
getResultSetType()
It always returns TYPE_FORWARD_ONLY. |
int |
getUpdateCount()
|
java.sql.SQLWarning |
getWarnings()
It always returns null. |
boolean |
isClosed()
|
void |
setCursorName(java.lang.String name)
Not supporetd yet. |
void |
setEscapeProcessing(boolean enable)
Not supporetd yet. |
void |
setFetchDirection(int direction)
Supported fetch direction is FETCH_FORWARD only. |
void |
setFetchSize(int rows)
Not supporetd yet. |
void |
setMaxFieldSize(int max)
Not supporetd yet. |
void |
setMaxRows(int max)
Not supporetd yet. |
void |
setQueryTimeout(int seconds)
multiply the seconds by 1000 and invoke org.sqlite.Database#setBusyTimeout(int) method. |
static void |
validateAutoGeneretedKeys(int autoGeneratedKeys)
|
static void |
validateCurrentResult(int current)
|
protected void |
validateStatementOpen()
|
protected void |
validateStaticSQL(Statement stmt)
|
| クラス java.lang.Object から継承されたメソッド |
|---|
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| フィールドの詳細 |
|---|
protected Database db
protected java.util.List<java.lang.Object> results
protected int currentRet
protected java.sql.ResultSet rs
protected int cntUpdate
| コンストラクタの詳細 |
|---|
public JdbcStatement(Database db,
java.sql.Connection owner)
| メソッドの詳細 |
|---|
public java.sql.ResultSet executeQuery(java.lang.String sql)
throws java.sql.SQLException
java.sql.Statement 内の executeQueryjava.sql.SQLException
public int executeUpdate(java.lang.String sql)
throws java.sql.SQLException
java.sql.Statement 内の executeUpdatejava.sql.SQLException
public void close()
throws java.sql.SQLException
java.sql.Statement 内の closejava.sql.SQLException
public int getMaxFieldSize()
throws java.sql.SQLException
java.sql.Statement 内の getMaxFieldSizejava.sql.SQLException
public void setMaxFieldSize(int max)
throws java.sql.SQLException
java.sql.Statement 内の setMaxFieldSizemax - ignored
java.sql.SQLException
public int getMaxRows()
throws java.sql.SQLException
java.sql.Statement 内の getMaxRowsjava.sql.SQLException
public void setMaxRows(int max)
throws java.sql.SQLException
java.sql.Statement 内の setMaxRowsmax - ignored
java.sql.SQLException
public void setEscapeProcessing(boolean enable)
throws java.sql.SQLException
java.sql.Statement 内の setEscapeProcessingenable - ignored
java.sql.SQLException
public int getQueryTimeout()
throws java.sql.SQLException
java.sql.Statement 内の getQueryTimeoutjava.sql.SQLExceptionDatabase.getBusyTimeout()
public void setQueryTimeout(int seconds)
throws java.sql.SQLException
java.sql.Statement 内の setQueryTimeoutseconds -
java.sql.SQLExceptionDatabase.setBusyTimeout(int)
public void cancel()
throws java.sql.SQLException
java.sql.Statement 内の canceljava.sql.SQLExceptionDatabase.interrupt()
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
java.sql.Statement 内の getWarningsjava.sql.SQLException
public void clearWarnings()
throws java.sql.SQLException
java.sql.Statement 内の clearWarningsjava.sql.SQLException
public void setCursorName(java.lang.String name)
throws java.sql.SQLException
java.sql.Statement 内の setCursorNamejava.sql.SQLException
public boolean execute(java.lang.String sql)
throws java.sql.SQLException
java.sql.Statement 内の executejava.sql.SQLException
public java.sql.ResultSet getResultSet()
throws java.sql.SQLException
java.sql.Statement 内の getResultSetjava.sql.SQLException
public int getUpdateCount()
throws java.sql.SQLException
java.sql.Statement 内の getUpdateCountjava.sql.SQLException
public boolean getMoreResults()
throws java.sql.SQLException
java.sql.Statement 内の getMoreResultsjava.sql.SQLExceptiongetMoreResults(int)
public void setFetchDirection(int direction)
throws java.sql.SQLException
java.sql.Statement 内の setFetchDirectiondirection -
java.sql.SQLException
public int getFetchDirection()
throws java.sql.SQLException
java.sql.Statement 内の getFetchDirectionjava.sql.SQLException
public void setFetchSize(int rows)
throws java.sql.SQLException
java.sql.Statement 内の setFetchSizerows - ignored
java.sql.SQLException
public int getFetchSize()
throws java.sql.SQLException
java.sql.Statement 内の getFetchSizejava.sql.SQLException
public int getResultSetConcurrency()
throws java.sql.SQLException
java.sql.Statement 内の getResultSetConcurrencyjava.sql.SQLException
public int getResultSetType()
throws java.sql.SQLException
java.sql.Statement 内の getResultSetTypejava.sql.SQLException
public void addBatch(java.lang.String sql)
throws java.sql.SQLException
java.sql.Statement 内の addBatchjava.sql.SQLException
public void clearBatch()
throws java.sql.SQLException
java.sql.Statement 内の clearBatchjava.sql.SQLException
public int[] executeBatch()
throws java.sql.SQLException
java.sql.Statement 内の executeBatchjava.sql.SQLException
public java.sql.Connection getConnection()
throws java.sql.SQLException
java.sql.Statement 内の getConnectionjava.sql.SQLException
public boolean getMoreResults(int current)
throws java.sql.SQLException
java.sql.Statement 内の getMoreResultscurrent - Statement.CLOSE_CURRENT_RESULT or Statement.KEEP_CURRENT_RESULT or Statement.CLOSE_ALL_RESULTS
java.sql.SQLException
public java.sql.ResultSet getGeneratedKeys()
throws java.sql.SQLException
java.sql.Statement 内の getGeneratedKeysjava.sql.SQLException
public int executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
java.sql.Statement 内の executeUpdatesql - autoGeneratedKeys - ignored
java.sql.SQLException
public int executeUpdate(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
java.sql.Statement 内の executeUpdatesql - columnIndexes - ignored
java.sql.SQLException
public int executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
java.sql.Statement 内の executeUpdatesql - columnNames - ignored
java.sql.SQLException
public boolean execute(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
java.sql.Statement 内の executesql - autoGeneratedKeys - ignored
java.sql.SQLException
public boolean execute(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
java.sql.Statement 内の executesql - columnIndexes - ignored
java.sql.SQLException
public boolean execute(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
java.sql.Statement 内の executesql - columnNames - ignored
java.sql.SQLException
public int getResultSetHoldability()
throws java.sql.SQLException
java.sql.Statement 内の getResultSetHoldabilityjava.sql.SQLException
public boolean isClosed()
throws java.sql.SQLException
java.sql.SQLException
protected void finalize()
throws java.lang.Throwable
java.lang.Object 内の finalizejava.lang.Throwable
protected void validateStatementOpen()
throws java.sql.SQLException
java.sql.SQLException
protected void validateStaticSQL(Statement stmt)
throws java.sql.SQLException
java.sql.SQLException
public static void validateAutoGeneretedKeys(int autoGeneratedKeys)
throws java.sql.SQLException
java.sql.SQLException
public static void validateCurrentResult(int current)
throws java.sql.SQLException
java.sql.SQLException
public void detach(java.sql.ResultSet drs)
throws java.sql.SQLException
drs - ResultSet that wants to be detached
java.sql.SQLException
public void close(java.sql.ResultSet drs)
throws java.sql.SQLException
drs - ResultSet that wants to be detached
java.sql.SQLException
public long getLastInsertRowId()
throws java.sql.SQLException
java.sql.SQLExceptionDatabase.lastInsertRowId()
protected boolean execute(Statement stmt)
throws java.sql.SQLException
java.sql.SQLException
protected void closeResultSets()
throws java.sql.SQLException
java.sql.SQLException
|
||||||||||
| 前のクラス 次のクラス | フレームあり フレームなし | |||||||||
| 概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド | |||||||||