## 配置 ~~~ <settings> <setting name="cacheEnabled" value="true"/> </settings> ~~~ ~~~ package com.like.dao; import com.like.domain.User; import java.util.List; import org.apache.ibatis.annotations.*; import org.apache.ibatis.mapping.FetchType; @CacheNamespace(blocking = true) //開啟二級緩存 public interface IUserDao { @Select("select * from user") @Results(id = "userMap", value = { @Result(id = true, property = "id", column = "id"), @Result(property = "username", column = "username"), @Result(property = "address", column = "address"), @Result(property = "birthday", column = "birthday"), @Result(property = "sex", column = "sex"), //property是關聯表在本表的屬性,column是關聯字段,select是關聯接口根據id查詢數據的全限定方法名,fetchType是獲取方式,此處是立即獲取 @Result(property = "accounts", column = "id", many = @Many(select = "com.like.dao.IAccountDao.findAccountByUid", fetchType = FetchType.LAZY)) }) List<User> findAll(); @Select("select * from user where id = #{id}") User findById(Integer id); } ~~~