|
||||||||||
| 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.PreparedStatementjava.sql.SQLException
public int executeUpdate()
throws java.sql.SQLException
executeUpdate in interface java.sql.PreparedStatementjava.sql.SQLException
public void setNull(int parameterIndex,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...sqlType - ignored
java.sql.SQLExceptionStatement.bindNull(int)
public void setBoolean(int parameterIndex,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindInt(int, int)
public void setByte(int parameterIndex,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindInt(int, int)
public void setShort(int parameterIndex,
short x)
throws java.sql.SQLException
setShort in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindInt(int, int)
public void setInt(int parameterIndex,
int x)
throws java.sql.SQLException
setInt in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindInt(int, int)
public void setLong(int parameterIndex,
long x)
throws java.sql.SQLException
setLong in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindLong(int, long)
public void setFloat(int parameterIndex,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindDouble(int, double)
public void setDouble(int parameterIndex,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindDouble(int, double)
public void setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindText(int, String)
public void setString(int parameterIndex,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindText(int, String),
Statement.bindNull(int)
public void setBytes(int parameterIndex,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionStatement.bindBytes(int, byte[]),
Statement.bindNull(int)
public void setDate(int parameterIndex,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionSQLite3.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.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionSQLite3.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.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLExceptionSQLite3.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.PreparedStatementjava.lang.UnsupportedOperationException
public void setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
setUnicodeStream in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationException
public void setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
setBinaryStream in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationException
public void clearParameters()
throws java.sql.SQLException
clearParameters in interface java.sql.PreparedStatementjava.sql.SQLException
public void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scaleOrLength)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter valuetargetSqlType - scaleOrLength -
java.sql.SQLExceptionsetObject(int, Object)
public void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter valuetargetSqlType -
java.sql.SQLExceptionsetObject(int, Object, int, int)
public void setObject(int parameterIndex,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the parameter value
java.sql.SQLException
java.lang.UnsupportedOperationExceptionsetNull(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.PreparedStatementjava.sql.SQLException
public void addBatch()
throws java.sql.SQLException
addBatch in interface java.sql.PreparedStatementjava.sql.SQLException
public void clearBatch()
throws java.sql.SQLException
clearBatch in interface java.sql.StatementclearBatch in class JdbcStatementjava.sql.SQLException
public int[] executeBatch()
throws java.sql.SQLException
executeBatch in interface java.sql.StatementexecuteBatch in class JdbcStatementjava.sql.SQLException
public void setCharacterStream(int parameterIndex,
java.io.Reader x,
int length)
setCharacterStream in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationException
public void setRef(int parameterIndex,
java.sql.Ref x)
setRef in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationException
public void setBlob(int parameterIndex,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.PreparedStatementparameterIndex - 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_VALUE
public void setClob(int parameterIndex,
java.sql.Clob x)
setClob in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationException
public void setArray(int parameterIndex,
java.sql.Array x)
setArray in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationExceptionpublic 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.PreparedStatementparameterIndex - 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.SQLExceptionsetDate(int, Date)
public void setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
setTime in interface java.sql.PreparedStatementparameterIndex - 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.SQLExceptionsetTime(int, Time)
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
setTimestamp in interface java.sql.PreparedStatementparameterIndex - 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.SQLExceptionsetTimestamp(int, Timestamp)
public void setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...sqlType - typeName - ignore
java.sql.SQLExceptionsetNull(int, int)
public void setURL(int parameterIndex,
java.net.URL x)
setURL in interface java.sql.PreparedStatementjava.lang.UnsupportedOperationExceptionpublic JdbcParameterMetaData getParameterMetaData()
getParameterMetaData in interface java.sql.PreparedStatementpublic boolean isClosed()
isClosed in class JdbcStatement
public void close()
throws java.sql.SQLException
close in interface java.sql.Statementclose in class JdbcStatementjava.sql.SQLException
public void detach(java.sql.ResultSet drs)
throws java.sql.SQLException
detach in class JdbcStatementdrs - ResultSet that wants to be detached
java.sql.SQLException
public void close(java.sql.ResultSet drs)
throws java.sql.SQLException
close in class JdbcStatementdrs - ResultSet that wants to be detached
java.sql.SQLExceptionclose()
protected void finalize()
throws java.lang.Throwable
finalize in class JdbcStatementjava.lang.Throwable
public int findParameter(java.lang.String parameterName)
throws java.sql.SQLException
parameterName - parameter name
java.sql.SQLExceptionStatement.getParameterIndex(String)
public void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
parameterName - sqlType - ignore
java.sql.SQLExceptionfindParameter(String),
setNull(int, int)
public void setBoolean(java.lang.String parameterName,
boolean x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setBoolean(int, boolean)
public void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setByte(int, byte)
public void setShort(java.lang.String parameterName,
short x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setShort(int, short)
public void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setInt(int, int)
public void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setLong(int, long)
public void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(String),
setFloat(int, float)
public void setDouble(java.lang.String parameterName,
double x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(String),
setString(int, String)
public void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
parameterName - x - the parameter value
java.sql.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionfindParameter(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.SQLExceptionStatement.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 | |||||||||