Package com.uc4.api.objects
Class SecureSQLVariableIntern
java.lang.Object
com.uc4.api.objects.SecureSQLVariableIntern
Secure SQL Variables.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionboolean
Adds a new bind parameter to theSecureSQLVariableIntern
.void
clear()
Removes all bind Parameters.Returns the result format.Returns the SQL statement for DB2.Returns the SQL statement for MS SQL.Returns the SQL statement for Oracle.Returns the SQL statement for Postgres.iterator()
Returns anjava.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.protected void
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.lang.Iterable
forEach, spliterator
-
Constructor Details
-
SecureSQLVariableIntern
protected SecureSQLVariableIntern(com.uc4.util.XMLDocument doc)
-
-
Method Details
-
store
-
getStatementMsSQL
Returns the SQL statement for MS SQL.- Returns:
- SQL
-
setStatementMsSQL
Sets the SQL statement for MS SQL.- Parameters:
statementMsSQL
- SQL
-
getStatementOracle
Returns the SQL statement for Oracle.- Returns:
- Statement
-
setStatementOracle
Sets the SQL statement for Oracle.- Parameters:
statementOracle
- Statement
-
getStatementDB2
Returns the SQL statement for DB2.- Returns:
- Statement
-
getStatementPostgres
Returns the SQL statement for Postgres.- Returns:
- Statement
-
setStatementPostgres
Sets the SQL statement for Postgres.- Parameters:
statementPostgres
- Statement
-
setStatementDB2
Sets the SQL statement for DB2.- Parameters:
statementDB2
- Statement
-
getResultFormat
Returns the result format.- Returns:
- Result format
-
setResultFormat
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:
IndexOutOfBoundsException
- if index is out of bounds
-
clear
public void clear()Removes all bind Parameters. -
add
Adds a new bind parameter to theSecureSQLVariableIntern
. The returns value indicates if the bind parameter was added successfully.- Parameters:
bindParameter
- new bind Parameter- Returns:
true
if the bind parameter was added successfullyfalse
otherwise
-
iterator
Returns anjava.util.Iterator
of bind parameters. Each bind parameter is stored asjava.lang.String
. The order of the bind parameters is ascendant.
-