UCanAccess 5.2.0 · net.ucanaccess.jdbc.UcanaccessPreparedStatement

Modifier and Type	Class and Description
private class	UcanaccessPreparedStatement.ParameterReset

Modifier and Type	Field and Description
private final Map<Integer, UcanaccessPreparedStatement.ParameterReset>	memento
private String	sql
private PreparedStatement	wrappedPs

Access	Constructor and Description
public	UcanaccessPreparedStatement(NormalizedSQL nsql, PreparedStatement hidden, UcanaccessConnection conn)
public	UcanaccessPreparedStatement(String sql, UcanaccessConnection connection)

Method Summary

Modifier and Type	Method and Description
public void	addBatch() Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
private void	addMementoEntry(String methodName, Class<?>[] argClasses, Object... args)
public void	clearParameters() Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
public boolean	execute() Implements java.sql.PreparedStatement.execute. Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
public ResultSet	executeQuery() Implements java.sql.PreparedStatement.executeQuery. Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
public int	executeUpdate() Implements java.sql.PreparedStatement.executeUpdate. Executes the SQL statement in this `PreparedStatement` object, which must be an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement.
public ResultSetMetaData	getMetaData() Implements java.sql.PreparedStatement.getMetaData. Retrieves a `ResultSetMetaData` object that contains information about the columns of the `ResultSet` object that will be returned when this `PreparedStatement` object is executed.
public ParameterMetaData	getParameterMetaData() Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
private Object	mapLocalTimeToLocalDateTime(Object x)
private Object	mapToBlob(Object x)
private InputStream	markableInputStream(InputStream is)
private InputStream	markableInputStream(InputStream is, long l)
private Reader	markableReader(Reader r)
private Reader	markableReader(Reader r, long l)
private void	parametersReset()
private void	preprocess()
protected void	reset() Overrides net.ucanaccess.jdbc.UcanaccessStatement.reset.
private void	resetInputStream(InputStream is)
private void	resetReader(Reader r)
public void	setArray(int parmIdx, Array array) Implements java.sql.PreparedStatement.setArray. Sets the designated parameter to the given `java.sql.Array` object.
public void	setAsciiStream(int parmIdx, InputStream is) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream.
public void	setAsciiStream(int parmIdx, InputStream is, int length) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setAsciiStream(int parmIdx, InputStream is, long length) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBigDecimal(int parmIdx, BigDecimal dec) Implements java.sql.PreparedStatement.setBigDecimal. Sets the designated parameter to the given `java.math.BigDecimal` value.
public void	setBinaryStream(int parmIdx, InputStream is) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public void	setBinaryStream(int parmIdx, InputStream is, int length) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBinaryStream(int parmIdx, InputStream is, long length) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBlob(int parmIdx, Blob blob) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to the given `java.sql.Blob` object.
public void	setBlob(int parmIdx, InputStream is) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public void	setBlob(int parmIdx, InputStream is, long length) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public void	setBoolean(int parmIdx, boolean bool) Implements java.sql.PreparedStatement.setBoolean. Sets the designated parameter to the given Java `boolean` value.
public void	setByte(int parmIdx, byte b) Implements java.sql.PreparedStatement.setByte. Sets the designated parameter to the given Java `byte` value.
public void	setBytes(int parmIdx, byte[] bytes) Implements java.sql.PreparedStatement.setBytes. Sets the designated parameter to the given Java array of bytes.
public void	setCharacterStream(int parmIdx, Reader reader) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public void	setCharacterStream(int parmIdx, Reader reader, int length) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setCharacterStream(int parmIdx, Reader reader, long length) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setClob(int parmIdx, Clob clob) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to the given `java.sql.Clob` object.
public void	setClob(int parmIdx, Reader reader) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setClob(int parmIdx, Reader reader, long length) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setCursorName(String name) Overrides net.ucanaccess.jdbc.UcanaccessStatement.setCursorName. Implements java.sql.Statement.setCursorName. Sets the SQL cursor name to the given `String`, which will be used by subsequent `Statement` object `execute` methods.
public void	setDate(int parmIdx, Date date) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
public void	setDate(int parmIdx, Date date, Calendar cal) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
public void	setDouble(int parmIdx, double d) Implements java.sql.PreparedStatement.setDouble. Sets the designated parameter to the given Java `double` value.
public void	setFloat(int parmIdx, float f) Implements java.sql.PreparedStatement.setFloat. Sets the designated parameter to the given Java `float` value.
public void	setInt(int parmIdx, int i) Implements java.sql.PreparedStatement.setInt. Sets the designated parameter to the given Java `int` value.
public void	setLong(int parmIdx, long l) Implements java.sql.PreparedStatement.setLong. Sets the designated parameter to the given Java `long` value.
public void	setNCharacterStream(int parmIdx, Reader reader) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNCharacterStream(int parmIdx, Reader reader, long l) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNClob(int parmIdx, NClob nclob) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public void	setNClob(int parmIdx, Reader reader) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNClob(int parmIdx, Reader reader, long length) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNString(int parmIdx, String string) Implements java.sql.PreparedStatement.setNString. Sets the designated parameter to the given `String` object.
public void	setNull(int parmIdx, int sqlt) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setNull(int parmIdx, int sqlt, String tn) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setObject(int parmIdx, Object x) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter using the given object.
public void	setObject(int parmIdx, Object obj, int tsqlt) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(int parmIdx, Object object, int tsqlt, int sol) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setRef(int parmIdx, Ref ref) Implements java.sql.PreparedStatement.setRef. Sets the designated parameter to the given `REF(<structured-type>)` value.
public void	setRowId(int parmIdx, RowId rowId) Implements java.sql.PreparedStatement.setRowId. Sets the designated parameter to the given `java.sql.RowId` object.
public void	setShort(int parmIdx, short sht) Implements java.sql.PreparedStatement.setShort. Sets the designated parameter to the given Java `short` value.
public void	setSQLXML(int parmIdx, SQLXML sx) Implements java.sql.PreparedStatement.setSQLXML. Sets the designated parameter to the given `java.sql.SQLXML` object.
public void	setString(int parmIdx, String string) Implements java.sql.PreparedStatement.setString. Sets the designated parameter to the given Java `String` value.
public void	setTime(int parmIdx, Time time) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value.
public void	setTime(int parmIdx, Time time, Calendar cal) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
public void	setTimestamp(int parmIdx, Timestamp ts) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value.
public void	setTimestamp(int parmIdx, Timestamp ts, Calendar cal) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public void	setUnicodeStream(int parmIdx, InputStream is, int length) Implements java.sql.PreparedStatement.setUnicodeStream. Deprecated Use `setCharacterStream` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setURL(int parmIdx, URL url) Implements java.sql.PreparedStatement.setURL. Sets the designated parameter to the given `java.net.URL` value.
public <T> T	unwrap(Class<T> iface) Overrides net.ucanaccess.jdbc.UcanaccessStatement.unwrap. Implements java.sql.Wrapper.unwrap. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public Class UcanaccessPreparedStatement

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary