Package org.hibernate.engine.jdbc.spi

Interface StatementPreparer

  • public interface StatementPreparer
    Contracting for preparing SQL statements

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      java.sql.Statement createStatement()
      Create a statement.
      java.sql.PreparedStatement prepareQueryStatement​(java.lang.String sql, boolean isCallable, ScrollMode scrollMode)
      Get a prepared statement for use in loading / querying.
      java.sql.PreparedStatement prepareStatement​(java.lang.String sql)
      Prepare a statement.
      java.sql.PreparedStatement prepareStatement​(java.lang.String sql, boolean isCallable)
      Prepare a statement.
      java.sql.PreparedStatement prepareStatement​(java.lang.String sql, int autoGeneratedKeys)
      Prepare an INSERT statement, specifying how auto-generated (by the database) keys should be handled.
      java.sql.PreparedStatement prepareStatement​(java.lang.String sql, java.lang.String[] columnNames)
      Prepare an INSERT statement, specifying columns which are auto-generated values to be returned.

    • Method Detail

      • createStatement

        java.sql.Statement createStatement()
        Create a statement.
        Returns:
        the statement

      • prepareStatement

        java.sql.PreparedStatement prepareStatement​(java.lang.String sql)
        Prepare a statement.
        Parameters:
        sql - The SQL the statement to be prepared
        Returns:
        the prepared statement

      • prepareStatement

        java.sql.PreparedStatement prepareStatement​(java.lang.String sql,
                                            boolean isCallable)
        Prepare a statement.
        Parameters:
        sql - The SQL the statement to be prepared
        isCallable - Whether to prepare as a callable statement.
        Returns:
        the prepared statement

      • prepareStatement

        java.sql.PreparedStatement prepareStatement​(java.lang.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:
        • Statement.RETURN_GENERATED_KEYS
        • Statement.NO_GENERATED_KEYS
        Generated keys are accessed afterwards via Statement.getGeneratedKeys()
        Parameters:
        sql - The INSERT SQL
        autoGeneratedKeys - The autoGeneratedKeys flag
        Returns:
        the prepared statement
        See Also:
        Connection.prepareStatement(String, int)

      • prepareStatement

        java.sql.PreparedStatement prepareStatement​(java.lang.String sql,
                                            java.lang.String[] columnNames)
        Prepare an INSERT statement, specifying columns which are auto-generated values to be returned. Generated keys are accessed afterwards via Statement.getGeneratedKeys()
        Parameters:
        sql - - the SQL for the statement to be prepared
        columnNames - The name of the columns to be returned in the generated keys result set.
        Returns:
        the prepared statement
        See Also:
        Connection.prepareStatement(String, String[])

      • prepareQueryStatement

        java.sql.PreparedStatement prepareQueryStatement​(java.lang.String sql,
                                                 boolean isCallable,
                                                 ScrollMode scrollMode)
        Get a prepared statement for use in loading / querying.
        Parameters:
        sql - The SQL the statement to be prepared
        isCallable - 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.
        Returns:
        the prepared statement