pom.xml<\/p>\n\n\n\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n <modelVersion>4.0.0<\/modelVersion>\n\n <groupId>top.qaqaq.mybatis<\/groupId>\n <artifactId>MyBatis_demo3<\/artifactId>\n <version>1.0-SNAPSHOT<\/version>\n <packaging>jar<\/packaging>\n\n <name>MyBatis_demo3<\/name>\n <url>http:\/\/maven.apache.org<\/url>\n\n <properties>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <\/properties>\n\n <dependencies>\n <dependency>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>3.8.1<\/version>\n <scope>test<\/scope>\n <\/dependency>\n\n <!-- Mybatis\u6838\u5fc3 -->\n <dependency>\n <groupId>org.mybatis<\/groupId>\n <artifactId>mybatis<\/artifactId>\n <version>3.5.7<\/version>\n <\/dependency>\n <!-- junit\u6d4b\u8bd5 -->\n <dependency>\n <groupId>junit<\/groupId>\n <artifactId>junit<\/artifactId>\n <version>4.12<\/version>\n <scope>test<\/scope>\n <\/dependency>\n <!-- MySQL\u9a71\u52a8 -->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.31<\/version>\n <\/dependency>\n <!-- log4j\u65e5\u5fd7 -->\n <dependency>\n <groupId>log4j<\/groupId>\n <artifactId>log4j<\/artifactId>\n <version>1.2.17<\/version>\n <\/dependency>\n\n <!-- Mybatis EHCache\u6574\u5408\u5305 -->\n <dependency>\n <groupId>org.mybatis.caches<\/groupId>\n <artifactId>mybatis-ehcache<\/artifactId>\n <version>1.2.1<\/version>\n <\/dependency>\n <!-- slf4j\u65e5\u5fd7\u95e8\u9762\u7684\u4e00\u4e2a\u5177\u4f53\u5b9e\u73b0 -->\n <dependency>\n <groupId>ch.qos.logback<\/groupId>\n <artifactId>logback-classic<\/artifactId>\n <version>1.2.3<\/version>\n <\/dependency><\/strong>\n\n <\/dependencies>\n<\/project>\n<\/code><\/pre>\n\n\n\nresources<\/p>\n\n\n\n
mybatis-config.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE configuration\r\n PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\r\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\r\n<configuration>\r\n\r\n <properties resource=\"jdbc.properties\"\/>\r\n\r\n <!--\u8bbe\u7f6eMyBatis\u7684\u5168\u5c40\u914d\u7f6e-->\r\n <settings>\r\n <!--\u5c06_\u81ea\u52a8\u6620\u5c04\u4e3a\u9a7c\u5cf0\uff0cemp_name:empName-->\r\n <setting name=\"mapUnderscoreToCamelCase\" value=\"true\"\/>\r\n <!--\u5f00\u542f\u5ef6\u8fdf\u52a0\u8f7d-->\r\n <setting name=\"lazyLoadingEnabled\" value=\"true\"\/>\r\n <\/settings>\r\n\r\n <typeAliases>\r\n <package name=\"top.qaqaq.mybatis.pojo\"\/>\r\n <\/typeAliases>\r\n\r\n <environments default=\"development\">\r\n <environment id=\"development\">\r\n <transactionManager type=\"JDBC\"\/>\r\n <dataSource type=\"POOLED\">\r\n <property name=\"driver\" value=\"${jdbc.driver}\"\/>\r\n <property name=\"url\" value=\"${jdbc.url}\"\/>\r\n <property name=\"username\" value=\"${jdbc.username}\"\/>\r\n <property name=\"password\" value=\"${jdbc.password}\"\/>\r\n <\/dataSource>\r\n <\/environment>\r\n <\/environments>\r\n\r\n <mappers>\r\n <package name=\"top.qaqaq.mybatis.mapper\"\/>\r\n <\/mappers>\r\n<\/configuration><\/code><\/pre>\n\n\n\njdbc.properties<\/p>\n\n\n\n
jdbc.driver=com.mysql.cj.jdbc.Driver\njdbc.url=jdbc:mysql:\/\/localhost:3306\/mybatis\njdbc.username=root\njdbc.password=123456\n<\/code><\/pre>\n\n\n\nehcache.xml<\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"utf-8\" ?>\r\n<ehcache xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n xsi:noNamespaceSchemaLocation=\"..\/config\/ehcache.xsd\">\r\n <!-- \u78c1\u76d8\u4fdd\u5b58\u8def\u5f84 -->\r\n <diskStore path=\"C:\\Users\\ZRich\\Documents\\Code\\Java\\workspace_idea\\ehcache\"\/>\r\n\r\n <defaultCache\r\n maxElementsInMemory=\"1000\"\r\n maxElementsOnDisk=\"10000000\"\r\n eternal=\"false\"\r\n overflowToDisk=\"true\"\r\n timeToIdleSeconds=\"120\"\r\n timeToLiveSeconds=\"120\"\r\n diskExpiryThreadIntervalSeconds=\"120\"\r\n memoryStoreEvictionPolicy=\"LRU\">\r\n <\/defaultCache>\r\n<\/ehcache><\/code><\/pre>\n\n\n\nlogback.xml<\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<configuration debug=\"true\">\r\n <!-- \u6307\u5b9a\u65e5\u5fd7\u8f93\u51fa\u7684\u4f4d\u7f6e -->\r\n <appender name=\"STDOUT\" class=\"ch.qos.logback.core.ConsoleAppender\">\r\n <encoder>\r\n <!-- \u65e5\u5fd7\u8f93\u51fa\u7684\u683c\u5f0f -->\r\n <!-- \u6309\u7167\u987a\u5e8f\u5206\u522b\u662f\uff1a\u65f6\u95f4\u3001\u65e5\u5fd7\u7ea7\u522b\u3001\u7ebf\u7a0b\u540d\u79f0\u3001\u6253\u5370\u65e5\u5fd7\u7684\u7c7b\u3001\u65e5\u5fd7\u4e3b\u4f53\u5185\u5bb9\u3001\u6362\u884c -->\r\n <pattern>[%d{HH:mm:ss.SSS}] [%-5level] [%thread] [%logger] [%msg]%n<\/pattern>\r\n <\/encoder>\r\n <\/appender>\r\n\r\n <!-- \u8bbe\u7f6e\u5168\u5c40\u65e5\u5fd7\u7ea7\u522b\u3002\u65e5\u5fd7\u7ea7\u522b\u6309\u987a\u5e8f\u5206\u522b\u662f\uff1aDEBUG\u3001INFO\u3001WARN\u3001ERROR -->\r\n <!-- \u6307\u5b9a\u4efb\u4f55\u4e00\u4e2a\u65e5\u5fd7\u7ea7\u522b\u90fd\u53ea\u6253\u5370\u5f53\u524d\u7ea7\u522b\u548c\u540e\u9762\u7ea7\u522b\u7684\u65e5\u5fd7\u3002 -->\r\n <root level=\"DEBUG\">\r\n <!-- \u6307\u5b9a\u6253\u5370\u65e5\u5fd7\u7684appender\uff0c\u8fd9\u91cc\u901a\u8fc7\u201cSTDOUT\u201d\u5f15\u7528\u4e86\u524d\u9762\u914d\u7f6e\u7684appender -->\r\n <appender-ref ref=\"STDOUT\"\/>\r\n <\/root>\r\n\r\n <!-- \u6839\u636e\u7279\u6b8a\u9700\u6c42\u6307\u5b9a\u5c40\u90e8\u65e5\u5fd7\u7ea7\u522b -->\r\n <logger name=\"top.qaqaq.crowd.mapper\" level=\"DEBUG\"\/>\r\n\r\n<\/configuration><\/code><\/pre>\n\n\n\nresources\/mapper<\/p>\n\n\n\n
CacheMapper .xml<\/strong><\/h3>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE mapper\r\n PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"top.qaqaq.mybatis.mapper.CacheMapper\">\r\n\r\n <cache type=\"org.mybatis.caches.ehcache.EhcacheCache\" \/>\r\n\r\n <!--Emp getEmpByEid(@Param(\"eid\") Integer eid);-->\r\n <select id=\"getEmpByEid\" resultType=\"Emp\">\r\n select * from t_emp where eid = #{eid}\r\n <\/select>\r\n \r\n <!--int insertEmp(Emp emp);-->\r\n <insert id=\"insertEmp\">\r\n insert into t_emp values (null, #{empName},#{age},#{sex},#{email},null)\r\n <\/insert>\r\n<\/mapper><\/code><\/pre>\n\n\n\nmapper<\/p>\n\n\n\n
CacheMapper .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.mapper;\r\n\r\nimport org.apache.ibatis.annotations.Param;\r\nimport top.qaqaq.mybatis.pojo.Emp;\r\n\r\npublic interface CacheMapper {\r\n\r\n Emp getEmpByEid(@Param(\"eid\") Integer eid);\r\n\r\n int insertEmp(Emp emp);\r\n}\r\n<\/code><\/pre>\n\n\n\npojo<\/p>\n\n\n\n
Emp .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.pojo;\n\npublic class Emp {\n\n private Integer eid;\n private String empName;\n private Integer age;\n private String sex;\n private String email;\n private Dept dept;\n\n public Emp() {\n }\n\n public Emp(Integer eid, String empName, Integer age, String sex, String email) {\n this.eid = eid;\n this.empName = empName;\n this.age = age;\n this.sex = sex;\n this.email = email;\n }\n\n public Integer getEid() {\n return eid;\n }\n\n public void setEid(Integer eid) {\n this.eid = eid;\n }\n\n public String getEmpName() {\n return empName;\n }\n\n public void setEmpName(String empName) {\n this.empName = empName;\n }\n\n public Integer getAge() {\n return age;\n }\n\n public void setAge(Integer age) {\n this.age = age;\n }\n\n public String getSex() {\n return sex;\n }\n\n public void setSex(String sex) {\n this.sex = sex;\n }\n\n public String getEmail() {\n return email;\n }\n\n public void setEmail(String email) {\n this.email = email;\n }\n\n public Dept getDept() {\n return dept;\n }\n\n public void setDept(Dept dept) {\n this.dept = dept;\n }\n\n @Override\n public String toString() {\n return \"Emp{\" +\n \"eid=\" + eid +\n \", empName='\" + empName + '\\'' +\n \", age=\" + age +\n \", sex='\" + sex + '\\'' +\n \", email='\" + email + '\\'' +\n \", dept=\" + dept +\n '}';\n }\n\n}\n<\/code><\/pre>\n\n\n\nutils<\/p>\n\n\n\n
SqlSessionUtils .java<\/p>\n\n\n\n
package top.qaqaq.mybatis.utils;\n\nimport org.apache.ibatis.io.Resources;\nimport org.apache.ibatis.session.SqlSession;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\n\nimport java.io.IOException;\nimport java.io.InputStream;\n\npublic class SqlSessionUtils {\n\n public static SqlSession getSqlSession() {\n SqlSession sqlSession = null;\n try {\n InputStream is = Resources.getResourceAsStream(\"mybatis-config.xml\");\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);\n sqlSession = sqlSessionFactory.openSession(true);\n } catch (IOException e) {\n throw new RuntimeException(e);\n }\n return sqlSession;\n }\n}\n<\/code><\/pre>\n\n\n\ntest<\/p>\n\n\n\n
CacheMapperTest .java<\/strong><\/h3>\n\n\n\npackage top.qaqaq.mybatis.test;\r\n\r\nimport org.apache.ibatis.io.Resources;\r\nimport org.apache.ibatis.session.SqlSession;\r\nimport org.apache.ibatis.session.SqlSessionFactory;\r\nimport org.apache.ibatis.session.SqlSessionFactoryBuilder;\r\nimport org.junit.Test;\r\nimport top.qaqaq.mybatis.mapper.CacheMapper;\r\nimport top.qaqaq.mybatis.pojo.Emp;\r\nimport top.qaqaq.mybatis.utils.SqlSessionUtils;\r\n\r\nimport java.io.IOException;\r\nimport java.io.InputStream;\r\n\r\npublic class CacheMapperTest {\r\n\r\n @Test\r\n public void testOneCache() {\r\n SqlSession sqlSession1 = SqlSessionUtils.getSqlSession();\r\n CacheMapper mapper1 = sqlSession1.getMapper(CacheMapper.class);\r\n Emp emp1 = mapper1.getEmpByEid(1);\r\n System.out.println(emp1);\r\n \/\/mapper1.insertEmp(new Emp(null, \"abc\", 23, \"\u7537\", \"123@qq.com\"));\r\n sqlSession1.clearCache();\r\n Emp emp2 = mapper1.getEmpByEid(1);\r\n System.out.println(emp2);\r\n\r\n \/*\r\n SqlSession sqlSession2 = SqlSessionUtils.getSqlSession();\r\n CacheMapper mapper2 = sqlSession2.getMapper(CacheMapper.class);\r\n Emp emp2 = mapper2.getEmpByEid(1);\r\n System.out.println(emp2);\r\n *\/\r\n }\r\n\r\n @Test\r\n public void testTwoCache() {\r\n try {\r\n InputStream is = Resources.getResourceAsStream(\"mybatis-config.xml\");\r\n SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);\r\n SqlSession sqlSession1 = sqlSessionFactory.openSession(true);\r\n SqlSession sqlSession2 = sqlSessionFactory.openSession(true);\r\n CacheMapper mapper1 = sqlSession1.getMapper(CacheMapper.class);\r\n System.out.println(mapper1.getEmpByEid(1));\r\n sqlSession1.close();\r\n CacheMapper mapper2 = sqlSession2.getMapper(CacheMapper.class);\r\n System.out.println(mapper2.getEmpByEid(1));\r\n sqlSession2.close();\r\n } catch (IOException e) {\r\n throw new RuntimeException(e);\r\n }\r\n }\r\n}\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"pom.xml resources mybatis-config.xml jdbc.properties eh […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[108],"tags":[111],"class_list":["post-3151","post","type-post","status-publish","format-standard","hentry","category-mybatis-code","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3151"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3151"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3151\/revisions"}],"predecessor-version":[{"id":3152,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3151\/revisions\/3152"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}