Mybatis 注解常用写法

1.查询 IN

当需要编写 含有 IN 关键字的查询语句时 使用注解写法如下

@Select({"<script>", "SELECT * FROM user WHERE id IN ", 
 	"<foreach collection='ids' item='id' open='(' separator=',' close=')'>#{id}</foreach>", "</script>"})
public List<User> getUserList(@Param(value = "ids") List<Long> ids);

2.查询 IF

当需要编写语句需要根据表中的属性进行判断显示时 使用注解写法如下

@Select({"<script>", "SELECT ", 
 	"IF (gender = 1, male_age.female_age)  AS age，“FROM user ”, "</script>"})
public List<User> getUserList();

2.查询 字段模糊匹配

当需要编写语句需要根据表中的属性进行字段模糊匹配时 使用注解写法如下

@Select({"<script>" +
     "SELECT  *  FROM user  WHERE 1=1 "   +
 	 "<if test='taskName != null'>" +
     " AND tc.task_name like '%${userName}%'  " +
     "</if>"   +
     "</script>"})
public List<User> getUserList(@Param("userName") String userName);