Package org.apache.ibatis.annotations
Annotation Interface Select
The annotation that specify an SQL for retrieving record(s).
How to use:
- Simple:
public interface UserMapper { @Select("SELECT id, name FROM users WHERE id = #{id}") User selectById(int id); }
- Dynamic SQL:
public interface UserMapper { @Select({ "<script>", "select * from users", "where name = #{name}", "<if test=\"age != null\"> age = #{age} </if>", "</script>" }) User select(@NotNull String name, @Nullable Intger age); }
- Author:
- Clinton Begin
- See Also:
-
Nested Class Summary
-
Required Element Summary
-
Optional Element Summary
Modifier and TypeOptional ElementDescriptionboolean
Returns whether this select affects DB data.
e.g.
-
Element Details
-
value
String[] valueReturns an SQL for retrieving record(s).- Returns:
- an SQL for retrieving record(s)
-
-
-
databaseId
String databaseId- Returns:
- A database id that correspond this statement
- Since:
- 3.5.5
- Default:
- ""
-
affectData
boolean affectDataReturns whether this select affects DB data.
e.g. RETURNING of PostgreSQL or OUTPUT of MS SQL Server.- Returns:
true
if this select affects DB data;false
if otherwise- Since:
- 3.5.12
- Default:
- false
-