public interface StatementPreparer
Contracting for preparing SQL statements
Modifier and Type | Method and Description |
---|---|
Statement |
createStatement()
Create a statement.
|
PreparedStatement |
prepareQueryStatement(String sql,
boolean isCallable,
ScrollMode scrollMode)
Get a prepared statement for use in loading / querying.
|
PreparedStatement |
prepareStatement(String sql)
Prepare a statement.
|
PreparedStatement |
prepareStatement(String sql,
boolean isCallable)
Prepare a statement.
|
PreparedStatement |
prepareStatement(String sql,
int autoGeneratedKeys)
Prepare an INSERT statement, specifying how auto-generated (by the database) keys should be handled.
|
PreparedStatement |
prepareStatement(String sql,
String[] columnNames)
Prepare an INSERT statement, specifying columns which are auto-generated values to be returned.
|
Statement createStatement()
Create a statement.
PreparedStatement prepareStatement(String sql)
Prepare a statement.
sql
- The SQL the statement to be preparedPreparedStatement prepareStatement(String sql, boolean isCallable)
Prepare a statement.
sql
- The SQL the statement to be preparedisCallable
- Whether to prepare as a callable statement.PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
Prepare an INSERT statement, specifying how auto-generated (by the database) keys should be handled. Really this
is a boolean, but JDBC opted to define it instead using 2 int constants:<ul>
<li>Statement.RETURN_GENERATED_KEYS
</li>
<li>Statement.NO_GENERATED_KEYS
</li>
</ul>
Generated keys are accessed afterwards via Statement.getGeneratedKeys()
sql
- The INSERT SQLautoGeneratedKeys
- The autoGeneratedKeys flagConnection.prepareStatement(String, int)
PreparedStatement prepareStatement(String sql, String[] columnNames)
Prepare an INSERT statement, specifying columns which are auto-generated values to be returned.
Generated keys are accessed afterwards via Statement.getGeneratedKeys()
sql
- - the SQL for the statement to be preparedcolumnNames
- The name of the columns to be returned in the generated keys result set.Connection.prepareStatement(String, String[])
PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode)
Get a prepared statement for use in loading / querying.
sql
- The SQL the statement to be preparedisCallable
- Whether to prepare as a callable statement.scrollMode
- (optional) scroll mode to be applied to the resulting result set; may be null to indicate
no scrolling should be applied.Copyright © 2001-2018 Red Hat, Inc. All Rights Reserved.