org.sqlite.jdbc
Class JdbcPreparedStatement

java.lang.Object
  extended by org.sqlite.jdbc.JdbcStatement
      extended by org.sqlite.jdbc.JdbcPreparedStatement
All Implemented Interfaces:
java.sql.PreparedStatement, java.sql.Statement

public class JdbcPreparedStatement
extends JdbcStatement
implements java.sql.PreparedStatement


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 org.sqlite.jdbc.JdbcStatement
addBatch, cancel, clearWarnings, closeResultSets, execute, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLastInsertRowId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, validateAutoGeneretedKeys, validateCurrentResult, validateStatementOpen, validateStaticSQL
 
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

JdbcPreparedStatement

public JdbcPreparedStatement(Database db,
                             JdbcConnection conn,
                             java.lang.String sql)
                      throws java.sql.SQLException
Throws:
java.sql.SQLException
Method Detail

executeQuery

public JdbcResultSet executeQuery()
                           throws java.sql.SQLException
Specified by:
executeQuery in interface java.sql.PreparedStatement
Throws:
java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException
Specified by:
executeUpdate in interface java.sql.PreparedStatement
Throws:
java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException
invoke org.sqlite.Statement#bindNull(int) method.

Specified by:
setNull in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
sqlType - ignored
Throws:
java.sql.SQLException
See Also:
Statement.bindNull(int)

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)
                throws java.sql.SQLException
invoke org.sqlite.Statement#bindInt(int, int) method.

Specified by:
setBoolean in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindInt(int, int)

setByte

public void setByte(int parameterIndex,
                    byte x)
             throws java.sql.SQLException
invoke org.sqlite.Statement#bindInt(int, int) method.

Specified by:
setByte in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindInt(int, int)

setShort

public void setShort(int parameterIndex,
                     short x)
              throws java.sql.SQLException
invoke org.sqlite.Statement#bindInt(int, int) method.

Specified by:
setShort in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindInt(int, int)

setInt

public void setInt(int parameterIndex,
                   int x)
            throws java.sql.SQLException
invoke org.sqlite.Statement#bindInt(int, int) method.

Specified by:
setInt in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindInt(int, int)

setLong

public void setLong(int parameterIndex,
                    long x)
             throws java.sql.SQLException
invoke org.sqlite.Statement#bindLong(int, long) method.

Specified by:
setLong in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindLong(int, long)

setFloat

public void setFloat(int parameterIndex,
                     float x)
              throws java.sql.SQLException
invoke org.sqlite.Statement#bindDouble(int, double) method.

Specified by:
setFloat in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindDouble(int, double)

setDouble

public void setDouble(int parameterIndex,
                      double x)
               throws java.sql.SQLException
invoke org.sqlite.Statement#bindDouble(int, double) method.

Specified by:
setDouble in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindDouble(int, double)

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException
invoke BigDecimal#toString() and org.sqlite.Statement#bindText(int, String) method.

Specified by:
setBigDecimal in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindText(int, String)

setString

public void setString(int parameterIndex,
                      java.lang.String x)
               throws java.sql.SQLException
invoke org.sqlite.Statement#bindText(int, String) method.

Specified by:
setString in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindText(int, String), Statement.bindNull(int)

setBytes

public void setBytes(int parameterIndex,
                     byte[] x)
              throws java.sql.SQLException
invoke org.sqlite.Statement#bindBytes(int, byte[]) method.

Specified by:
setBytes in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
Statement.bindBytes(int, byte[]), Statement.bindNull(int)

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x)
             throws java.sql.SQLException
invoke SQLite3#format(Date) and org.sqlite.Statement#bindText(int, String) method.

Specified by:
setDate in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
SQLite3.format(Date), Statement.bindText(int, String), Statement.bindNull(int)

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x)
             throws java.sql.SQLException
invoke SQLite3#format(Time) and org.sqlite.Statement#bindText(int, String) method.

Specified by:
setTime in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
SQLite3.format(Time), Statement.bindText(int, String), Statement.bindNull(int)

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException
invoke SQLite3#format(Timestamp) and org.sqlite.Statement#bindText(int, String) method.

Specified by:
setTimestamp in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
See Also:
SQLite3.format(Timestamp), Statement.bindText(int, String), Statement.bindNull(int)

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           int length)
Not supporetd yet.

Specified by:
setAsciiStream in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

setUnicodeStream

public void setUnicodeStream(int parameterIndex,
                             java.io.InputStream x,
                             int length)
Deprecated. 

Not supporetd yet.

Specified by:
setUnicodeStream in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            int length)
Not supporetd yet.

