mybatis一级缓存命中条件

1、执行的sql和参数必须相同

如：

//命中：
User user1 = userMapper.selectById(1);
User user2 = userMapper.selectById(1);
//缓存命中,返回结果为true
sout(user1 == user2)

//不命中：
userMapper.selectById(1);
userMapper.selectById(2);

2、必须是相同的statementId （com.sms.mapper.UserMapper.selectById） 如：

//命中：
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
// 底层都是执行selectOne
userMapper.selectById(1);
sqlSession.selectOne("com.xxx.xxx.UserMapper.selectById",1);

//不命中:
//statementId为com.xxx.xxx.UserMapper.selectById
userMapper.selectById(1); 
//statementId为com.xxx.xxx.UserMapper.selectByIdddd
userMapper.selectByIddddd(1);

3、sqlSession一样（会话级缓存）

//命中：
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.selectById(1);
userMapper.selectById(1);

//不命中：
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.selectById(1);
//创建新的session会话
factory.openSession.getMapper(UserMapper.class).selectById(1);

4、RowBounds返回行数必须相同

//命中
//selectById底层就是执行selectOne并直接赋值RowBounds为DEFAULT
userMapper.selectById(1);
sqlSession.selectOne("com.xxx.xxx.UserMapper.selectById",1,RowBounnds.DEFAULT);

//不命中
userMapper.selectById(1);
//分页从0开始取10个数
sqlSession.selectOne("com.xxx.xxx.UserMapper.selectById",1,new RowBounds(0,10));