1.可以知道的是Mybatis的一級(jí)緩存SqlSession默認(rèn)是開啟的。
2.可以自己去開啟二級(jí)緩存在config.xml文件中的properties下面可以加上這個(gè)配置：
3.可以知道緩存之后的同一個(gè)session，再次執(zhí)行操作的時(shí)候是不用再次查詢數(shù)據(jù)庫(kù)的。
resources下面建立這幾個(gè)文件：
db.properties:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/csjzjj
jdbc.username=root
jdbc.password=roothouzhicong
config.xml:
MyUserMapper:
package com.zjj.mapper;
import com.zjj.entity.MyUser;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
* @Program mybatis
* @Package com.zjj.mapper
* @Auther TeacherHuang
* @Date 2021/8/16 15:29
* @Version 1.0
*/
public interface MyUserMapper {
@Select(“select *from myuser”)
List selectAll() throws Exception;
@Select(“select *from myuser”)
List selectAll01() throws Exception;
}
Test:
import com.zjj.entity.MyUser;
import com.zjj.mapper.MyUserMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.ioIOException;
import java.io.InputStream;
import java.util.List;
/**
* @Program mybatis
* @Package PACKAGE_NAME
* @Auther TeacherHuang
* @Date 2021/8/16 15:31
* @Version 1.0
*/
public class Test {
public static void main(String[] args) throws Exception {
String resources=”config.xml”;
InputStream inputstream = Resources.getResourceAsStream(resources);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream);
SqlSession session = sqlSessionFactory.openSession(true);
System.out.println(session);
MyUserMapper myUserMapper = session.getMapper(MyUserMapper.class);
System.out.println(“第一次沒(méi)有緩存數(shù)據(jù)的時(shí)候———————“);
List myUsers = myUserMapper.selectAll();
System.out.println(myUsers);
// session.close();
session.clearCache();
System.out.println(“第二次沒(méi)有緩存數(shù)據(jù)的時(shí)候———————“);
MyUserMapper myUserMapper02 = session.getMapper(MyUserMapper.class);
List myUsers01 = myUserMapper.selectAll();
System.out.println(myUsers01);
}
}
