mybatis-plus.configuration.cache-enabled=true
mybatis-plus.mapper-locations=classpath*:/mapper/*.xml
mybatis-plus.type-aliases-package=com.sch.app.mybatis.entity
logging.level.com.sch.app.mybatis.mapper= debug

<dependency>
		  <groupId>com.baomidou</groupId>
		  <artifactId>mybatis-plus-boot-starter</artifactId>
		  <version>3.3.2</version>
		</dependency>		
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-cache</artifactId>
		</dependency>
			<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
		</dependency>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
  <!-- <properties resource="mybatis.properties" />
     -->
  <classPathEntry location="D:\AJava\mysql-connector-java-8.0.16.jar" />
  <context id="msqlTables" targetRuntime="MyBatis3">
    <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
    <jdbcConnection connectionURL="jdbc:mysql://localhost:3306/alexshi?serverTimezone=GMT%2B8"
            driverClass="com.mysql.cj.jdbc.Driver" password="1234" userId="root" >

      <property name="nullCatalogMeansCurrent" value="true"/>
    </jdbcConnection>
    <javaTypeResolver>
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>
    <javaModelGenerator targetPackage="com.sch.app.mybatis.entity" targetProject="SpringbootMybatis\src\main\java">
      <property name="enableSubPackages" value="true"/>
      <!-- 從數(shù)據(jù)庫(kù)返回的值被清理前后的空格 -->
      <property name="trimStrings" value="true" />
    </javaModelGenerator>
    <sqlMapGenerator targetPackage="mapper" targetProject="SpringbootMybatis\src\main\resources">
      <property name="enableSubPackages" value="true"/>
    </sqlMapGenerator>
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.sch.app.mybatis.mapper" targetProject="SpringbootMybatis\src\main\java">
      <property name="enableSubPackages" value="true"/>
    </javaClientGenerator>

    <!--數(shù)據(jù)庫(kù)表-->
    <table schema="" tableName="d_dictionary"></table>
    <table schema="" tableName="d_dictionary_type"></table>
    <table schema="" tableName="c_resource"></table>
    <table schema="" tableName="c_role"></table>
    <table schema="" tableName="c_role_resource"></table>
    <table schema="" tableName="c_user_online"></table>
    <table schema="" tableName="c_user"></table>
    <table schema="" tableName="c_user_role"></table>
    <table schema="" tableName="test"></table>
  </context>
</generatorConfiguration>

logging.level.com.sch.app.mybatis.mapper= debug

@Autowired
private SqlSessionFactory sqlSessionFactory;

 @RequestMapping(value = "/testMybatis")
 @ResponseBody
 public void testMybatis(){
	 SqlSession sqlSession = sqlSessionFactory.openSession();
	 TestMapper testMapper = sqlSession.getMapper(TestMapper.class);
	  for (int i = 0; i < 3; i++) {
	    Test selectByPrimaryKey = testMapper.selectByPrimaryKey(5);
	    log.info("結(jié)果："+ selectByPrimaryKey.getUsername());
 }

@RequestMapping(value = "/testMybatis")
	 @ResponseBody
	 public void testMybatis(){
		 SqlSession sqlSession = sqlSessionFactory.openSession();
		 TestMapper testMapper = sqlSession.getMapper(TestMapper.class);
		  for (int i = 0; i < 3; i++) {
		    Test selectByPrimaryKey = testMapper.selectByPrimaryKey(5);
		    log.info("結(jié)果："+ selectByPrimaryKey.getUsername());
		    if (i == 2) {
		    	selectByPrimaryKey.setUsername("劉惜君的妹妹");
		    	testMapper.updateByPrimaryKey(selectByPrimaryKey);
		    	Test selectByPrimaryKey2 = testMapper.selectByPrimaryKey(5);
		    	log.info("更新后的用戶名："+ selectByPrimaryKey2.getUsername());
				}
	 }

@RequestMapping(value = "/testMybatis2")
		  @ResponseBody
		  public void testMybatis2(){
		  	SqlSession openSession1 = sqlSessionFactory.openSession();
		  	SqlSession openSession2 = sqlSessionFactory.openSession();
		  	TestMapper mapper1 = openSession1.getMapper(TestMapper.class);
		  	TestMapper mapper2 = openSession2.getMapper(TestMapper.class);
		  	Test selectByPrimaryKey = mapper1.selectByPrimaryKey(5);
		  	System.out.println(selectByPrimaryKey.getUsername());
		  	openSession1.close();
		  	Test selectByPrimaryKey2 = mapper2.selectByPrimaryKey(5);
		  	System.out.println(selectByPrimaryKey2.getUsername());
		  	openSession2.close();
		  }

	@RequestMapping(value = "/testMybatis3")
		  @ResponseBody
		  public void testMybatis3(){
		  	SqlSession openSession1 = sqlSessionFactory.openSession();
		  	SqlSession openSession2 = sqlSessionFactory.openSession();
		  	SqlSession openSession3 = sqlSessionFactory.openSession();
		  	TestMapper mapper1 = openSession1.getMapper(TestMapper.class);
		  	TestMapper mapper2 = openSession2.getMapper(TestMapper.class);
		  	TestMapper mapper3 = openSession3.getMapper(TestMapper.class);
		  	Test selectByPrimaryKey = mapper1.selectByPrimaryKey(5);
		  	System.out.println(selectByPrimaryKey.getUsername());
		  	openSession1.close();
		  	selectByPrimaryKey.setUsername("劉惜君的姐姐");
		  	mapper2.updateByPrimaryKey(selectByPrimaryKey);
		  	openSession2.commit();
		  	
		  	Test selectByPrimaryKey3 = mapper3.selectByPrimaryKey(5);
		  	System.out.println(selectByPrimaryKey3.getUsername());
		  	openSession3.close();
		  }