Table of Contents

Class PreparedStatement

Namespace
Java.Sql
Assembly
MASES.JNet.dll

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html

public class PreparedStatement : Statement, IDynamicMetaObjectProvider, IJVMBridgeCore, IDisposable, IJVMBridgeBaseStatic, IJVMBridgeBase, IJVMBridgeDefinition, IPreparedStatement, IStatement
Inheritance
JVMBridgeBase
JVMBridgeBase<Statement>
PreparedStatement
Implements
IJVMBridgeCore
IJVMBridgeBaseStatic
IJVMBridgeBase
IJVMBridgeDefinition
Derived
Inherited Members
JVMBridgeBase<Statement>.IsAssignableFrom(IJavaType)
JVMBridgeBase<Statement>.IsAssignableFrom<T>()
JVMBridgeBase<Statement>.Execute<T>(params T[])
JVMBridgeBase<Statement>.DynBridgeClazz
JVMBridgeBase<Statement>.BridgeClazz
JVMBridgeBase.RuntimeClassNameOf<T>()
JVMBridgeBase.ClassNameOf<T>()
JVMBridgeBase.ClassOf<T>()
JVMBridgeBase.WrapsDirect<TNewClass>(IJavaObject)
JVMBridgeBase.Wraps<TNewClass>(IJavaObject)
JVMBridgeBase.Wraps<TNewClass, TReturn>(IJavaObject)
JVMBridgeBase.Wraps<TNewClass, TReturn, TConverter>(IJavaObject)
JVMBridgeBase.MonitorEnter()
JVMBridgeBase.MonitorExit()
JVMBridgeBase.IsInstanceOf(IJavaType)
JVMBridgeBase.IsInstanceOf<T>()
JVMBridgeBase.RuntimeIsInstanceOf<T>()
JVMBridgeBase.CastTo<TNewClass>()
JVMBridgeBase.CastDirect<TNewClass>()
JVMBridgeBase.Dispose()
JVMBridgeBase.ToString()
JVMBridgeBase.GetHashCode()
JVMBridgeBase.Notify()
JVMBridgeBase.NotifyAll()
JVMBridgeBase.Wait()
JVMBridgeBase.DynBridgeInstance
JVMBridgeBase.BridgeInstance
JVMBridgeBase.IsBridgeListener
Extension Methods

Constructors

PreparedStatement()

Default constructor: even if the corresponding Java class does not have one, it is mandatory for JCOBridge

[Obsolete("PreparedStatement class represents, in .NET, an instance of a JVM interface or abstract class. This public initializer is needed for JCOBridge internal use, other uses can produce unidentible behaviors.")]
public PreparedStatement()

PreparedStatement(params object[])

Generic constructor: it is useful for JCOBridge when there is a derived class which needs to pass arguments to the highest JVMBridgeBase class

[Obsolete("PreparedStatement class represents, in .NET, an instance of a JVM interface or abstract class. This public initializer is needed for JCOBridge internal use, other uses can produce unidentible behaviors.")]
public PreparedStatement(params object[] args)

Parameters

args object[]

Properties

BridgeClassName

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_BridgeClassName.htm

public override string BridgeClassName { get; }

Property Value

string

IsBridgeAbstract

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeAbstract.htm

public override bool IsBridgeAbstract { get; }

Property Value

bool

IsBridgeCloseable

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeCloseable.htm

public override bool IsBridgeCloseable { get; }

Property Value

bool

IsBridgeInterface

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeInterface.htm

public override bool IsBridgeInterface { get; }

Property Value

bool

IsBridgeStatic

https://www.jcobridge.com/api-clr/html/P_MASES_JCOBridge_C2JBridge_JVMBridgeBase_IsBridgeStatic.htm

public override bool IsBridgeStatic { get; }

Property Value

bool

MetaData

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#getMetaData()

public ResultSetMetaData MetaData { get; }

Property Value

ResultSetMetaData

ParameterMetaData

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#getParameterMetaData()

public ParameterMetaData ParameterMetaData { get; }

Property Value

ParameterMetaData

Methods

AddBatch()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#addBatch()

