|
| |
|
| java.lang.Object
 workbench.storage.DmlStatement
| DmlStatement | | public class DmlStatement (Code) | | A class to execute a SQL Statement and to create the statement
from a given list of values.
author:
support@sql-workbench.net |
| Constructor Summary | |
| public | DmlStatement(CharSequence aStatement, List<ColumnData> aValueList)
Create a new DmlStatement with the given SQL template string
and the given values.
The SQL string is expected to contain a ? for each value
passed in aValueList. |
| DmlStatement | | public DmlStatement(CharSequence aStatement, List<ColumnData> aValueList)(Code) | | Create a new DmlStatement with the given SQL template string
and the given values.
The SQL string is expected to contain a ? for each value
passed in aValueList. The SQL statement will be executed
using a prepared statement.
|
| execute | | public int execute(WbConnection aConnection) throws SQLException(Code) | | Execute the statement as a prepared statement
Parameters:
aConnection - the Connection to be used the number of rows affected |
| getExecutableStatement | | public CharSequence getExecutableStatement(SqlLiteralFormatter literalFormatter)(Code) | | Returns a "real" SQL Statement which can be executed
directly. The statement contains the parameter values
as literals. No placeholders are used.
Parameters:
literalFormatter - the Formatter for date and other literals a SQL statement that can be executed |
| getUsePreparedStatement | | public boolean getUsePreparedStatement()(Code) | | Returns true if a prepared statement is used
to send the data to the database.
|
| setChrFunction | | public void setChrFunction(String aFunc)(Code) | | |
| setConcatFunction | | public void setConcatFunction(String func)(Code) | | |
| setConcatString | | public void setConcatString(String concat)(Code) | | |
|
|
|