Specified by:
setBinaryStream in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException
Specified by:
clearParameters in interface java.sql.PreparedStatement
Throws:
java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      int targetSqlType,
                      int scaleOrLength)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
targetSqlType -
scaleOrLength -
Throws:
java.sql.SQLException
See Also:
setObject(int, Object)

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      int targetSqlType)
               throws java.sql.SQLException
invoke setObject(parameterIndex, x, 0) method.

Specified by:
setObject in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
targetSqlType -
Throws:
java.sql.SQLException
See Also:
setObject(int, Object, int, int)

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
java.lang.UnsupportedOperationException
See Also:
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[])

execute

public boolean execute()
                throws java.sql.SQLException
Specified by:
execute in interface java.sql.PreparedStatement
Throws:
java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException
Specified by:
addBatch in interface java.sql.PreparedStatement
Throws:
java.sql.SQLException

clearBatch

public void clearBatch()
                throws java.sql.SQLException
Specified by:
clearBatch in interface java.sql.Statement
Overrides:
clearBatch in class JdbcStatement
Throws:
java.sql.SQLException

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException
Specified by:
executeBatch in interface java.sql.Statement
Overrides:
executeBatch in class JdbcStatement
Throws:
java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader x,
                               int length)
Not supporetd yet.

Specified by:
setCharacterStream in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

setRef

public void setRef(int parameterIndex,
                   java.sql.Ref x)
Not supporetd yet.

Specified by:
setRef in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

setBlob

public void setBlob(int parameterIndex,
                    java.sql.Blob x)
             throws java.sql.SQLException
invoke setBytes(int, byte[]) method.

Specified by:
setBlob in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
Throws:
java.sql.SQLException
java.lang.ArithmeticException - When Blob length is greater than Integer.MAX_VALUE

setClob

public void setClob(int parameterIndex,
                    java.sql.Clob x)
Not supporetd yet.

Specified by:
setClob in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

setArray

public void setArray(int parameterIndex,
                     java.sql.Array x)
Not supporetd yet.

Specified by:
setArray in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

getMetaData

public JdbcResultSetMetaData getMetaData()
Specified by:
getMetaData in interface java.sql.PreparedStatement
Returns:

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
invoke setDate(int, Date) method.

Specified by:
setDate in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
cal - the Calendar object the driver will use to construct the date
Throws:
java.sql.SQLException
See Also:
setDate(int, Date)

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
invoke setTime(int, Time) method.

Specified by:
setTime in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
cal - the Calendar object the driver will use to construct the date
Throws:
java.sql.SQLException
See Also:
setTime(int, Time)

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException
invoke setTimestamp(int, Timestamp) method.

Specified by:
setTimestamp in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
x - the parameter value
cal - the Calendar object the driver will use to construct the date
Throws:
java.sql.SQLException
See Also:
setTimestamp(int, Timestamp)

setNull

