Mybatis一级缓存失效的四种情况（实际上是2种）

天空～之城

已于 2023-10-16 15:50:25 修改

阅读量354

点赞数

分类专栏：源码解析技术问答 Mybatis 文章标签： mybatis 缓存

于 2023-10-06 15:49:50 首次发布

技术问答同时被 3 个专栏收录

123 篇文章 4 订阅

订阅专栏

源码解析

22 篇文章 1 订阅

订阅专栏

Mybatis

14 篇文章 0 订阅

订阅专栏

转载：https://blog.csdn.net/qq_46051303/article/details/128428013

在这里插入图片描述

    @Test
    public void getEmpbyEid3() throws Exception {
        SqlSession sqlSession = SqlSessionUtils.getSqlSession(true);
        SqlSession sqlSession2 = SqlSessionUtils.getSqlSession(true);

        CacheMapper mapper = sqlSession.getMapper(CacheMapper.class);
        CacheMapper mapper2 = sqlSession2.getMapper(CacheMapper.class);

        Emp empByCche = mapper.getEmpByCche(3);
        Emp empByCche2 = mapper2.getEmpByCche(3);
        Emp empByCche3 = mapper.getEmpByCche(3);

        System.out.println(empByCche);
        System.out.println(empByCche2);
        System.out.println(empByCche3);
    }
}

在这里插入图片描述

DEBUG 12-24 13:51:02,501 ==>  Preparing: select * from t_emp_s where eid = ? (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:51:02,527 ==> Parameters: 3(Integer) (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:51:02,543 <==      Total: 1 (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:51:02,551 ==>  Preparing: select * from t_emp_s where eid = ? (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:51:02,551 ==> Parameters: 3(Integer) (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:51:02,553 <==      Total: 1 (BaseJdbcLogger.java:137) 
Emp{eid=3, empName='王五', sex='男', email='123@qq.com', age=23, dept=null}
Emp{eid=3, empName='王五', sex='男', email='123@qq.com', age=23, dept=null}
Emp{eid=3, empName='王五', sex='男', email='123@qq.com', age=23, dept=null}
Process finished with exit code 0

在这里插入图片描述

@Test
public void getEmpbyEid2() throws Exception {
    SqlSession sqlSession = SqlSessionUtils.getSqlSession(true);

    CacheMapper mapper = sqlSession.getMapper(CacheMapper.class);

    Emp empByCche = mapper.getEmpByCche(3);
    Emp empByCche2 = mapper.getEmpByCche(1);
    Emp empByCche3 = mapper.getEmpByCche(3);

    System.out.println(empByCche);
    System.out.println(empByCche2);
    System.out.println(empByCche3);
}

在这里插入图片描述

DEBUG 12-24 13:59:56,400 ==>  Preparing: select * from t_emp_s where eid = ? (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:59:56,420 ==> Parameters: 3(Integer) (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:59:56,442 <==      Total: 1 (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:59:56,442 ==>  Preparing: select * from t_emp_s where eid = ? (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:59:56,443 ==> Parameters: 1(Integer) (BaseJdbcLogger.java:137) 
DEBUG 12-24 13:59:56,444 <==      Total: 1 (BaseJdbcLogger.java:137) 
Emp{eid=3, empName='王五', sex='男', email='123@qq.com', age=23, dept=null}
Emp{eid=1, empName='张三', sex='男', email='123@qq.com', age=23, dept=null}
Emp{eid=3, empName='王五', sex='男', email='123@qq.com', age=23, dept=null}
Process finished with exit code 0