MyBatis 使用

 注解

@Results({
  @Result(column="PERFIL", property="PERFIL",
    typeHandler=PerfilTypeHandler.class)
})
@Select("select * from users")
Map<String, Object> select(); 

 

@Select("select * from import_batch where import_id = #{importId} and status in (${statusArr})")
    /*@Select("<script>"
            + "SELECT * FROM import_batch WHERE import_id = :importId  AND status IN "
            + "<foreach item='item' index='index' collection='statusList' open='(' separator=',' close=')'>"
            + "#{item}"
            + "</foreach>"
            + "</script>")*/
    List<ImportBatch> findBatchByImportIdAndStatus(String importId, @Param("statusArr") String statusArr);

 

@Select("<script>select * from user <if test=\"id !=null \">where id = #{id} </if></script>")    
public List<User> findUserById(User user);  

 

// 返回 Map对象
@Select("select sum(success) as success,sum(input_error) as fail from table_a where id = #{id}")
    @Results({
       @Result(column = "success", property = "success", javaType = Integer.class),
       @Result(column = "fail", property = "fail", javaType = Integer.class),
    })
    Map<String, Integer> count(@Param("importId") String id);

 

 

MyBatis 返回类型

MyBatis 不能返回数组对象，只能返回基础类型，Map 或者 对象。

 

打印SQL 日志

logging.level.com.patsnap.inno.doc.core.importer.mapper=debug

 

链接

MyBatis学习笔记（十）注解映射

转载于:https://www.cnblogs.com/tonyq/p/8086603.html