public void setNull(int parameterIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException
invoke setNull(int, int) method.

Specified by:
setNull in interface java.sql.PreparedStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
sqlType -
typeName - ignore
Throws:
java.sql.SQLException
See Also:
setNull(int, int)

setURL

public void setURL(int parameterIndex,
                   java.net.URL x)
Not supporetd yet.

Specified by:
setURL in interface java.sql.PreparedStatement
Throws:
java.lang.UnsupportedOperationException

getParameterMetaData

public JdbcParameterMetaData getParameterMetaData()
Specified by:
getParameterMetaData in interface java.sql.PreparedStatement
Returns:

isClosed

public boolean isClosed()
Overrides:
isClosed in class JdbcStatement

close

public void close()
           throws java.sql.SQLException
Specified by:
close in interface java.sql.Statement
Overrides:
close in class JdbcStatement
Throws:
java.sql.SQLException

detach

public void detach(java.sql.ResultSet drs)
            throws java.sql.SQLException
Detaches the ResultSet object from the life cycle of JdbcStatement.
WARNING! All parameters are unbinded.

Overrides:
detach in class JdbcStatement
Parameters:
drs - ResultSet that wants to be detached
Throws:
java.sql.SQLException

close

public void close(java.sql.ResultSet drs)
           throws java.sql.SQLException
Detaches the ResultSet object from the life cycle of JdbcPreparedStatement and invoke close() method.

Overrides:
close in class JdbcStatement
Parameters:
drs - ResultSet that wants to be detached
Throws:
java.sql.SQLException
See Also:
close()

finalize

protected void finalize()
                 throws java.lang.Throwable
Overrides:
finalize in class JdbcStatement
Throws:
java.lang.Throwable

findParameter

public int findParameter(java.lang.String parameterName)
                  throws java.sql.SQLException
Retrieves the parameter index.
invoke org.sqlite.Statement#getParameterIndex(String) method.

Parameters:
parameterName - parameter name
Returns:
parameter index
Throws:
java.sql.SQLException
See Also:
Statement.getParameterIndex(String)

setNull

public void setNull(java.lang.String parameterName,
                    int sqlType)
             throws java.sql.SQLException
invoke findParameter(String) and setNull(int, int) method.

Parameters:
parameterName -
sqlType - ignore
Throws:
java.sql.SQLException
See Also:
findParameter(String), setNull(int, int)

setBoolean

public void setBoolean(java.lang.String parameterName,
                       boolean x)
                throws java.sql.SQLException
invoke findParameter(String) and setBoolean(int, boolean) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setBoolean(int, boolean)

setByte

public void setByte(java.lang.String parameterName,
                    byte x)
             throws java.sql.SQLException
invoke findParameter(String) and setByte(int, byte) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setByte(int, byte)

setShort

public void setShort(java.lang.String parameterName,
                     short x)
              throws java.sql.SQLException
invoke findParameter(String) and setShort(int, short) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setShort(int, short)

setInt

public void setInt(java.lang.String parameterName,
                   int x)
            throws java.sql.SQLException
invoke findParameter(String) and setInt(int, int) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setInt(int, int)

setLong

public void setLong(java.lang.String parameterName,
                    long x)
             throws java.sql.SQLException
invoke findParameter(String) and setLong(int, long) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setLong(int, long)

setFloat

public void setFloat(java.lang.String parameterName,
                     float x)
              throws java.sql.SQLException
invoke findParameter(String) and setFloat(int, float) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setFloat(int, float)

setDouble

public void setDouble(java.lang.String parameterName,
                      double x)
               throws java.sql.SQLException
invoke findParameter(String) and setDouble(int, double) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setDouble(int, double)

setBigDecimal

public void setBigDecimal(java.lang.String parameterName,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException
invoke findParameter(String) and setBigDecimal(int, BigDecimal) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setBigDecimal(int, BigDecimal)

setString

public void setString(java.lang.String parameterName,
                      java.lang.String x)
               throws java.sql.SQLException
invoke findParameter(String) and setString(int, String) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setString(int, String)

setBytes

public void setBytes(java.lang.String parameterName,
                     byte[] x)
              throws java.sql.SQLException
invoke findParameter(String) and setBytes(int, byte[]) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setBytes(int, byte[])

setDate

public void setDate(java.lang.String parameterName,
                    java.sql.Date x)
             throws java.sql.SQLException
invoke findParameter(String) and setDate(int, Date) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setDate(int, Date)

setTime

public void setTime(java.lang.String parameterName,
                    java.sql.Time x)
             throws java.sql.SQLException
invoke findParameter(String) and setTime(int, Time) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setTime(int, Time)

setTimestamp

public void setTimestamp(java.lang.String parameterName,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException
invoke findParameter(String) and setTimestamp(int, Timestamp) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setTimestamp(int, Timestamp)

setBlob

public void setBlob(java.lang.String parameterName,
                    java.sql.Blob x)
             throws java.sql.SQLException
invoke findParameter(String) and setBlob(int, Blob) method.

Parameters:
parameterName -
x - the parameter value
Throws:
java.sql.SQLException
See Also:
findParameter(String), setBlob(int, Blob)

setDate

public void setDate(java.lang.String parameterName,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
invoke findParameter(String) and setDate(int, Date, Calendar) method.

Parameters:
parameterName -
x - the parameter value
cal -
Throws:
java.sql.SQLException
See Also:
findParameter(String), setDate(int, Date, Calendar)

setTime

public void setTime(java.lang.String parameterName,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
invoke findParameter(String) and setTime(int, Time, Calendar) method.

Parameters:
parameterName -
x - the parameter value
cal -
Throws:
java.sql.SQLException
See Also:
findParameter(String), setTime(int, Time, Calendar)

setTimestamp

public void setTimestamp(java.lang.String parameterName,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException
invoke findParameter(String) and setTimestamp(int, Timestamp, Calendar) method.

Parameters:
parameterName -
x - the parameter value
cal -
Throws:
java.sql.SQLException
See Also:
findParameter(String), setTimestamp(int, Timestamp, Calendar)

findParameterName

public java.lang.String findParameterName(int parameterIndex)
                                   throws java.sql.SQLException
Retrieves the parameter name.
invoke org.sqlite.Statement#getParameterName(int) method.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getParameterName(int)

validateSqlType

public static void validateSqlType(int sqlType)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

executeUpdate

protected static int executeUpdate(Statement stmt)
                            throws java.sql.SQLException
Throws:
java.sql.SQLException