public void AddBatch()

Exceptions

SQLException

ClearParameters()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#clearParameters()

public void ClearParameters()

Exceptions

SQLException

Execute()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#execute()

public bool Execute()

Returns

bool

bool

Exceptions

SQLException

ExecuteLargeUpdate()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#executeLargeUpdate()

public long ExecuteLargeUpdate()

Returns

long

long

Exceptions

SQLException

ExecuteQuery()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#executeQuery()

public ResultSet ExecuteQuery()

Returns

ResultSet

ResultSet

Exceptions

SQLException

ExecuteUpdate()

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#executeUpdate()

public int ExecuteUpdate()

Returns

int

int

Exceptions

SQLException

SetArray(int, Array)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setArray(int,java.sql.Array)

public void SetArray(int arg0, Array arg1)

Parameters

arg0 int

int

arg1 Array

Array

Exceptions

SQLException

SetAsciiStream(int, InputStream)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setAsciiStream(int,java.io.InputStream)

public void SetAsciiStream(int arg0, InputStream arg1)

Parameters

arg0 int

int

arg1 InputStream

InputStream

Exceptions

SQLException

SetAsciiStream(int, InputStream, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setAsciiStream(int,java.io.InputStream,int)

public void SetAsciiStream(int arg0, InputStream arg1, int arg2)

Parameters

arg0 int

int

arg1 InputStream

InputStream

arg2 int

int

Exceptions

SQLException

SetAsciiStream(int, InputStream, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setAsciiStream(int,java.io.InputStream,long)

public void SetAsciiStream(int arg0, InputStream arg1, long arg2)

Parameters

arg0 int

int

arg1 InputStream

InputStream

arg2 long

long

Exceptions

SQLException

SetBigDecimal(int, BigDecimal)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBigDecimal(int,java.math.BigDecimal)

public void SetBigDecimal(int arg0, BigDecimal arg1)

Parameters

arg0 int

int

arg1 BigDecimal

BigDecimal

Exceptions

SQLException

SetBinaryStream(int, InputStream)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBinaryStream(int,java.io.InputStream)

public void SetBinaryStream(int arg0, InputStream arg1)

Parameters

arg0 int

int

arg1 InputStream

InputStream

Exceptions

SQLException

SetBinaryStream(int, InputStream, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBinaryStream(int,java.io.InputStream,int)

public void SetBinaryStream(int arg0, InputStream arg1, int arg2)

Parameters

arg0 int

int

arg1 InputStream

InputStream

arg2 int

int

Exceptions

SQLException

SetBinaryStream(int, InputStream, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBinaryStream(int,java.io.InputStream,long)

public void SetBinaryStream(int arg0, InputStream arg1, long arg2)

Parameters

arg0 int

int

arg1 InputStream

InputStream

arg2 long

long

Exceptions

SQLException

SetBlob(int, InputStream)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBlob(int,java.io.InputStream)

public void SetBlob(int arg0, InputStream arg1)

Parameters

arg0 int

int

arg1 InputStream

InputStream

Exceptions

SQLException

SetBlob(int, InputStream, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBlob(int,java.io.InputStream,long)

public void SetBlob(int arg0, InputStream arg1, long arg2)

Parameters

arg0 int

int

arg1 InputStream

InputStream

arg2 long

long

Exceptions

SQLException

SetBlob(int, Blob)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBlob(int,java.sql.Blob)

public void SetBlob(int arg0, Blob arg1)

Parameters

arg0 int

int

arg1 Blob

Blob

Exceptions

SQLException

SetBoolean(int, bool)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBoolean(int,boolean)

public void SetBoolean(int arg0, bool arg1)

Parameters

arg0 int

int

arg1 bool

bool

Exceptions

SQLException

SetByte(int, byte)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setByte(int,byte)

public void SetByte(int arg0, byte arg1)

Parameters

arg0 int

int

arg1 byte

byte

Exceptions

SQLException

SetBytes(int, byte[])

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setBytes(int,byte[])

public void SetBytes(int arg0, byte[] arg1)

Parameters

arg0 int

int

arg1 byte[]

byte

Exceptions

SQLException

SetCharacterStream(int, Reader)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setCharacterStream(int,java.io.Reader)

public void SetCharacterStream(int arg0, Reader arg1)

Parameters

arg0 int

int

arg1 Reader

Reader

Exceptions

SQLException

SetCharacterStream(int, Reader, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setCharacterStream(int,java.io.Reader,int)

public void SetCharacterStream(int arg0, Reader arg1, int arg2)

Parameters

arg0 int

int

arg1 Reader

Reader

arg2 int

int

Exceptions

SQLException

SetCharacterStream(int, Reader, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setCharacterStream(int,java.io.Reader,long)

public void SetCharacterStream(int arg0, Reader arg1, long arg2)

Parameters

arg0 int

int

arg1 Reader

Reader

arg2 long

long

Exceptions

SQLException

SetClob(int, Reader)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setClob(int,java.io.Reader)

public void SetClob(int arg0, Reader arg1)

Parameters

arg0 int

int

arg1 Reader

Reader

Exceptions

SQLException

SetClob(int, Reader, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setClob(int,java.io.Reader,long)

public void SetClob(int arg0, Reader arg1, long arg2)

Parameters

arg0 int

int

arg1 Reader

Reader

arg2 long

long

Exceptions

SQLException

SetClob(int, Clob)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setClob(int,java.sql.Clob)

public void SetClob(int arg0, Clob arg1)

Parameters

arg0 int

int

arg1 Clob

Clob

Exceptions

SQLException

SetDate(int, Date)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setDate(int,java.sql.Date)

public void SetDate(int arg0, Date arg1)

Parameters

arg0 int

int

arg1 Date

Date

Exceptions

SQLException

SetDate(int, Date, Calendar)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setDate(int,java.sql.Date,java.util.Calendar)

public void SetDate(int arg0, Date arg1, Calendar arg2)

Parameters

arg0 int

int

arg1 Date

Date

arg2 Calendar

Calendar

Exceptions

SQLException

SetDouble(int, double)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setDouble(int,double)

public void SetDouble(int arg0, double arg1)

Parameters

arg0 int

int

arg1 double

double

Exceptions

SQLException

SetFloat(int, float)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setFloat(int,float)

public void SetFloat(int arg0, float arg1)

Parameters

arg0 int

int

arg1 float

float

Exceptions

SQLException

SetInt(int, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setInt(int,int)

public void SetInt(int arg0, int arg1)

Parameters

arg0 int

int

arg1 int

int

Exceptions

SQLException

SetLong(int, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setLong(int,long)

public void SetLong(int arg0, long arg1)

Parameters

arg0 int

int

arg1 long

long

Exceptions

SQLException

SetNCharacterStream(int, Reader)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNCharacterStream(int,java.io.Reader)

public void SetNCharacterStream(int arg0, Reader arg1)

Parameters

arg0 int

int

arg1 Reader

Reader

Exceptions

SQLException

SetNCharacterStream(int, Reader, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNCharacterStream(int,java.io.Reader,long)

public void SetNCharacterStream(int arg0, Reader arg1, long arg2)

Parameters

arg0 int

int

arg1 Reader

Reader

arg2 long

long

Exceptions

SQLException

SetNClob(int, Reader)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNClob(int,java.io.Reader)

public void SetNClob(int arg0, Reader arg1)

Parameters

arg0 int

int

arg1 Reader

Reader

Exceptions

SQLException

SetNClob(int, Reader, long)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNClob(int,java.io.Reader,long)

public void SetNClob(int arg0, Reader arg1, long arg2)

Parameters

arg0 int

int

arg1 Reader

Reader

arg2 long

long

Exceptions

SQLException

SetNClob(int, NClob)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNClob(int,java.sql.NClob)

public void SetNClob(int arg0, NClob arg1)

Parameters

arg0 int

int

arg1 NClob

NClob

Exceptions

SQLException

SetNString(int, String)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNString(int,java.lang.String)

public void SetNString(int arg0, String arg1)

Parameters

arg0 int

int

arg1 String

String

Exceptions

SQLException

SetNull(int, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNull(int,int)

public void SetNull(int arg0, int arg1)

Parameters

arg0 int

int

arg1 int

int

Exceptions

SQLException

SetNull(int, int, String)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setNull(int,int,java.lang.String)

public void SetNull(int arg0, int arg1, String arg2)

Parameters

arg0 int

int

arg1 int

int

arg2 String

String

Exceptions

SQLException

SetObject(int, object)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setObject(int,java.lang.Object)

public void SetObject(int arg0, object arg1)

Parameters

arg0 int

int

arg1 object

object

Exceptions

SQLException

SetObject(int, object, SQLType)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setObject(int,java.lang.Object,java.sql.SQLType)

public void SetObject(int arg0, object arg1, SQLType arg2)

Parameters

arg0 int

int

arg1 object

object

arg2 SQLType

SQLType

Exceptions

SQLException

SetObject(int, object, SQLType, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setObject(int,java.lang.Object,java.sql.SQLType,int)

public void SetObject(int arg0, object arg1, SQLType arg2, int arg3)

Parameters

arg0 int

int

arg1 object

object

arg2 SQLType

SQLType

arg3 int

int

Exceptions

SQLException

SetObject(int, object, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setObject(int,java.lang.Object,int)

public void SetObject(int arg0, object arg1, int arg2)

Parameters

arg0 int

int

arg1 object

object

arg2 int

int

Exceptions

SQLException

SetObject(int, object, int, int)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setObject(int,java.lang.Object,int,int)

public void SetObject(int arg0, object arg1, int arg2, int arg3)

Parameters

arg0 int

int

arg1 object

object

arg2 int

int

arg3 int

int

Exceptions

SQLException

SetRef(int, Ref)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setRef(int,java.sql.Ref)

public void SetRef(int arg0, Ref arg1)

Parameters

arg0 int

int

arg1 Ref

Ref

Exceptions

SQLException

SetRowId(int, RowId)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setRowId(int,java.sql.RowId)

public void SetRowId(int arg0, RowId arg1)

Parameters

arg0 int

int

arg1 RowId

RowId

Exceptions

SQLException

SetSQLXML(int, SQLXML)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setSQLXML(int,java.sql.SQLXML)

public void SetSQLXML(int arg0, SQLXML arg1)

Parameters

arg0 int

int

arg1 SQLXML

SQLXML

Exceptions

SQLException

SetShort(int, short)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setShort(int,short)

public void SetShort(int arg0, short arg1)

Parameters

arg0 int

int

arg1 short

short

Exceptions

SQLException

SetString(int, String)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setString(int,java.lang.String)

public void SetString(int arg0, String arg1)

Parameters

arg0 int

int

arg1 String

String

Exceptions

SQLException

SetTime(int, Time)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setTime(int,java.sql.Time)

public void SetTime(int arg0, Time arg1)

Parameters

arg0 int

int

arg1 Time

Time

Exceptions

SQLException

SetTime(int, Time, Calendar)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setTime(int,java.sql.Time,java.util.Calendar)

public void SetTime(int arg0, Time arg1, Calendar arg2)

Parameters

arg0 int

int

arg1 Time

Time

arg2 Calendar

Calendar

Exceptions

SQLException

SetTimestamp(int, Timestamp)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setTimestamp(int,java.sql.Timestamp)

public void SetTimestamp(int arg0, Timestamp arg1)

Parameters

arg0 int

int

arg1 Timestamp

Timestamp

Exceptions

SQLException

SetTimestamp(int, Timestamp, Calendar)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setTimestamp(int,java.sql.Timestamp,java.util.Calendar)

public void SetTimestamp(int arg0, Timestamp arg1, Calendar arg2)

Parameters

arg0 int

int

arg1 Timestamp

Timestamp

arg2 Calendar

Calendar

Exceptions

SQLException

SetURL(int, URL)

https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/PreparedStatement.html#setURL(int,java.net.URL)

public void SetURL(int arg0, URL arg1)

Parameters

arg0 int

int

arg1 URL

URL

Exceptions

SQLException
Edit this page