MyBatis插入数据运行成功但是数据库没有数据问题解决方案

MyBatis插入数据运行成功但是数据库没有数据问题解决方案

 /**
     * 插入数据
     *
     * @throws IOException
     */
    @Test
    public void test02() throws IOException {
        User user = new User("cwl2","2",new Date(),"广州");
        int result = sqlSession.insert("insertUser", user);
        
        System.out.println("====="+result);


    }

显示运行成功

"C:\Program Files\Java\jdk1.8.0_201\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:D:\Coding\IDEA_java\lib\idea_rt.jar=6491:D:\Coding\IDEA_java\bin -Dfile.encoding=UTF-8 -classpath "D:\Coding\IDEA_java\lib\idea_rt.jar;D:\Coding\IDEA_java\plugins\junit\lib\junit-rt.jar;D:\Coding\IDEA_java\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\rt.jar;E:\java\IdeaProjects\SSH\day01_structs2_demo01\out\production\mabatis-day01;D:\Coding\java\tomcat\apache-tomcat-8.5.31-windows-64位\apache-tomcat-8.5.31\lib\jsp-api.jar;D:\Coding\java\tomcat\apache-tomcat-8.5.31-windows-64位\apache-tomcat-8.5.31\lib\servlet-api.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\asm-3.3.1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\cglib-2.2.2.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-1.2.17.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\mybatis-3.2.7.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\slf4j-api-1.7.5.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-api-2.0-rc1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-core-2.0-rc1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\javassist-3.17.1-GA.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\slf4j-log4j12-1.7.5.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\commons-logging-1.1.1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\mysql-connector-java-8.0.11.jar;D:\Coding\java\maven_repository\junit\junit\4.12\junit-4.12.jar;D:\Coding\java\maven_repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.cwl.test.Demo02,test02
---before---
DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 1073533248.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - ==>  Preparing: insert into user(username, sex,birthday, address) value (?,?,?,?); 
DEBUG [main] - ==> Parameters: cwl2(String), 2(String), 2020-12-06 17:36:22.056(Timestamp), 广州(String)
DEBUG [main] - <==    Updates: 1
DEBUG [main] - Committing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
=====1
---after---
DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - Returned connection 1073533248 to pool.

Process finished with exit code 0

但是数据库没有数据

这个时候很明显是数据没有提交
加代码
sqlSession.commit();
即可

 /**
     * 插入数据
     *
     * @throws IOException
     */
    @Test
    public void test02() throws IOException {
        User user = new User("cwl2","2",new Date(),"广州");
        int result = sqlSession.insert("insertUser", user);
        sqlSession.commit();
        System.out.println("====="+result);


    }

成功运行

"C:\Program Files\Java\jdk1.8.0_201\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:D:\Coding\IDEA_java\lib\idea_rt.jar=6682:D:\Coding\IDEA_java\bin -Dfile.encoding=UTF-8 -classpath "D:\Coding\IDEA_java\lib\idea_rt.jar;D:\Coding\IDEA_java\plugins\junit\lib\junit-rt.jar;D:\Coding\IDEA_java\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\rt.jar;E:\java\IdeaProjects\SSH\day01_structs2_demo01\out\production\mabatis-day01;D:\Coding\java\tomcat\apache-tomcat-8.5.31-windows-64位\apache-tomcat-8.5.31\lib\jsp-api.jar;D:\Coding\java\tomcat\apache-tomcat-8.5.31-windows-64位\apache-tomcat-8.5.31\lib\servlet-api.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\asm-3.3.1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\cglib-2.2.2.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-1.2.17.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\mybatis-3.2.7.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\slf4j-api-1.7.5.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-api-2.0-rc1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\log4j-core-2.0-rc1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\javassist-3.17.1-GA.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\slf4j-log4j12-1.7.5.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\commons-logging-1.1.1.jar;E:\java\IdeaProjects\SSH\mabatis-day01\lib\mysql-connector-java-8.0.11.jar;D:\Coding\java\maven_repository\junit\junit\4.12\junit-4.12.jar;D:\Coding\java\maven_repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.cwl.test.Demo02,test02
---before---
DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 1073533248.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - ==>  Preparing: insert into user(username, sex,birthday, address) value (?,?,?,?); 
DEBUG [main] - ==> Parameters: cwl2(String), 2(String), 2020-12-06 17:41:29.205(Timestamp), 广州(String)
DEBUG [main] - <==    Updates: 1
DEBUG [main] - Committing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
=====1
---after---
DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]
DEBUG [main] - Returned connection 1073533248 to pool.

Process finished with exit code 0