"C:\Program Files\Java\jdk1.8.0_261\bin\java.exe" "-javaagent:E:\IDEA\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=63167:E:\IDEA\IntelliJ IDEA 2019.3.3\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_261\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_261\jre\lib\rt.jar;E:\IDEA\第六阶段\mybatis\mapperdemo\out\production\mapperdemo;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\asm-7.1.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\cglib-3.3.0.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\ognl-3.2.14.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\log4j-1.2.17.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\mybatis-3.5.5.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\jsqlparser-3.1.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\log4j-api-2.13.3.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\slf4j-api-1.7.30.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\log4j-core-2.13.3.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\pagehelper-5.1.11.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\commons-logging-1.2.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\javassist-3.27.0-GA.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\slf4j-log4j12-1.7.30.jar;E:\北京尚学堂java 20200921\第六阶段\src1\软件\lib\mysql-connector-java-5.1.48.jar" com.bjsxt.test.InsertUsersGetKeyTest
<2021-02-09 19:21:51,385> DEBUG (LogFactory.java:105) [main] (org.apache.ibatis.logging.LogFactory) - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
<2021-02-09 19:21:51,394> DEBUG (VFS.java:116) [main] (org.apache.ibatis.io.VFS) - Class not found: org.jboss.vfs.VFS
<2021-02-09 19:21:51,395> DEBUG (JBoss6VFS.java:149) [main] (org.apache.ibatis.io.JBoss6VFS) - JBoss 6 VFS API is not available in this environment.
<2021-02-09 19:21:51,397> DEBUG (VFS.java:116) [main] (org.apache.ibatis.io.VFS) - Class not found: org.jboss.vfs.VirtualFile
<2021-02-09 19:21:51,397> DEBUG (VFS.java:64) [main] (org.apache.ibatis.io.VFS) - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
<2021-02-09 19:21:51,397> DEBUG (VFS.java:74) [main] (org.apache.ibatis.io.VFS) - Using VFS adapter org.apache.ibatis.io.DefaultVFS
<2021-02-09 19:21:51,397> DEBUG (DefaultVFS.java:220) [main] (org.apache.ibatis.io.DefaultVFS) - Find JAR URL: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/pojo
<2021-02-09 19:21:51,398> DEBUG (DefaultVFS.java:247) [main] (org.apache.ibatis.io.DefaultVFS) - Not a JAR: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/pojo
<2021-02-09 19:21:51,426> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: Users.class
<2021-02-09 19:21:51,426> DEBUG (DefaultVFS.java:111) [main] (org.apache.ibatis.io.DefaultVFS) - Listing file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/pojo
<2021-02-09 19:21:51,426> DEBUG (DefaultVFS.java:220) [main] (org.apache.ibatis.io.DefaultVFS) - Find JAR URL: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/pojo/Users.class
<2021-02-09 19:21:51,427> DEBUG (DefaultVFS.java:247) [main] (org.apache.ibatis.io.DefaultVFS) - Not a JAR: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/pojo/Users.class
<2021-02-09 19:21:51,427> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: ���� 4 =
<2021-02-09 19:21:51,428> DEBUG (ResolverUtil.java:288) [main] (org.apache.ibatis.io.ResolverUtil) - Checking to see if class com.bjsxt.pojo.Users matches criteria [is assignable to Object]
<2021-02-09 19:21:51,449> DEBUG (PooledDataSource.java:363) [main] (org.apache.ibatis.datasource.pooled.PooledDataSource) - PooledDataSource forcefully closed/removed all connections.
<2021-02-09 19:21:51,449> DEBUG (PooledDataSource.java:363) [main] (org.apache.ibatis.datasource.pooled.PooledDataSource) - PooledDataSource forcefully closed/removed all connections.
<2021-02-09 19:21:51,450> DEBUG (PooledDataSource.java:363) [main] (org.apache.ibatis.datasource.pooled.PooledDataSource) - PooledDataSource forcefully closed/removed all connections.
<2021-02-09 19:21:51,450> DEBUG (PooledDataSource.java:363) [main] (org.apache.ibatis.datasource.pooled.PooledDataSource) - PooledDataSource forcefully closed/removed all connections.
<2021-02-09 19:21:51,452> DEBUG (DefaultVFS.java:220) [main] (org.apache.ibatis.io.DefaultVFS) - Find JAR URL: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper
<2021-02-09 19:21:51,452> DEBUG (DefaultVFS.java:247) [main] (org.apache.ibatis.io.DefaultVFS) - Not a JAR: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper
<2021-02-09 19:21:51,452> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: UsersMapper.class
<2021-02-09 19:21:51,454> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: UsersMapper.xml
<2021-02-09 19:21:51,454> DEBUG (DefaultVFS.java:111) [main] (org.apache.ibatis.io.DefaultVFS) - Listing file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper
<2021-02-09 19:21:51,454> DEBUG (DefaultVFS.java:220) [main] (org.apache.ibatis.io.DefaultVFS) - Find JAR URL: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper/UsersMapper.class
<2021-02-09 19:21:51,454> DEBUG (DefaultVFS.java:247) [main] (org.apache.ibatis.io.DefaultVFS) - Not a JAR: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper/UsersMapper.class
<2021-02-09 19:21:51,454> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: ���� 4 @ > ? selectUsersAll ()Ljava/util/List; Signature *()Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersById (I)Lcom/bjsxt/pojo/Users; selectUsersOrderParam 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; N(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersAnnParam "RuntimeVisibleParameterAnnotations %Lorg/apache/ibatis/annotations/Param; value name sex selectUsersPOJOParam ((Lcom/bjsxt/pojo/Users;)Ljava/util/List; @(Lcom/bjsxt/pojo/Users;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersMapParam !(Ljava/util/Map;)Ljava/util/List; _(Ljava/util/Map<Ljava/lang/String;Ljava/lang/String;>;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsers (I)Ljava/util/List; +(I)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersRowBounds 7(Lorg/apache/ibatis/session/RowBounds;)Ljava/util/List; O(Lorg/apache/ibatis/session/RowBounds;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersLimit (II)Ljava/util/List; ,(II)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; offset limit insertUsers (Lcom/bjsxt/pojo/Users;)I insertUsersGetKey (Lcom/bjsxt/pojo/Users;)V insertUsersGetKey2 selectUsersByProperty selectUsersByChoose selectUsersByPropertyWhere selectUsersByLikeName $(Ljava/lang/String;)Ljava/util/List; <(Ljava/lang/String;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; usersUpdate selectUsersByIdUseCollection ((Ljava/util/Collection;)Ljava/util/List; @(Ljava/util/Collection;)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersByIdUseArray ([I)Ljava/util/List; ,([I)Ljava/util/List<Lcom/bjsxt/pojo/Users;>; selectUsersCount (Ljava/util/Map;)I 8(Ljava/util/Map<Ljava/lang/String;Ljava/lang/String;>;)I suibian insertUsersBatch (Ljava/util/List;)I +(Ljava/util/List<Lcom/bjsxt/pojo/Users;>;)I
<2021-02-09 19:21:51,455> DEBUG (DefaultVFS.java:220) [main] (org.apache.ibatis.io.DefaultVFS) - Find JAR URL: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper/UsersMapper.xml
<2021-02-09 19:21:51,455> DEBUG (DefaultVFS.java:247) [main] (org.apache.ibatis.io.DefaultVFS) - Not a JAR: file:/E:/IDEA/%e7%ac%ac%e5%85%ad%e9%98%b6%e6%ae%b5/mybatis/mapperdemo/out/production/mapperdemo/com/bjsxt/mapper/UsersMapper.xml
<2021-02-09 19:21:51,457> DEBUG (DefaultVFS.java:100) [main] (org.apache.ibatis.io.DefaultVFS) - Reader entry: <?xml version="1.0" encoding="UTF-8"?>
<2021-02-09 19:21:51,458> DEBUG (ResolverUtil.java:288) [main] (org.apache.ibatis.io.ResolverUtil) - Checking to see if class com.bjsxt.mapper.UsersMapper matches criteria [is assignable to Object]
<2021-02-09 19:21:51,583> DEBUG (JdbcTransaction.java:137) [main] (org.apache.ibatis.transaction.jdbc.JdbcTransaction) - Opening JDBC Connection
Tue Feb 09 19:21:51 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
<2021-02-09 19:21:51,818> DEBUG (PooledDataSource.java:434) [main] (org.apache.ibatis.datasource.pooled.PooledDataSource) - Created connection 1607305514.
<2021-02-09 19:21:51,819> DEBUG (JdbcTransaction.java:101) [main] (org.apache.ibatis.transaction.jdbc.JdbcTransaction) - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5fcd892a]
<2021-02-09 19:21:51,822> DEBUG (BaseJdbcLogger.java:137) [main] (com.bjsxt.mapper.UsersMapper.insertUsersGetKey) - ==> Preparing: insert into users values(default ,?,?)
<2021-02-09 19:21:51,849> DEBUG (BaseJdbcLogger.java:137) [main] (com.bjsxt.mapper.UsersMapper.insertUsersGetKey) - ==> Parameters: itbz-sxt3(String), male(String)
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: Field 'userid' doesn't have a default value
### The error may exist in com/bjsxt/mapper/UsersMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into users values(default ,?,?)
### Cause: java.sql.SQLException: Field 'userid' doesn't have a default value
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
at com.sun.proxy.$Proxy4.insertUsersGetKey(Unknown Source)
at com.bjsxt.test.InsertUsersGetKeyTest.main(InsertUsersGetKeyTest.java:15)
Caused by: java.sql.SQLException: Field 'userid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1251)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
at com.sun.proxy.$Proxy6.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
... 6 more
Process finished with exit code 1
package com.bjsxt.test;
import com.bjsxt.mapper.UsersMapper;
import com.bjsxt.pojo.Users;
import com.bjsxt.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
public class InsertUsersGetKeyTest {
public static void main(String[] args) {
SqlSession sqlSession = MybatisUtils.getSqlSession();
UsersMapper usersMapper = sqlSession.getMapper(UsersMapper.class);
Users users = new Users();
users.setUsername("itbz-sxt3");
users.setUsersex("male");
usersMapper.insertUsersGetKey(users);
sqlSession.commit();
System.out.println(users.getUserid());
MybatisUtils.closeSqlSession();
}
}
不知道为什么出错。。