Package org.apache.ibatis.annotations

Annotation Type SelectKey

@Documented
@Retention(RUNTIME)
@Target(METHOD)
@Repeatable(List.class)
public @interface SelectKey
The annotation that specify an SQL for retrieving a key value.

How to use: 

 public interface UserMapper {
   @SelectKey(statement = "SELECT identity('users')", keyProperty = "id", before = true, resultType = int.class)
   @Insert("INSERT INTO users (id, name) VALUES(#{id}, #{name})")
   boolean insert(User user);
 }
Author:
Clinton Begin

  • Nested Class Summary

    Nested Classes
    Modifier and Type Class Description
    static interface  SelectKey.List
    The container annotation for SelectKey.

  • Required Element Summary

    Required Elements
    Modifier and Type Required Element Description
    boolean before
    Returns whether retrieves a key value before executing insert/update statement.
    String keyProperty
    Returns property names that holds a key value.
    Class<?> resultType
    Returns the key value type.
    String[] statement
    Returns an SQL for retrieving a key value.

  • Optional Element Summary

    Optional Elements
    Modifier and Type Optional Element Description
    String databaseId  
    String keyColumn
    Returns column names that retrieves a key value.
    StatementType statementType
    Returns the statement type to use.

  • Element Details

    • statement

      String[] statement
      Returns an SQL for retrieving a key value.
      Returns:
      an SQL for retrieving a key value

    • keyProperty

      String keyProperty
      Returns property names that holds a key value.

      If you specify multiple property, please separate using comma(',').

      Returns:
      property names that separate with comma(',')

    • before

      boolean before
      Returns whether retrieves a key value before executing insert/update statement.
      Returns:
      true if execute before; false if otherwise

    • resultType

      Class<?> resultType
      Returns the key value type.
      Returns:
      the key value type

    • keyColumn

      String keyColumn
      Returns column names that retrieves a key value.

      If you specify multiple column, please separate using comma(',').

      Returns:
      column names that separate with comma(',')
      Default:
      ""

    • statementType

      StatementType statementType
      Returns the statement type to use.
      Returns:
      the statement type
      Default:
      PREPARED

    • databaseId

      String databaseId
      Returns:
      A database id that correspond this select key
      Since:
      3.5.5
      Default:
      ""