|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.sqlite.jdbc.JdbcStatement
org.sqlite.jdbc.JdbcPreparedStatement
public class JdbcPreparedStatement
Field Summary |
---|
Fields inherited from class org.sqlite.jdbc.JdbcStatement |
---|
cntUpdate, currentRet, db, results, rs |
Fields inherited from interface java.sql.Statement |
---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Constructor Summary | |
---|---|
JdbcPreparedStatement(Database db,
JdbcConnection conn,
java.lang.String sql)
|
Method Summary | |
---|---|
void |
addBatch()
|
void |
clearBatch()
|
void |
clearParameters()
|
void |
close()
|
void |
close(java.sql.ResultSet drs)
Detaches the ResultSet object from the life cycle of JdbcPreparedStatement and invoke close() method. |
void |
detach(java.sql.ResultSet drs)
Detaches the ResultSet object from the life cycle of JdbcStatement. WARNING! All parameters are unbinded. |
boolean |
execute()
|
int[] |
executeBatch()
|
JdbcResultSet |
executeQuery()
|
int |
executeUpdate()
|
protected static int |
executeUpdate(Statement stmt)
|
protected void |
finalize()
|
int |
findParameter(java.lang.String parameterName)
Retrieves the parameter index. invoke org.sqlite.Statement#getParameterIndex(String) method. |
java.lang.String |
findParameterName(int parameterIndex)
Retrieves the parameter name. invoke org.sqlite.Statement#getParameterName(int) method. |
JdbcResultSetMetaData |
getMetaData()
|
JdbcParameterMetaData |
getParameterMetaData()
|
boolean |
isClosed()
|
void |
setArray(int parameterIndex,
java.sql.Array x)
Not supporetd yet. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
Not supporetd yet. |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
invoke BigDecimal#toString() and org.sqlite.Statement#bindText(int, String) method. |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
invoke findParameter(String) and setBigDecimal(int, BigDecimal) method. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
Not supporetd yet. |
void |
setBlob(int parameterIndex,
java.sql.Blob x)
invoke setBytes(int, byte[]) method. |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x)
invoke findParameter(String) and setBlob(int, Blob) method. |
void |
setBoolean(int parameterIndex,
boolean x)
invoke org.sqlite.Statement#bindInt(int, int) method. |
void |
setBoolean(java.lang.String parameterName,
boolean x)
invoke findParameter(String) and setBoolean(int, boolean) method. |
void |
setByte(int parameterIndex,
byte x)
invoke org.sqlite.Statement#bindInt(int, int) method. |
void |
setByte(java.lang.String parameterName,
byte x)
invoke findParameter(String) and setByte(int, byte) method. |
void |
setBytes(int parameterIndex,
byte[] x)
invoke org.sqlite.Statement#bindBytes(int, byte[]) method. |
void |
setBytes(java.lang.String parameterName,
byte[] x)
invoke findParameter(String) and setBytes(int, byte[]) method. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader x,
int length)
Not supporetd yet. |
void |
setClob(int parameterIndex,
java.sql.Clob x)
Not supporetd yet. |
void |
setDate(int parameterIndex,
java.sql.Date x)
invoke SQLite3#format(Date) and org.sqlite.Statement#bindText(int, String) method. |
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
invoke setDate(int, Date) method. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x)
invoke findParameter(String) and setDate(int, Date) method. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
invoke findParameter(String) and setDate(int, Date, Calendar) method. |
void |
setDouble(int parameterIndex,
double x)
invoke org.sqlite.Statement#bindDouble(int, double) method. |
void |
setDouble(java.lang.String parameterName,
double x)
invoke findParameter(String) and setDouble(int, double) method. |
void |
setFloat(int parameterIndex,
float x)
invoke org.sqlite.Statement#bindDouble(int, double) method. |
void |
setFloat(java.lang.String parameterName,
float x)
invoke findParameter(String) and setFloat(int, float) method. |
void |
setInt(int parameterIndex,
int x)
invoke org.sqlite.Statement#bindInt(int, int) method. |
void |
setInt(java.lang.String parameterName,
int x)
invoke findParameter(String) and setInt(int, int) method. |
void |
setLong(int parameterIndex,
long x)
invoke org.sqlite.Statement#bindLong(int, long) method. |
void |
setLong(java.lang.String parameterName,
long x)
invoke findParameter(String) and setLong(int, long) method. |
void |
setNull(int parameterIndex,
int sqlType)
invoke org.sqlite.Statement#bindNull(int) method. |
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
invoke setNull(int, int) method. |
void |
setNull(java.lang.String parameterName,
int sqlType)
invoke findParameter(String) and setNull(int, int) method. |
void |
setObject(int parameterIndex,
java.lang.Object x)
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
invoke setObject(parameterIndex, x, 0) method. |
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scaleOrLength)
|
void |
setRef(int parameterIndex,
java.sql.Ref x)
Not supporetd yet. |
void |
setShort(int parameterIndex,
short x)
invoke org.sqlite.Statement#bindInt(int, int) method. |
void |
setShort(java.lang.String parameterName,
short x)
invoke findParameter(String) and setShort(int, short) method. |
void |
setString(int parameterIndex,
java.lang.String x)
invoke org.sqlite.Statement#bindText(int, String) method. |
void |
setString(java.lang.String parameterName,
java.lang.String x)
invoke findParameter(String) and setString(int, String) method. |
void |
setTime(int parameterIndex,
java.sql.Time x)
invoke SQLite3#format(Time) and org.sqlite.Statement#bindText(int, String) method. |
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
invoke setTime(int, Time) method. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
invoke findParameter(String) and setTime(int, Time) method. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
invoke findParameter(String) and setTime(int, Time, Calendar) method. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
invoke SQLite3#format(Timestamp) and org.sqlite.Statement#bindText(int, String) method. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
invoke setTimestamp(int, Timestamp) method. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
invoke findParameter(String) and setTimestamp(int, Timestamp) method. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
invoke findParameter(String) and setTimestamp(int, Timestamp, Calendar) method. |
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
Deprecated. |
void |
setURL(int parameterIndex,
java.net.URL x)
Not supporetd yet. |
static void |
validateSqlType(int sqlType)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.Statement |
---|
addBatch, cancel, clearWarnings, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Constructor Detail |
---|
public JdbcPreparedStatement(Database db, JdbcConnection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
Method Detail |
---|
public JdbcResultSet executeQuery() throws java.sql.SQLException
executeQuery
in interface java.sql.PreparedStatement
java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...sqlType
- ignored
java.sql.SQLException
Statement.bindNull(int)
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindInt(int, int)
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
setByte
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindInt(int, int)
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
setShort
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindInt(int, int)
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
setInt
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindInt(int, int)
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
setLong
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindLong(int, long)
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
setFloat
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindDouble(int, double)
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
setDouble
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindDouble(int, double)
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindText(int, String)
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindText(int, String)
,
Statement.bindNull(int)
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
Statement.bindBytes(int, byte[])
,
Statement.bindNull(int)
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
SQLite3.format(Date)
,
Statement.bindText(int, String)
,
Statement.bindNull(int)
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
SQLite3.format(Time)
,
Statement.bindText(int, String)
,
Statement.bindNull(int)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
SQLite3.format(Timestamp)
,
Statement.bindText(int, String)
,
Statement.bindNull(int)
public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
setAsciiStream
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
setUnicodeStream
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
setBinaryStream
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void clearParameters() throws java.sql.SQLException
clearParameters
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scaleOrLength) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuetargetSqlType
- scaleOrLength
-
java.sql.SQLException
setObject(int, Object)
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuetargetSqlType
-
java.sql.SQLException
setObject(int, Object, int, int)
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
java.lang.UnsupportedOperationException
setNull(int, int)
,
setBoolean(int, boolean)
,
setByte(int, byte)
,
setShort(int, short)
,
setInt(int, int)
,
setLong(int, long)
,
setFloat(int, float)
,
setDouble(int, double)
,
setBigDecimal(int, java.math.BigDecimal)
,
setTimestamp(int, java.sql.Timestamp)
,
setTime(int, java.sql.Time)
,
setDate(int, java.sql.Date)
,
setString(int, String)
,
setBytes(int, byte[])
public boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
java.sql.SQLException
public void addBatch() throws java.sql.SQLException
addBatch
in interface java.sql.PreparedStatement
java.sql.SQLException
public void clearBatch() throws java.sql.SQLException
clearBatch
in interface java.sql.Statement
clearBatch
in class JdbcStatement
java.sql.SQLException
public int[] executeBatch() throws java.sql.SQLException
executeBatch
in interface java.sql.Statement
executeBatch
in class JdbcStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader x, int length)
setCharacterStream
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void setRef(int parameterIndex, java.sql.Ref x)
setRef
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
java.lang.ArithmeticException
- When Blob length is greater than Integer.MAX_VALUEpublic void setClob(int parameterIndex, java.sql.Clob x)
setClob
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public void setArray(int parameterIndex, java.sql.Array x)
setArray
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public JdbcResultSetMetaData getMetaData()
getMetaData
in interface java.sql.PreparedStatement
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the Calendar object the driver will use to construct the date
java.sql.SQLException
setDate(int, Date)
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the Calendar object the driver will use to construct the date
java.sql.SQLException
setTime(int, Time)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the Calendar object the driver will use to construct the date
java.sql.SQLException
setTimestamp(int, Timestamp)
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...sqlType
- typeName
- ignore
java.sql.SQLException
setNull(int, int)
public void setURL(int parameterIndex, java.net.URL x)
setURL
in interface java.sql.PreparedStatement
java.lang.UnsupportedOperationException
public JdbcParameterMetaData getParameterMetaData()
getParameterMetaData
in interface java.sql.PreparedStatement
public boolean isClosed()
isClosed
in class JdbcStatement
public void close() throws java.sql.SQLException
close
in interface java.sql.Statement
close
in class JdbcStatement
java.sql.SQLException
public void detach(java.sql.ResultSet drs) throws java.sql.SQLException
detach
in class JdbcStatement
drs
- ResultSet that wants to be detached
java.sql.SQLException
public void close(java.sql.ResultSet drs) throws java.sql.SQLException
close
in class JdbcStatement
drs
- ResultSet that wants to be detached
java.sql.SQLException
close()
protected void finalize() throws java.lang.Throwable
finalize
in class JdbcStatement
java.lang.Throwable
public int findParameter(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- parameter name
java.sql.SQLException
Statement.getParameterIndex(String)
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
parameterName
- sqlType
- ignore
java.sql.SQLException
findParameter(String)
,
setNull(int, int)
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setBoolean(int, boolean)
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setByte(int, byte)
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setShort(int, short)
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setInt(int, int)
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setLong(int, long)
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setFloat(int, float)
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setDouble(int, double)
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setBigDecimal(int, BigDecimal)
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setString(int, String)
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setBytes(int, byte[])
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setDate(int, Date)
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setTime(int, Time)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setTimestamp(int, Timestamp)
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
parameterName
- x
- the parameter value
java.sql.SQLException
findParameter(String)
,
setBlob(int, Blob)
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
parameterName
- x
- the parameter valuecal
-
java.sql.SQLException
findParameter(String)
,
setDate(int, Date, Calendar)
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
parameterName
- x
- the parameter valuecal
-
java.sql.SQLException
findParameter(String)
,
setTime(int, Time, Calendar)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
parameterName
- x
- the parameter valuecal
-
java.sql.SQLException
findParameter(String)
,
setTimestamp(int, Timestamp, Calendar)
public java.lang.String findParameterName(int parameterIndex) throws java.sql.SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
Statement.getParameterName(int)
public static void validateSqlType(int sqlType) throws java.sql.SQLException
java.sql.SQLException
protected static int executeUpdate(Statement stmt) throws java.sql.SQLException
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |