Dreamhunter Blog

Java Spring MyBatis 注解

2021/2/24 java

# application.yml 开启驼峰映射

mybatis:
    configuration:
    # 开启驼峰映射
        map-underscore-to-camel-case: true

# CRUD 注解

  • @Select
  • @Insert
  • @Update
  • @Delete

# 映射注解 Results

为了解决对象属性和字段驼峰不一致的问题，我们可以使用映射注解@Results来指定映射关系。

  • @Results 用于填写结果集的多个字段的映射关系.
  • @Result 用于填写结果集的单个字段的映射关系.
  • @ResultMap 根据ID关联XML里面 <resultMap>
@Results({
        @Result(property = "userId", column = "USER_ID"),
        @Result(property = "username", column = "USERNAME"),
        @Result(property = "password", column = "PASSWORD"),
        @Result(property = "mobileNum", column = "PHONE_NUM")
})
@Select("select * from t_user")
List<User> list();

# CRUD 高级注解

  • @SelectProvider
  • @InsertProvider
  • @UpdateProvider
  • @DeleteProvider

Spring RedisTemplate