Package com.uc4.api.objects
Class SecureSQLVariableIntern
- java.lang.Object
-
- com.uc4.api.objects.SecureSQLVariableIntern
-
- All Implemented Interfaces:
java.lang.Iterable<java.lang.String>
public class SecureSQLVariableIntern extends java.lang.Object implements java.lang.Iterable<java.lang.String>Secure SQL Variables.
-
-
Constructor Summary
Constructors Modifier Constructor Description protectedSecureSQLVariableIntern(com.uc4.util.XMLDocument doc)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description booleanadd(java.lang.String bindParameter)Adds a new bind parameter to theSecureSQLVariableIntern.voidclear()Removes all bind Parameters.java.lang.StringgetResultFormat()Returns the result format.java.lang.StringgetStatementDB2()Returns the SQL statement for DB2.java.lang.StringgetStatementMsSQL()Returns the SQL statement for MS SQL.java.lang.StringgetStatementOracle()Returns the SQL statement for Oracle.java.lang.StringgetStatementPostgres()Returns the SQL statement for Postgres.java.util.Iterator<java.lang.String>iterator()Returns anjava.util.Iteratorof bind parameters.voidremove(int index)Removes a bind parameter.voidsetResultFormat(java.lang.String resultFormat)Sets the result format.voidsetStatementDB2(java.lang.String statementDB2)Sets the SQL statement for DB2.voidsetStatementMsSQL(java.lang.String statementMsSQL)Sets the SQL statement for MS SQL.voidsetStatementOracle(java.lang.String statementOracle)Sets the SQL statement for Oracle.voidsetStatementPostgres(java.lang.String statementPostgres)Sets the SQL statement for Postgres.intsize()Returns the number of bind parameters.protected voidstore(com.uc4.util.XMLDocument doc, org.w3c.dom.Element vara)
-
-
-
Method Detail
-
store
protected void store(com.uc4.util.XMLDocument doc, org.w3c.dom.Element vara)
-
getStatementMsSQL
public java.lang.String getStatementMsSQL()
Returns the SQL statement for MS SQL.- Returns:
- SQL
-
setStatementMsSQL
public void setStatementMsSQL(java.lang.String statementMsSQL)
Sets the SQL statement for MS SQL.- Parameters:
statementMsSQL- SQL
-
getStatementOracle
public java.lang.String getStatementOracle()
Returns the SQL statement for Oracle.- Returns:
- Statement
-
setStatementOracle
public void setStatementOracle(java.lang.String statementOracle)
Sets the SQL statement for Oracle.- Parameters:
statementOracle- Statement
-
getStatementDB2
public java.lang.String getStatementDB2()
Returns the SQL statement for DB2.- Returns:
- Statement
-
getStatementPostgres
public java.lang.String getStatementPostgres()
Returns the SQL statement for Postgres.- Returns:
- Statement
-
setStatementPostgres
public void setStatementPostgres(java.lang.String statementPostgres)
Sets the SQL statement for Postgres.- Parameters:
statementPostgres- Statement
-
setStatementDB2
public void setStatementDB2(java.lang.String statementDB2)
Sets the SQL statement for DB2.- Parameters:
statementDB2- Statement
-
getResultFormat
public java.lang.String getResultFormat()
Returns the result format.- Returns:
- Result format
-
setResultFormat
public void setResultFormat(java.lang.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)
Removes a bind parameter.- Parameters:
index- Index of bind parameter- Throws:
java.lang.IndexOutOfBoundsException- if index is out of bounds
-
clear
public void clear()
Removes all bind Parameters.
-
add
public boolean add(java.lang.String bindParameter)
Adds a new bind parameter to theSecureSQLVariableIntern. The returns value indicates if the bind parameter was added successfully.- Parameters:
bindParameter- new bind Parameter- Returns:
trueif the bind parameter was added successfullyfalseotherwise
-
iterator
public java.util.Iterator<java.lang.String> iterator()
Returns anjava.util.Iteratorof bind parameters. Each bind parameter is stored asjava.lang.String. The order of the bind parameters is ascendant.- Specified by:
iteratorin interfacejava.lang.Iterable<java.lang.String>- Returns:
- Iterator
-
-