public class SimonPreparedStatement extends SimonStatement implements java.sql.PreparedStatement
PreparedStatement
Modifier and Type | Field and Description |
---|---|
protected java.lang.String |
sql
SQL string.
|
batchSql, conn, prefix, split, sqlCmdLabel, sqlNormalizer
Modifier and Type | Method and Description |
---|---|
void |
addBatch()
Adds prepared SQL command into batch list of sql and also into real batch.
|
void |
clearParameters() |
boolean |
execute()
Measure and execute prepared SQL operation.
|
java.sql.ResultSet |
executeQuery()
Measure and execute prepared SQL operation.
|
int |
executeUpdate()
Measure and execute prepared SQL operation.
|
java.sql.ResultSetMetaData |
getMetaData() |
java.sql.ParameterMetaData |
getParameterMetaData() |
void |
setArray(int i,
java.sql.Array array) |
void |
setAsciiStream(int i,
java.io.InputStream inputStream) |
void |
setAsciiStream(int i,
java.io.InputStream inputStream,
int i1) |
void |
setAsciiStream(int i,
java.io.InputStream inputStream,
long l) |
void |
setBigDecimal(int i,
java.math.BigDecimal bigDecimal) |
void |
setBinaryStream(int i,
java.io.InputStream inputStream) |
void |
setBinaryStream(int i,
java.io.InputStream inputStream,
int i1) |
void |
setBinaryStream(int i,
java.io.InputStream inputStream,
long l) |
void |
setBlob(int i,
java.sql.Blob blob) |
void |
setBlob(int i,
java.io.InputStream inputStream) |
void |
setBlob(int i,
java.io.InputStream inputStream,
long l) |
void |
setBoolean(int i,
boolean b) |
void |
setByte(int i,
byte b) |
void |
setBytes(int i,
byte[] bytes) |
void |
setCharacterStream(int i,
java.io.Reader reader) |
void |
setCharacterStream(int i,
java.io.Reader reader,
int i1) |
void |
setCharacterStream(int i,
java.io.Reader reader,
long l) |
void |
setClob(int i,
java.sql.Clob clob) |
void |
setClob(int i,
java.io.Reader reader) |
void |
setClob(int i,
java.io.Reader reader,
long l) |
void |
setDate(int i,
java.sql.Date date) |
void |
setDate(int i,
java.sql.Date date,
java.util.Calendar calendar) |
void |
setDouble(int i,
double v) |
void |
setFloat(int i,
float v) |
void |
setInt(int i,
int i1) |
void |
setLong(int i,
long l) |
void |
setNCharacterStream(int i,
java.io.Reader reader) |
void |
setNCharacterStream(int i,
java.io.Reader reader,
long l) |
void |
setNClob(int i,
java.sql.NClob nClob) |
void |
setNClob(int i,
java.io.Reader reader) |
void |
setNClob(int i,
java.io.Reader reader,
long l) |
void |
setNString(int i,
java.lang.String s) |
void |
setNull(int i,
int i1) |
void |
setNull(int i,
int i1,
java.lang.String s) |
void |
setObject(int i,
java.lang.Object o) |
void |
setObject(int i,
java.lang.Object o,
int i1) |
void |
setObject(int i,
java.lang.Object o,
int i1,
int i2) |
void |
setRef(int i,
java.sql.Ref ref) |
void |
setRowId(int i,
java.sql.RowId rowId) |
void |
setShort(int i,
short i1) |
void |
setSQLXML(int i,
java.sql.SQLXML sqlxml) |
void |
setString(int i,
java.lang.String s) |
void |
setTime(int i,
java.sql.Time time) |
void |
setTime(int i,
java.sql.Time time,
java.util.Calendar calendar) |
void |
setTimestamp(int i,
java.sql.Timestamp timestamp) |
void |
setTimestamp(int i,
java.sql.Timestamp timestamp,
java.util.Calendar calendar) |
void |
setUnicodeStream(int i,
java.io.InputStream inputStream,
int i1)
Deprecated.
|
void |
setURL(int i,
java.net.URL url) |
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finish, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, prepare, prepare, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, startSplit, unwrap
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
protected java.lang.String sql
public final java.sql.ResultSet executeQuery() throws java.sql.SQLException
executeQuery
in interface java.sql.PreparedStatement
java.sql.SQLException
- if real calls failspublic final int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
java.sql.SQLException
- if real calls failspublic final boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
true
if the first result is a ResultSet
object;
false
if it is an update count or there are no resultsjava.sql.SQLException
- if real calls failspublic final void addBatch() throws java.sql.SQLException
addBatch
in interface java.sql.PreparedStatement
java.sql.SQLException
- if real calls failspublic final void setNull(int i, int i1) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBoolean(int i, boolean b) throws java.sql.SQLException
setBoolean
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setByte(int i, byte b) throws java.sql.SQLException
setByte
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setShort(int i, short i1) throws java.sql.SQLException
setShort
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setInt(int i, int i1) throws java.sql.SQLException
setInt
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setLong(int i, long l) throws java.sql.SQLException
setLong
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setFloat(int i, float v) throws java.sql.SQLException
setFloat
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setDouble(int i, double v) throws java.sql.SQLException
setDouble
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBigDecimal(int i, java.math.BigDecimal bigDecimal) throws java.sql.SQLException
setBigDecimal
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setString(int i, java.lang.String s) throws java.sql.SQLException
setString
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBytes(int i, byte[] bytes) throws java.sql.SQLException
setBytes
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setDate(int i, java.sql.Date date) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setTime(int i, java.sql.Time time) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setTimestamp(int i, java.sql.Timestamp timestamp) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setAsciiStream(int i, java.io.InputStream inputStream, int i1) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
java.sql.SQLException
@Deprecated public final void setUnicodeStream(int i, java.io.InputStream inputStream, int i1) throws java.sql.SQLException
setUnicodeStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBinaryStream(int i, java.io.InputStream inputStream, int i1) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void clearParameters() throws java.sql.SQLException
clearParameters
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setObject(int i, java.lang.Object o, int i1) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setObject(int i, java.lang.Object o) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setObject(int i, java.lang.Object o, int i1, int i2) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setCharacterStream(int i, java.io.Reader reader, int i1) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setRef(int i, java.sql.Ref ref) throws java.sql.SQLException
setRef
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBlob(int i, java.sql.Blob blob) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setClob(int i, java.sql.Clob clob) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setArray(int i, java.sql.Array array) throws java.sql.SQLException
setArray
in interface java.sql.PreparedStatement
java.sql.SQLException
public final java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setDate(int i, java.sql.Date date, java.util.Calendar calendar) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setTime(int i, java.sql.Time time, java.util.Calendar calendar) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setTimestamp(int i, java.sql.Timestamp timestamp, java.util.Calendar calendar) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNull(int i, int i1, java.lang.String s) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setURL(int i, java.net.URL url) throws java.sql.SQLException
setURL
in interface java.sql.PreparedStatement
java.sql.SQLException
public final java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
getParameterMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setRowId(int i, java.sql.RowId rowId) throws java.sql.SQLException
setRowId
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNString(int i, java.lang.String s) throws java.sql.SQLException
setNString
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNCharacterStream(int i, java.io.Reader reader, long l) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNClob(int i, java.sql.NClob nClob) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setClob(int i, java.io.Reader reader, long l) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBlob(int i, java.io.InputStream inputStream, long l) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNClob(int i, java.io.Reader reader, long l) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setSQLXML(int i, java.sql.SQLXML sqlxml) throws java.sql.SQLException
setSQLXML
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setAsciiStream(int i, java.io.InputStream inputStream, long l) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBinaryStream(int i, java.io.InputStream inputStream, long l) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setCharacterStream(int i, java.io.Reader reader, long l) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setAsciiStream(int i, java.io.InputStream inputStream) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBinaryStream(int i, java.io.InputStream inputStream) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setCharacterStream(int i, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNCharacterStream(int i, java.io.Reader reader) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setClob(int i, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setBlob(int i, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
public final void setNClob(int i, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
Copyright © 2018. All Rights Reserved.