OrientJdbcPreparedStatement (OrientDB 2.2.1-SNAPSHOT API)

java.lang.Object
- com.orientechnologies.orient.jdbc.OrientJdbcStatement
- - com.orientechnologies.orient.jdbc.OrientJdbcPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper
```
public class OrientJdbcPreparedStatement
extends OrientJdbcStatement
implements PreparedStatement
```
Author:

Roberto Franchini (CELI Srl - [email protected]), Salvatore Piccione (TXT e-solutions SpA - [email protected]), Luca Garulli (l.garulli--at--orientechnologies.com)

Field Summary

Fields
Modifier and Type Field and Description

protected Map<Integer,Object> params

protected String sql
- Fields inherited from class com.orientechnologies.orient.jdbc.OrientJdbcStatement
  batches, closed, connection, database, documents, query, rawResult, resultSet, resultSetConcurrency, resultSetHoldability, resultSetType
- 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

Fields
Modifier and Type	Field and Description
`protected Map<Integer,Object>`	`params`
`protected String`	`sql`

Constructor Summary

Constructors
Constructor and Description
`OrientJdbcPreparedStatement(OrientJdbcConnection iConnection, int resultSetType, int resultSetConcurrency, int resultSetHoldability, String sql)`
`OrientJdbcPreparedStatement(OrientJdbcConnection iConnection, int resultSetType, int resultSetConcurrency, String sql)`
`OrientJdbcPreparedStatement(OrientJdbcConnection iConnection, String sql)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addBatch()`
`void`	`clearParameters()`
`boolean`	`execute()`
`protected <RET> RET`	`executeCommand(OCommandRequest query)`
`ResultSet`	`executeQuery()`
`int`	`executeUpdate()`
`ResultSetMetaData`	`getMetaData()`
`ParameterMetaData`	`getParameterMetaData()`
`void`	`setArray(int parameterIndex, Array x)`
`void`	`setAsciiStream(int parameterIndex, InputStream x)`
`void`	`setAsciiStream(int parameterIndex, InputStream x, int length)`
`void`	`setAsciiStream(int parameterIndex, InputStream x, long length)`
`void`	`setBigDecimal(int parameterIndex, BigDecimal x)`
`void`	`setBinaryStream(int parameterIndex, InputStream x)`
`void`	`setBinaryStream(int parameterIndex, InputStream x, int length)`
`void`	`setBinaryStream(int parameterIndex, InputStream x, long length)`
`void`	`setBlob(int parameterIndex, Blob x)`
`void`	`setBlob(int parameterIndex, InputStream inputStream)`
`void`	`setBlob(int parameterIndex, InputStream inputStream, long length)`
`void`	`setBoolean(int parameterIndex, boolean x)`
`void`	`setByte(int parameterIndex, byte x)`
`void`	`setBytes(int parameterIndex, byte[] x)`
`void`	`setCharacterStream(int parameterIndex, Reader reader)`
`void`	`setCharacterStream(int parameterIndex, Reader reader, int length)`
`void`	`setCharacterStream(int parameterIndex, Reader reader, long length)`
`void`	`setClob(int parameterIndex, Clob x)`
`void`	`setClob(int parameterIndex, Reader reader)`
`void`	`setClob(int parameterIndex, Reader reader, long length)`
`void`	`setDate(int parameterIndex, Date x)`
`void`	`setDate(int parameterIndex, Date x, Calendar cal)`
`void`	`setDouble(int parameterIndex, double x)`
`void`	`setFloat(int parameterIndex, float x)`
`void`	`setInt(int parameterIndex, int x)`
`void`	`setLong(int parameterIndex, long x)`
`void`	`setNCharacterStream(int parameterIndex, Reader value)`
`void`	`setNCharacterStream(int parameterIndex, Reader value, long length)`
`void`	`setNClob(int parameterIndex, NClob value)`
`void`	`setNClob(int parameterIndex, Reader reader)`
`void`	`setNClob(int parameterIndex, Reader reader, long length)`
`void`	`setNString(int parameterIndex, String value)`
`void`	`setNull(int parameterIndex, int sqlType)`
`void`	`setNull(int parameterIndex, int sqlType, String typeName)`
`void`	`setObject(int parameterIndex, Object x)`
`void`	`setObject(int parameterIndex, Object x, int targetSqlType)`
`void`	`setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)`
`void`	`setRef(int parameterIndex, Ref x)`
`void`	`setRowId(int parameterIndex, RowId x)`
`void`	`setShort(int parameterIndex, short x)`
`void`	`setSQLXML(int parameterIndex, SQLXML xmlObject)`
`void`	`setString(int parameterIndex, String x)`
`void`	`setTime(int parameterIndex, Time x)`
`void`	`setTime(int parameterIndex, Time x, Calendar cal)`
`void`	`setTimestamp(int parameterIndex, Timestamp x)`
`void`	`setTimestamp(int parameterIndex, Timestamp x, Calendar cal)`
`void`	`setUnicodeStream(int parameterIndex, InputStream x, int length)`
`void`	`setURL(int parameterIndex, URL x)`

