## 二級緩存概念 MyBatis中SqlSessionFactory緩存.由同一個SqlSessionFactory對象創建的SqlSessionFactory共享其緩存. ## 配置 讓MyBatis框架支持二級緩存(MyBatis配置文件): ~~~ <settings> <setting name="cacheEnabled" value="true"/> //默認就是true </settings> ~~~ 讓當前的映射文件支持二級緩存(XML配置文件): ~~~ <mapper namespace="com.like.dao.IUserDao"> <cache/> //設置此標簽 <select id="findById" parameterType="int" resultType="com.like.domain.User" useCache="true"> select * from user where id = #{id} </select> </mapper> ~~~ 讓當前的操作支持二級緩存(在select標簽配置): ~~~ <mapper namespace="com.like.dao.IUserDao"> <cache/> <select id="findById" parameterType="int" resultType="com.like.domain.User" useCache="true"> //useCache設為true select * from user where id = #{id} </select> </mapper> ~~~ ## 代碼 ~~~ IUserDao mapper1 = session1.getMapper(IUserDao.class); User user1 = mapper1.findById(41); session1.close(); IUserDao mapper2 = session2.getMapper(IUserDao.class); User user2 = mapper2.findById(41); System.out.println(user1 == user2); //這里是false,這里存放的是數據,不是對象 ~~~ ``` 2019-04-04 21:19:33,204 0 [ main] DEBUG ache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter. 2019-04-04 21:19:33,420 216 [ main] DEBUG com.like.dao.IUserDao - Cache Hit Ratio [com.like.dao.IUserDao]: 0.0 2019-04-04 21:19:33,426 222 [ main] DEBUG ansaction.jdbc.JdbcTransaction - Opening JDBC Connection 2019-04-04 21:19:33,672 468 [ main] DEBUG ansaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@569cfc36] 2019-04-04 21:19:33,682 478 [ main] DEBUG com.like.dao.IUserDao.findById - ==> Preparing: select * from user where id = ? //只查詢了這一次 2019-04-04 21:19:33,723 519 [ main] DEBUG com.like.dao.IUserDao.findById - ==> Parameters: 41(Integer) 2019-04-04 21:19:33,759 555 [ main] DEBUG com.like.dao.IUserDao.findById - <== Total: 1 User{id=41, username='老王', birthday=Tue Feb 27 17:47:08 CST 2018, sex='男', address='北京', accounts=null} 2019-04-04 21:19:33,775 571 [ main] DEBUG ansaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@569cfc36] 2019-04-04 21:19:33,776 572 [ main] DEBUG ansaction.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@569cfc36] 2019-04-04 21:19:33,853 649 [ main] DEBUG com.like.dao.IUserDao - Cache Hit Ratio [com.like.dao.IUserDao]: 0.5 User{id=41, username='老王', birthday=Tue Feb 27 17:47:08 CST 2018, sex='男', address='北京', accounts=null} false //這里是false ```