org.apache.ibatis.annotations

Annotation Type Select

@Documented
 @Retention(value=RUNTIME)
 @Target(value=METHOD)
 @Repeatable(value=Select.List.class)
public @interface Select

The annotation that specify an SQL for retrieving record(s).

How to use:

 public interface UserMapper {
   @Select("SELECT id, name FROM users WHERE id = #{id}")
   User selectById(int id);
 }
 

Author:

Clinton Begin

Required Element Summary

Required Elements

Modifier and Type	Required Element and Description
String[]	value Returns an SQL for retrieving record(s).

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element and Description
String	databaseId

Element Detail

value

public abstract String[] value

Returns an SQL for retrieving record(s).

Returns:

an SQL for retrieving record(s)

databaseId

public abstract String databaseId

Returns:

A database id that correspond this statement

Since:

3.5.5

Default:

""