Package org.apache.ibatis.annotations

Annotation Interface 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(',')

    • 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:
      ""

    • 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

    • 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:
      ""