com.uc4.api.objects

Class SecureSQLVariableIntern

java.lang.Object

com.uc4.api.objects.SecureSQLVariableIntern

All Implemented Interfaces:

Iterable<String>

public class SecureSQLVariableIntern
extends Object
implements Iterable<String>

Secure SQL Variables.

Method Summary

Modifier and Type	Method and Description
boolean	add(String bindParameter) Adds a new bind parameter to the SecureSQLVariableIntern.
void	clear() Removes all bind Parameters.
String	getResultFormat() Returns the result format.
String	getStatementDB2() Returns the SQL statement for DB2.
String	getStatementMsSQL() Returns the SQL statement for MS SQL.
String	getStatementOracle() Returns the SQL statement for Oracle.
String	getStatementPostgres() Returns the SQL statement for Postgres.
Iterator<String>	iterator() Returns an java.util.Iterator of bind parameters.
void	remove(int index) Removes a bind parameter.
void	setResultFormat(String resultFormat) Sets the result format.
void	setStatementDB2(String statementDB2) Sets the SQL statement for DB2.
void	setStatementMsSQL(String statementMsSQL) Sets the SQL statement for MS SQL.
void	setStatementOracle(String statementOracle) Sets the SQL statement for Oracle.
void	setStatementPostgres(String statementPostgres) Sets the SQL statement for Postgres.
int	size() Returns the number of bind parameters.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Method Detail

getStatementMsSQL

public String getStatementMsSQL()

Returns the SQL statement for MS SQL.

Returns:

SQL

setStatementMsSQL

public void setStatementMsSQL(String statementMsSQL)

Sets the SQL statement for MS SQL.

Parameters:

statementMsSQL - SQL

getStatementOracle

public String getStatementOracle()

Returns the SQL statement for Oracle.

Returns:

Statement

setStatementOracle

public void setStatementOracle(String statementOracle)

Sets the SQL statement for Oracle.

Parameters:

statementOracle - Statement

getStatementDB2

public String getStatementDB2()

Returns the SQL statement for DB2.

Returns:

Statement

getStatementPostgres

public String getStatementPostgres()

Returns the SQL statement for Postgres.

Returns:

Statement

setStatementPostgres

public void setStatementPostgres(String statementPostgres)

Sets the SQL statement for Postgres.

Parameters:

statementPostgres - Statement

setStatementDB2

public void setStatementDB2(String statementDB2)

Sets the SQL statement for DB2.

Parameters:

statementDB2 - Statement

getResultFormat

public String getResultFormat()

Returns the result format.

Returns:

Result format

setResultFormat

public void setResultFormat(String resultFormat)

Sets the result format. The maximum length is 1024 characters.

Parameters:

resultFormat - String which contains the result format

size

public int size()

Returns the number of bind parameters.

Returns:

number of bind parameters

remove

public void remove(int index)
            throws IndexOutOfBoundsException

Removes a bind parameter.

Parameters:

index - Index of bind parameter

Throws:

IndexOutOfBoundsException - if index is out of bounds

clear

public void clear()

Removes all bind Parameters.

add

public boolean add(String bindParameter)

Adds a new bind parameter to the SecureSQLVariableIntern. The returns value indicates if the bind parameter was added successfully.

Parameters:

bindParameter - new bind Parameter

Returns:

true if the bind parameter was added successfully false otherwise

iterator

public Iterator<String> iterator()

Returns an java.util.Iterator of bind parameters. Each bind parameter is stored as java.lang.String. The order of the bind parameters is ascendant.

Specified by:

iterator in interface Iterable<String>

Returns:

Iterator