简单的CRUD
@Select @Insert @Update @Delete
例如:
@Select("select * from user")
@Options 返回自增长id,
更加详细链接
@Options(useGeneratedKeys = true,keyProperty = "id",keyColumn = "id")
@Results
//一对一注解映射
@Select("select * from account")
@Results(id = "resultMap",
value = {
@Result(id = true, property = "id", column = "id"),
@Result(id = true, property = "uid", column = "uid"),
@Result(id = true, property = "money", column = "money"),
@Result(property = "user", column = "uid",
one = @One(select = "com.itcast.dao.UserDao.findById",
fetchType = FetchType.EAGER))
}
)
注解一对一映射理解
一对多同理上面,
mybatis注解设置二级缓存
1.在SqlMapConfig中配置cacheEnabled
2.在需要配置二级缓存中dao中使用注解@Cachenamespace
<settings>
<!-- 设置二级缓存-->
<setting name="cacheEnabled" value="true"/>
<!-- 设置延迟加载 注解可不写-->
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="aggressiveLazyLoading" value="false"></setting>
</settings>