Version: 7.0.0

java.sql.PreparedStatement ​

java.sql.PreparedStatement is the prepared statement interface.

Table 1 Support for java.sql.PreparedStatement

Method Name

Return Value Type

JDBC 4 Supported

clearParameters()

void

Yes

execute()

Boolean

Yes

executeQuery()

ResultSet

Yes

executeUpdate()

int

Yes

getMetaData()

ResultSetMetaData

Yes

getParameterMetaData()

ParameterMetaData

Yes

setArray​(int parameterIndex, Array x)

void

Yes

setAsciiStream​(int parameterIndex, InputStream x, int length)

void

Yes

setBinaryStream​(int parameterIndex, InputStream x)

void

Yes

setBinaryStream​(int parameterIndex, InputStream x, int length)

void

Yes

setBinaryStream​(int parameterIndex, InputStream x, long length)

void

Yes

setBlob​(int parameterIndex, InputStream inputStream)

void

Yes

setBlob​(int parameterIndex, InputStream inputStream, long length)

void

Yes

setBlob​(int parameterIndex, Blob x)

void

Yes

setCharacterStream​(int parameterIndex, Reader reader)

void

Yes

setCharacterStream​(int parameterIndex, Reader reader, int length)

void

Yes

setClob​(int parameterIndex, Reader reader)

void

Yes

setClob​(int parameterIndex, Reader reader, long length)

void

Yes

setClob​(int parameterIndex, Clob x)

void

Yes

setDate​(int parameterIndex, Date x, Calendar cal)

void

Yes

setNull​(int parameterIndex, int sqlType)

void

Yes

setNull​(int parameterIndex, int sqlType, String typeName)

void

Yes

setObject​(int parameterIndex, Object x)

void

Yes

setObject​(int parameterIndex, Object x, int targetSqlType)

void

Yes

setObject​(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)

void

Yes

setSQLXML​(int parameterIndex, SQLXML xmlObject)

void

Yes

setTime​(int parameterIndex, Time x)

void

Yes

setTime​(int parameterIndex, Time x, Calendar cal)

void

Yes

setTimestamp​(int parameterIndex, Timestamp x)

void

Yes

setTimestamp​(int parameterIndex, Timestamp x, Calendar cal)

void

Yes

setUnicodeStream(int parameterIndex, InputStream x, int length)

void

Yes

setURL(int parameterIndex, URL x)

void

Yes

setBoolean(int parameterIndex, boolean x)

void

Yes

setBigDecimal(int parameterIndex, BigDecimal x)

void

Yes

setByte(int parameterIndex, byte x)

void

Yes

setBytes(int parameterIndex, byte[] x)

void

Yes

setDate(int parameterIndex, Date x)

void

Yes

setDouble(int parameterIndex, double x)

void

Yes

setFloat(int parameterIndex, float x)

void

Yes

setInt(int parameterIndex, int x)

void

Yes

setLong(int parameterIndex, long x)

void

Yes

setShort(int parameterIndex, short x)

void

Yes

setString(int parameterIndex, String x)

void

Yes

setNString(int parameterIndex, String x)

void

Yes

addBatch()

void

Yes

executeBatch()

int[]

Yes

NOTE

  • addBatch() and execute() must be executed after clearBatch().
  • Calling the executeBatch() method does not clear the batch. Users must explicitly use clearBatch() to clear it.
  • After adding bind variables for a batch, if users want to reuse these values (to add another batch), they do not need to call the set*() method again.
  • The following methods are inherited from java.sql.Statement: close, execute, executeQuery, executeUpdate, getConnection, getResultSet, getUpdateCount, isClosed, setMaxRows, and setFetchSize.
  • The executeLargeUpdate() method must be used with JDBC 4.2 or later.
  • The targetSqlType parameter of the setObject(int parameterIndex, Object x, int targetSqlType) method does not support the blob or clob type.
Copyright © openGauss 2026. All rights reserved.
TrademarkPrivacy StatementLegal NoticeAbout Cookies
TrademarkPrivacy StatementLegal NoticeAbout Cookies
Copyright © openGauss 2026. All rights reserved.