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

MyBatis插⼊数据运⾏成功但是数据库没有数据问题解决⽅案MyBatis插⼊数据运⾏成功但是数据库没有数据问题解决⽅案/***插⼊数据**@throwsIOException*/@Testpublicvoidtest02()throwsIOException{Useruser=newUser("cwl2","2",newDate(),"⼴州");intresult=sqlSession.insert("insertUser",user);System.out.println("====="+result);}显⽰运⾏成功"C:\ProgramFiles\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:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\ProgramFiles\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"ellij.rt.execution.junit.JUnitStarter-ideVersion5-junit4com.cwl.test.Demo02,test02---before---DEBUG[main]-Logginginitializedusing'classorg.apache.ibatis.logging.slf4j.Slf4jImpl'adapter.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-OpeningJDBCConnectionDEBUG[main]-Createdconnection1073533248.DEBUG[main]-SettingautocommittofalseonJDBCConnection[com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]DEBUG[main]-==>Preparing:insertintouser(username,sex,birthday,address)value(?,?,?,?);DEBUG[main]-==>Parameters:cwl2(String),2(String),2020-12-0617:36:22.056(Timestamp),⼴州(String)DEBUG[main]-<==Updates:1DEBUG[main]-CommittingJDBCConnection[com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]=====1---after---DEBUG[main]-ResettingautocommittotrueonJDBCConnection[com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]DEBUG[main]-ClosingJDBCConnection[com.mysql.cj.jdbc.ConnectionImpl@3ffcd140]DEBUG[main]-Returnedconnection1073533248topool.Processfinishedwithexitcode0但是数据库没有数据这个时候很明显是数据没有提交加代码sqlSmit();即可/***插⼊数据**@throwsIOException*/@Testpublicvoidtest02()throwsIOException{Useruser=newUser("cwl2","2",newDate(),"⼴州");intresult=sqlSession.insert("insertUser",user);sqlSmit();System.out.println("====="+result);}成功运⾏"C:\ProgramFiles\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:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\ProgramFiles\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\ProgramFiles\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"ellij.rt.execution.junit.JUnitStarter-ideVersion5-junit4com.cwl.test.Demo02,test02---before---DEBUG[main]-Logginginitializedusing'classorg.apache.ibatis.logging.slf4j.Slf4jImpl'adapter.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.DEBUG[main]-PooledDataSourceforcefullyclosed/removedallconnections.D