Annotation 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 
    The container annotation for SelectKey.
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    boolean
    Returns whether retrieves a key value before executing insert/update statement.
    Returns property names that holds a key value.
    Returns the key value type.
    Returns an SQL for retrieving a key value.
  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
     
    Returns column names that retrieves a key value.
    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:
      ""