Package org.apache.ibatis.annotations
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
-
Required Element Summary
-
Optional Element Summary
Modifier and TypeOptional ElementDescriptionReturns column names that retrieves a key value.Returns the statement type to use.
-
Element Details
-
statement
String[] statementReturns an SQL for retrieving a key value.- Returns:
- an SQL for retrieving a key value
-
keyProperty
String keyPropertyReturns 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 beforeReturns whether retrieves a key value before executing insert/update statement.- Returns:
true
if execute before;false
if otherwise
-
resultType
Class<?> resultTypeReturns the key value type.- Returns:
- the key value type
-
-
-
keyColumn
String keyColumnReturns 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 statementTypeReturns 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:
- ""
-