org.compiere.util
Class CStatementVO

java.lang.Object
  org.compiere.util.CStatementVO

All Implemented Interfaces:

Serializable

public class CStatementVO
extends Object
implements Serializable

Adempiere Statement Value Object

Version:

$Id: CStatementVO.java,v 1.2 2006/07/30 00:54:35 jjanke Exp $

Author:

Jorg Janke

See Also:

Serialized Form

Constructor Summary

CStatementVO(int resultSetType, int resultSetConcurrency)
VO Constructor

CStatementVO(int resultSetType, int resultSetConcurrency, String sql)
VO Constructor

Method Summary

void	clearParameters() Clear Parameters
Map<String,OutputParameter>	getNamedOutput()
Map<String,Object>	getNamedParameters() get named parameters for callable statement
int	getParameterCount() Get Parameter Count
ArrayList<Object>	getParameters() Get Parameters
int	getResultSetConcurrency() Get ResultSet Concurrency
int	getResultSetType() Get ResultSet Type
String	getSql() Get SQL
String	getTrxName()
void	registerOutParameter(int parameterIndex, int sqlType)
void	registerOutParameter(int parameterIndex, int sqlType, int scale)
void	registerOutParameter(int paramIndex, int sqlType, String typeName)
void	registerOutParameter(String parameterName, int sqlType)
void	registerOutParameter(String parameterName, int sqlType, int scale)
void	registerOutParameter(String parameterName, int sqlType, String typeName)
void	setParameter(int index1, Object element) Set Parameter
void	setParameter(String name, Object element) Set Parameter
void	setResultSetConcurrency(int resultSetConcurrency) Set ResultSet Concurrency
void	setResultSetType(int resultSetType) Set ResultSet Type
void	setSql(String sql) Set SQL.
void	setTrxName(String trxName) Set transaction name
String	toString() String representation

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CStatementVO

public CStatementVO(int resultSetType,
                    int resultSetConcurrency)

VO Constructor

Parameters:

resultSetType - - ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - - ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

CStatementVO

public CStatementVO(int resultSetType,
                    int resultSetConcurrency,
                    String sql)

VO Constructor

Parameters:

resultSetType - - ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - - ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

sql - sql

Method Detail

toString

public String toString()

String representation

Overrides:

toString in class Object

Returns:

info

setParameter

public void setParameter(int index1,
                         Object element)

Set Parameter

Parameters:

index1 - 1 based index

element - element

setParameter

public void setParameter(String name,
                         Object element)

Set Parameter

Parameters:

index1 - 1 based index

element - element

clearParameters

public void clearParameters()

Clear Parameters

getParameters

public ArrayList<Object> getParameters()

Get Parameters

Returns:

arraylist

getNamedParameters

public Map<String,Object> getNamedParameters()

get named parameters for callable statement

Returns:

map

getParameterCount

public int getParameterCount()

Get Parameter Count

Returns:

arraylist

getSql

public String getSql()

Get SQL

Returns:

sql

setSql

public void setSql(String sql)

Set SQL. Replace ROWID with TRIM(ROWID) for remote SQL to convert into String as ROWID is not serialized

Parameters:

sql - sql

getResultSetConcurrency

public int getResultSetConcurrency()

Get ResultSet Concurrency

Returns:

rs concurrency

getResultSetType

public int getResultSetType()

Get ResultSet Type

Returns:

rs type

setResultSetType

public void setResultSetType(int resultSetType)

Set ResultSet Type

Parameters:

resultSetType - type

setResultSetConcurrency

public void setResultSetConcurrency(int resultSetConcurrency)

Set ResultSet Concurrency

Parameters:

resultSetConcurrency - concurrency

getTrxName

public String getTrxName()

Returns:

transaction name

setTrxName

public void setTrxName(String trxName)

Set transaction name

Parameters:

trxName -

registerOutParameter

public void registerOutParameter(String parameterName,
                                 int sqlType,
                                 int scale)

registerOutParameter

public void registerOutParameter(int paramIndex,
                                 int sqlType,
                                 String typeName)

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 int scale)

registerOutParameter

public void registerOutParameter(String parameterName,
                                 int sqlType)

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType)

registerOutParameter

public void registerOutParameter(String parameterName,
                                 int sqlType,
                                 String typeName)

getNamedOutput

public Map<String,OutputParameter> getNamedOutput()