Mybatis 注解式SQL常用语法

1. like 查询

  @Select("SELECT COUNT(*) FROM t_test WHERE name LIKE CONCAT('%',#{name},'%')")
  Long getByName(@Param("name") String name);

2. IN 查询

    @Select({"<script>",
            "SELECT name FROM t_test WHERE id IN",
            "<foreach collection='ids' item='id' open='(' separator=',' close=')'>#{id}</foreach>",
            "</script>"})
    List<String> getByIds(@Param("ids") List<Long> ids);

3. 批量insert

    @Insert({"<script>",
            "INSERT INTO t_test (id,name) VALUES",
            "<foreach item = 'entity' collection = 'entities' separator = ','>",
            "(#{entity.id},#{entity.name})",
            "</foreach>",
            "</script>"})
    int batchInsert(@Param("entities") List<AccountDO> entities);