Methods inherited from class com.orientechnologies.orient.jdbc.OrientJdbcStatement
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, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Field Detail

sql
```
protected final String sql
```

params

protected final Map<Integer,Object> params

Constructor Detail

OrientJdbcPreparedStatement

public OrientJdbcPreparedStatement(OrientJdbcConnection iConnection,
                                   String sql)

OrientJdbcPreparedStatement

public OrientJdbcPreparedStatement(OrientJdbcConnection iConnection,
                                   int resultSetType,
                                   int resultSetConcurrency,
                                   String sql)
                            throws SQLException

Throws:: SQLException

OrientJdbcPreparedStatement

public OrientJdbcPreparedStatement(OrientJdbcConnection iConnection,
                                   int resultSetType,
                                   int resultSetConcurrency,
                                   int resultSetHoldability,
                                   String sql)

Method Detail

executeQuery
```
public ResultSet executeQuery()
                       throws SQLException
```
Specified by:

executeQuery in interface PreparedStatement

Throws:

SQLException

executeUpdate
```
public int executeUpdate()
                  throws SQLException
```
Specified by:

executeUpdate in interface PreparedStatement

Throws:

SQLException

executeCommand

protected <RET> RET executeCommand(OCommandRequest query)
                            throws SQLException

Overrides:: executeCommand in class OrientJdbcStatement
Throws:: SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws SQLException

Specified by:: setNull in interface PreparedStatement
Throws:: SQLException

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)
                throws SQLException

Specified by:: setBoolean in interface PreparedStatement
Throws:: SQLException

setByte

public void setByte(int parameterIndex,
                    byte x)
             throws SQLException

Specified by:: setByte in interface PreparedStatement
Throws:: SQLException

setShort

public void setShort(int parameterIndex,
                     short x)
              throws SQLException

Specified by:: setShort in interface PreparedStatement
Throws:: SQLException

setInt

public void setInt(int parameterIndex,
                   int x)
            throws SQLException

Specified by:: setInt in interface PreparedStatement
Throws:: SQLException

setLong

public void setLong(int parameterIndex,
                    long x)
             throws SQLException

Specified by:: setLong in interface PreparedStatement
Throws:: SQLException

setFloat

public void setFloat(int parameterIndex,
                     float x)
              throws SQLException

Specified by:: setFloat in interface PreparedStatement
Throws:: SQLException

setDouble

public void setDouble(int parameterIndex,
                      double x)
               throws SQLException

Specified by:: setDouble in interface PreparedStatement
Throws:: SQLException

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          BigDecimal x)
                   throws SQLException

Specified by:: setBigDecimal in interface PreparedStatement
Throws:: SQLException

setString

public void setString(int parameterIndex,
                      String x)
               throws SQLException

Specified by:: setString in interface PreparedStatement
Throws:: SQLException

setBytes

public void setBytes(int parameterIndex,
                     byte[] x)
              throws SQLException

Specified by:: setBytes in interface PreparedStatement
Throws:: SQLException

setDate

public void setDate(int parameterIndex,
                    Date x)
             throws SQLException

Specified by:: setDate in interface PreparedStatement
Throws:: SQLException

setTime

public void setTime(int parameterIndex,
                    Time x)
             throws SQLException

Specified by:: setTime in interface PreparedStatement
Throws:: SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         Timestamp x)
                  throws SQLException

Specified by:: setTimestamp in interface PreparedStatement
Throws:: SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           int length)
                    throws SQLException

Specified by:: setAsciiStream in interface PreparedStatement
Throws:: SQLException

setUnicodeStream

public void setUnicodeStream(int parameterIndex,
                             InputStream x,
                             int length)
                      throws SQLException

Specified by:: setUnicodeStream in interface PreparedStatement
Throws:: SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            int length)
                     throws SQLException

Specified by:: setBinaryStream in interface PreparedStatement
Throws:: SQLException

clearParameters
```
public void clearParameters()
                     throws SQLException
```
Specified by:

clearParameters in interface PreparedStatement

Throws:

SQLException

setObject

public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType)
               throws SQLException

Specified by:: setObject in interface PreparedStatement
Throws:: SQLException

setObject

public void setObject(int parameterIndex,
                      Object x)
               throws SQLException

Specified by:: setObject in interface PreparedStatement
Throws:: SQLException

execute
```
public boolean execute()
                throws SQLException
```
Specified by:

execute in interface PreparedStatement

Throws:

SQLException

addBatch
```
public void addBatch()
              throws SQLException
```
Specified by:

addBatch in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               int length)
                        throws SQLException

Specified by:: setCharacterStream in interface PreparedStatement
Throws:: SQLException

setRef

public void setRef(int parameterIndex,
                   Ref x)
            throws SQLException

Specified by:: setRef in interface PreparedStatement
Throws:: SQLException

setBlob

public void setBlob(int parameterIndex,
                    Blob x)
             throws SQLException

Specified by:: setBlob in interface PreparedStatement
Throws:: SQLException

setClob

public void setClob(int parameterIndex,
                    Clob x)
             throws SQLException

