| java.lang.Object
 org.relique.jdbc.csv.CsvPreparedStatement
| CsvPreparedStatement | | public class CsvPreparedStatement implements PreparedStatement(Code) | | This class implements the PreparedStatement interface for the CsvJdbc driver.
author:
Zoran Milakovic |
| Method Summary | |
| public void | addBatch(String p0)
| | public void | addBatch()
| | public void | cancel()
| | public void | clearBatch()
| | public void | clearParameters()
| | public void | clearWarnings()
| | public void | close()
Releases this Statement object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
It is generally good practice to release resources as soon as
you are finished with them to avoid tying up database
resources.
Calling the method close on a Statement
object that is already closed has no effect.
Note: A Statement object is automatically closed
when it is garbage collected. | | public boolean | execute(String sql)
| | public boolean | execute(String sql, int autoGeneratedKeys)
| | public boolean | execute(String sql, int[] columnIndexes)
| | public boolean | execute(String sql, String[] columnNames)
| | public boolean | execute()
| | public int[] | executeBatch()
| | public ResultSet | executeQuery(String sql)
| | public ResultSet | executeQuery()
| | public int | executeUpdate(String sql)
| | public int | executeUpdate(String sql, int autoGeneratedKeys)
| | public int | executeUpdate(String sql, int[] columnIndexes)
| | public int | executeUpdate(String sql, String[] columnNames)
| | public int | executeUpdate()
| | public Connection | getConnection()
| | public int | getFetchDirection()
| | public int | getFetchSize()
| | public ResultSet | getGeneratedKeys()
| | public int | getMaxFieldSize()
| | public int | getMaxRows()
| | public ResultSetMetaData | getMetaData()
| | public boolean | getMoreResults()
| | public boolean | getMoreResults(int current)
| | public ParameterMetaData | getParameterMetaData()
| | public int | getQueryTimeout()
| | public ResultSet | getResultSet()
| | public int | getResultSetConcurrency()
| | public int | getResultSetHoldability()
| | public int | getResultSetType()
| | public String | getSqlStatement()
| | public int | getUpdateCount()
| | public SQLWarning | getWarnings()
| | public boolean | isClosed()
| | public boolean | isPoolable()
| | public boolean | isWrapperFor(Class iface)
| | public void | setArray(int i, Array x)
| | public void | setAsciiStream(int parameterIndex, InputStream x, int length)
| | public void | setAsciiStream(int parameterIndex, InputStream x)
| | public void | setAsciiStream(int parameterIndex, InputStream x, long length)
| | public void | setBigDecimal(int parameterIndex, BigDecimal value)
| | public void | setBinaryStream(int parameterIndex, InputStream value, int length)
| | public void | setBinaryStream(int parameterIndex, InputStream x)
| | public void | setBinaryStream(int parameterIndex, InputStream x, long length)
| | public void | setBlob(int parameterIndex, Blob value)
| | public void | setBlob(int parameterIndex, InputStream inputStream)
| | public void | setBlob(int parameterIndex, InputStream inputStream, long length)
| | public void | setBoolean(int parameterIndex, boolean value)
| | public void | setByte(int parameterIndex, byte value)
| | public void | setBytes(int parameterIndex, byte[] value)
| | public void | setCharacterStream(int parameterIndex, Reader reader, int length)
| | public void | setCharacterStream(int parameterIndex, Reader reader)
| | public void | setCharacterStream(int parameterIndex, Reader reader, long length)
| | public void | setClob(int i, Clob x)
| | public void | setClob(int parameterIndex, Reader reader)
| | public void | setClob(int parameterIndex, Reader reader, long length)
| | public void | setCursorName(String p0)
| | public void | setDate(int parameterIndex, Date value)
| | public void | setDate(int parameterIndex, Date x, Calendar cal)
| | public void | setDouble(int parameterIndex, double value)
| | public void | setEscapeProcessing(boolean p0)
| | public void | setFetchDirection(int p0)
| | public void | setFetchSize(int p0)
| | public void | setFloat(int parameterIndex, float value)
| | public void | setInt(int parameterIndex, int value)
| | public void | setLong(int parameterIndex, long value)
| | public void | setMaxFieldSize(int p0)
| | public void | setMaxRows(int p0)
| | public void | setNCharacterStream(int parameterIndex, Reader value)
| | public void | setNCharacterStream(int parameterIndex, Reader value, long length)
| | public void | setNClob(int parameterIndex, NClob value)
| | public void | setNClob(int parameterIndex, Reader reader)
| | public void | setNClob(int parameterIndex, Reader reader, long length)
| | public void | setNString(int parameterIndex, String value)
| | public void | setNull(int parameterIndex, int sqlType)
| | public void | setNull(int paramIndex, int sqlType, String typeName)
| | public void | setObject(int parameterIndex, Object x, int targetSqlType, int scale)
| | public void | setObject(int parameterIndex, Object x, int targetSqlType)
| | public void | setObject(int parameterIndex, Object x)
| | public void | setPoolable(boolean poolable)
| | public void | setQueryTimeout(int p0)
| | public void | setRef(int i, Ref x)
| | public void | setRowId(int parameterIndex, RowId x)
| | public void | setSQLXML(int parameterIndex, SQLXML xmlObject)
| | public void | setShort(int parameterIndex, short value)
| | public void | setString(int parameterIndex, String value)
Set String as parameter in sql statement. | | public void | setTime(int parameterIndex, Time value)
| | public void | setTime(int parameterIndex, Time x, Calendar cal)
| | public void | setTimestamp(int parameterIndex, Timestamp value)
| | public void | setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
| | public void | setURL(int parameterIndex, URL x)
| | public void | setUnicodeStream(int parameterIndex, InputStream x, int length)
| | public T | unwrap(Class<T> iface)
|
| PREPARE_SEPARATOR | | public static String PREPARE_SEPARATOR(Code) | | Name used for prepared statement parameters
|
| addBatch | | public void addBatch(String p0) throws SQLException(Code) | | Adds a feature to the Batch attribute of the CsvStatement object
Parameters:
p0 - The feature to be added to the Batch attribute
exception:
SQLException - Description of Exception |
| close | | public void close() throws SQLException(Code) | | Releases this Statement object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
It is generally good practice to release resources as soon as
you are finished with them to avoid tying up database
resources.
Calling the method close on a Statement
object that is already closed has no effect.
Note: A Statement object is automatically closed
when it is garbage collected. When a Statement object is
closed, its current ResultSet object, if one exists, is
also closed.
exception:
SQLException - if a database access error occurs |
| execute | | public boolean execute(String sql) throws SQLException(Code) | | Description of the Method
Parameters:
sql - Description of Parameter Description of the Returned Value
exception:
SQLException - Description of Exception |
| executeBatch | | public int[] executeBatch() throws SQLException(Code) | | Description of the Method
Description of the Returned Value
exception:
SQLException - Description of Exception |
| executeQuery | | public ResultSet executeQuery(String sql) throws SQLException(Code) | | Description of the Method
Parameters:
sql - Description of Parameter Description of the Returned Value
exception:
SQLException - Description of Exception |
| executeUpdate | | public int executeUpdate(String sql) throws SQLException(Code) | | Description of the Method
Parameters:
sql - Description of Parameter Description of the Returned Value
exception:
SQLException - Description of Exception |
| getConnection | | public Connection getConnection() throws SQLException(Code) | | Gets the connection attribute of the CsvStatement object
The connection value
exception:
SQLException - Description of Exception |
| getFetchDirection | | public int getFetchDirection() throws SQLException(Code) | | Gets the fetchDirection attribute of the CsvStatement object
The fetchDirection value
exception:
SQLException - Description of Exception |
| getFetchSize | | public int getFetchSize() throws SQLException(Code) | | Gets the fetchSize attribute of the CsvStatement object
The fetchSize value
exception:
SQLException - Description of Exception |
| getMaxFieldSize | | public int getMaxFieldSize() throws SQLException(Code) | | Gets the maxFieldSize attribute of the CsvStatement object
The maxFieldSize value
exception:
SQLException - Description of Exception |
| getMaxRows | | public int getMaxRows() throws SQLException(Code) | | Gets the maxRows attribute of the CsvStatement object
The maxRows value
exception:
SQLException - Description of Exception |
| getMoreResults | | public boolean getMoreResults() throws SQLException(Code) | | Gets the moreResults attribute of the CsvStatement object
The moreResults value
exception:
SQLException - Description of Exception |
| getQueryTimeout | | public int getQueryTimeout() throws SQLException(Code) | | Gets the queryTimeout attribute of the CsvStatement object
The queryTimeout value
exception:
SQLException - Description of Exception |
| getResultSet | | public ResultSet getResultSet() throws SQLException(Code) | | Gets the resultSet attribute of the CsvStatement object
The resultSet value
exception:
SQLException - Description of Exception |
| getResultSetConcurrency | | public int getResultSetConcurrency() throws SQLException(Code) | | Gets the resultSetConcurrency attribute of the CsvStatement object
The resultSetConcurrency value
exception:
SQLException - Description of Exception |
| getResultSetType | | public int getResultSetType() throws SQLException(Code) | | Gets the resultSetType attribute of the CsvStatement object
The resultSetType value
exception:
SQLException - Description of Exception |
| getUpdateCount | | public int getUpdateCount() throws SQLException(Code) | | Gets the updateCount attribute of the CsvStatement object
The updateCount value
exception:
SQLException - Description of Exception |
| setBoolean | | public void setBoolean(int parameterIndex, boolean value) throws SQLException(Code) | | |
| setBytes | | public void setBytes(int parameterIndex, byte[] value) throws SQLException(Code) | |
Parameters:
parameterIndex -
Parameters:
value -
throws:
SQLException - |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException(Code) | | |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException(Code) | | |
| setCursorName | | public void setCursorName(String p0) throws SQLException(Code) | | Sets the cursorName attribute of the CsvStatement object
Parameters:
p0 - The new cursorName value
exception:
SQLException - Description of Exception |
| setDouble | | public void setDouble(int parameterIndex, double value) throws SQLException(Code) | | |
| setEscapeProcessing | | public void setEscapeProcessing(boolean p0) throws SQLException(Code) | | Sets the escapeProcessing attribute of the CsvStatement object
Parameters:
p0 - The new escapeProcessing value
exception:
SQLException - Description of Exception |
| setFetchDirection | | public void setFetchDirection(int p0) throws SQLException(Code) | | Sets the fetchDirection attribute of the CsvStatement object
Parameters:
p0 - The new fetchDirection value
exception:
SQLException - Description of Exception |
| setFetchSize | | public void setFetchSize(int p0) throws SQLException(Code) | | Sets the fetchSize attribute of the CsvStatement object
Parameters:
p0 - The new fetchSize value
exception:
SQLException - Description of Exception |
| setMaxFieldSize | | public void setMaxFieldSize(int p0) throws SQLException(Code) | | Sets the maxFieldSize attribute of the CsvStatement object
Parameters:
p0 - The new maxFieldSize value
exception:
SQLException - Description of Exception |
| setMaxRows | | public void setMaxRows(int p0) throws SQLException(Code) | | Sets the maxRows attribute of the CsvStatement object
Parameters:
p0 - The new maxRows value
exception:
SQLException - Description of Exception |
| setNCharacterStream | | public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException(Code) | | |
| setQueryTimeout | | public void setQueryTimeout(int p0) throws SQLException(Code) | | Sets the queryTimeout attribute of the CsvStatement object
Parameters:
p0 - The new queryTimeout value
exception:
SQLException - Description of Exception |
| setString | | public void setString(int parameterIndex, String value) throws SQLException(Code) | | Set String as parameter in sql statement.
Parameters:
parameterIndex -
Parameters:
value -
throws:
SQLException - |
|
|