Specified by:: setClob in interface PreparedStatement
Throws:: SQLException

setArray

public void setArray(int parameterIndex,
                     Array x)
              throws SQLException

Specified by:: setArray in interface PreparedStatement
Throws:: SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Specified by:: getMetaData in interface PreparedStatement
Throws:: SQLException

setDate

public void setDate(int parameterIndex,
                    Date x,
                    Calendar cal)
             throws SQLException

Specified by:: setDate in interface PreparedStatement
Throws:: SQLException

setTime

public void setTime(int parameterIndex,
                    Time x,
                    Calendar cal)
             throws SQLException

Specified by:: setTime in interface PreparedStatement
Throws:: SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         Timestamp x,
                         Calendar cal)
                  throws SQLException

Specified by:: setTimestamp in interface PreparedStatement
Throws:: SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType,
                    String typeName)
             throws SQLException

Specified by:: setNull in interface PreparedStatement
Throws:: SQLException

setURL

public void setURL(int parameterIndex,
                   URL x)
            throws SQLException

Specified by:: setURL in interface PreparedStatement
Throws:: SQLException

getParameterMetaData

public ParameterMetaData getParameterMetaData()
                                       throws SQLException

Specified by:: getParameterMetaData in interface PreparedStatement
Throws:: SQLException

setRowId

public void setRowId(int parameterIndex,
                     RowId x)
              throws SQLException

Specified by:: setRowId in interface PreparedStatement
Throws:: SQLException

setNString

public void setNString(int parameterIndex,
                       String value)
                throws SQLException

Specified by:: setNString in interface PreparedStatement
Throws:: SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader value,
                                long length)
                         throws SQLException

Specified by:: setNCharacterStream in interface PreparedStatement
Throws:: SQLException

setNClob

public void setNClob(int parameterIndex,
                     NClob value)
              throws SQLException

Specified by:: setNClob in interface PreparedStatement
Throws:: SQLException

setClob

public void setClob(int parameterIndex,
                    Reader reader,
                    long length)
             throws SQLException

Specified by:: setClob in interface PreparedStatement
Throws:: SQLException

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream,
                    long length)
             throws SQLException

Specified by:: setBlob in interface PreparedStatement
Throws:: SQLException

setNClob

public void setNClob(int parameterIndex,
                     Reader reader,
                     long length)
              throws SQLException

Specified by:: setNClob in interface PreparedStatement
Throws:: SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      SQLXML xmlObject)
               throws SQLException

Specified by:: setSQLXML in interface PreparedStatement
Throws:: SQLException

setObject

public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType,
                      int scaleOrLength)
               throws SQLException

Specified by:: setObject in interface PreparedStatement
Throws:: SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           long length)
                    throws SQLException

Specified by:: setAsciiStream in interface PreparedStatement
Throws:: SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            long length)
                     throws SQLException

Specified by:: setBinaryStream in interface PreparedStatement
Throws:: SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               long length)
                        throws SQLException

Specified by:: setCharacterStream in interface PreparedStatement
Throws:: SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x)
                    throws SQLException

Specified by:: setAsciiStream in interface PreparedStatement
Throws:: SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x)
                     throws SQLException

Specified by:: setBinaryStream in interface PreparedStatement
Throws:: SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader)
                        throws SQLException

Specified by:: setCharacterStream in interface PreparedStatement
Throws:: SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader value)
                         throws SQLException

Specified by:: setNCharacterStream in interface PreparedStatement
Throws:: SQLException

setClob

public void setClob(int parameterIndex,
                    Reader reader)
             throws SQLException

Specified by:: setClob in interface PreparedStatement
Throws:: SQLException

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream)
             throws SQLException

Specified by:: setBlob in interface PreparedStatement
Throws:: SQLException

setNClob

public void setNClob(int parameterIndex,
                     Reader reader)
              throws SQLException

Specified by:: setNClob in interface PreparedStatement
Throws:: SQLException

Class OrientJdbcPreparedStatement

Field Summary

Fields inherited from class com.orientechnologies.orient.jdbc.OrientJdbcStatement

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class com.orientechnologies.orient.jdbc.OrientJdbcStatement

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Field Detail

sql

params

Constructor Detail

OrientJdbcPreparedStatement

OrientJdbcPreparedStatement

OrientJdbcPreparedStatement

Method Detail

executeQuery

executeUpdate

executeCommand

setNull

setBoolean

setByte

setShort

setInt

setLong

setFloat

setDouble

setBigDecimal

setString

setBytes

setDate

setTime

setTimestamp

setAsciiStream

setUnicodeStream

setBinaryStream

clearParameters

setObject

setObject

execute

addBatch

setCharacterStream

setRef

setBlob

setClob

setArray

getMetaData

setDate

setTime

setTimestamp

setNull

setURL

getParameterMetaData

setRowId

setNString

setNCharacterStream

setNClob

setClob

setBlob

setNClob

setSQLXML

setObject

setAsciiStream

setBinaryStream

setCharacterStream

setAsciiStream

setBinaryStream

setCharacterStream

setNCharacterStream

setClob

setBlob

setNClob