6.mybatis of JavaBean
Today use MyBatis time unprovoked error, looked for a half day also did not find out:
"C:\Program Files\java\jdk1.8.0_144\bin\java" "-javaagent:d:\intellij idea 2017.1.3\lib\idea_rt.jar=54835:d:\ IntelliJ idea 2017.1.3\bin "-dfile.encoding=utf-8-classpath" C:\Program files\java\jdk1.8.0_144\jre\lib\ Charsets.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\deploy.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\access-bridge-64.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\cldrdata.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\dnsns.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\jaccess.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\jfxrt.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\localedata.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\nashorn.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\sunec.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\sunjce_provider.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\sunmscapi.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\ext\sunpkcs11.jar; C:\Program FILES\JAVA\JDK1.8.0_144\JRE\LIB\EXT\ZIPFS.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\javaws.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\jce.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\jfr.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\jfxswt.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\jsse.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\management-agent.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\plugin.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\resources.jar; C:\Program Files\java\jdk1.8.0_144\jre\lib\rt.jar; E:\IDEA\Mybatis01\target\test-classes; E:\idea\mybatis01\target\classes;d:\intellij Idea 2017.1.3\lib\junit-4.12.jar;d:\intellij Idea 2017.1.3\lib\ Hamcrest-core-1.3.jar; E:\Java\repo\junit\junit\4.10\junit-4.10.jar; E:\Java\repo\org\hamcrest\hamcrest-core\1.1\hamcrest-core-1.1.jar; E:\Java\repo\org\mybatis\mybatis\3.4.4\mybatis-3.4.4.jar; E:\Java\repo\com\fasterxml\jackson\core\jackson-core\2.2.1\jackson-core-2.2.1.jar; E:\Java\repo\com\fasterxml\jackson\core\jackson-databind\2.2.1\jackson-databind-2.2.1.jar; E:\Java\repo\com\fasterxml\jackson\core\jackson-annotations\2.2.1\jackson-annotations-2.2.1.jar; E:\Java\repo\org\junit\jupiter\junit-jupiter-api\5.0.0-RC2\junit-jupiter-api-5.0.0-RC2.jar; E:\Java\repo\org\opentest4j\opentest4j\1.0.0-RC1\opentest4j-1.0.0-RC1.jar; E:\Java\repo\org\junit\platform\junit-platform-commons\1.0.0-RC2\junit-platform-commons-1.0.0-RC2.jar; E:\Java\repo\mysql\mysql-connector-java\5.1.43\mysql-connector-java-5.1.43.jar "test6org.apache.ibatis.exceptions.PersistenceException: # # # Error querying database. Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.string]### the error could exist in Mappers /personmapper.xml### The error may involve person.getpersonlist### the error occurred whilehandling results### sql:select ID, name, age, remark from person LIMIT?, ?# # # Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.exceptions.ExceptionFactory.wrapException (Exceptionfactory.java:30) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:150) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:141) at DAO. Persondao.getpersonlist (Persondao.java:79) at Test6.main (Test6.java:15) caused By:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.executor . ResultSet. Defaultresultsethandler.createbyconstructorsignature (Defaultresultsethandler.java:660) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:613) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:48W) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue (Defaultresultsethandler.java: 388) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap ( Defaultresultsethandler.java:347) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues ( Defaultresultsethandler.java:322) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet ( Defaultresultsethandler.java:295) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets ( Defaultresultsethandler.java:192) at Org.apache.ibatis.executor.statement.PreparedStatementHandler.query (Preparedstatementhandler.java:64) at Org.apache.ibatis.executor.statement.RoutingStatementHandler.query (Routingstatementhandler.java:79) at Org.apache.ibatis.executor.SimpleExecutor.doQuery (Simpleexecutor.java:63) at Org.apache.ibatis.executor.BaseExecutor.queryFromDatabase (Baseexecutor.java:324) at Org.apache.ibatis.executor.BaseExecutor.query (Baseexecutor.java:156) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:109) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:83) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:148) ... 3 MoreNULLNULLorg.apache.ibatis.exceptions.PersistenceException: # # # Error querying database. Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.string]### the error could exist in Mappers /personmapper.xml### The error may involve person.getpersonlist### the error occurred whilehandling results### sql:select ID, name, age, remark from person LIMIT?, ?# # # Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.exceptions.ExceptionFactory.wrapException (Exceptionfactory.java:30) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:150) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:141) at DAO. Persondao.getpersonlist (Persondao.java:79) at Test6.main (Test6.java:17) caused By:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.executor . ResultSet. Defaultresultsethandler.createbyconstructorsignature (Defaultresultsethandler.java:660) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:613) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:48W) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue (Defaultresultsethandler.java: 388) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap ( Defaultresultsethandler.java:347) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues ( Defaultresultsethandler.java:322) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet ( Defaultresultsethandler.java:295) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets ( Defaultresultsethandler.java:192) at Org.apache.ibatis.executor.statement.PreparedStatementHandler.query (Preparedstatementhandler.java:64) at Org.apache.ibatis.executor.statement.RoutingStatementHandler.query (Routingstatementhandler.java:79) at Org.apache.ibatis.executor.SimpleExecutor.doQuery (Simpleexecutor.java:63) at Org.apache.ibatis.executor.BaseExecutor.queryFromDatabase (Baseexecutor.java:324) at Org.apache.ibatis.executor.BaseExecutor.query (Baseexecutor.java:156) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:109) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:83) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:148) ... 3moreorg.apache.ibatis.exceptions.PersistenceException: # # # Error querying database. Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.string]### the error could exist in Mappers /personmapper.xml### The error may involve person.getpersonlist### the error occurred whilehandling results### sql:select ID, name, age, remark from person LIMIT?, ?# # # Cause:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.exceptions.ExceptionFactory.wrapException (Exceptionfactory.java:30) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:150) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:141) at DAO. Persondao.getpersonlist (Persondao.java:79) at Test6.main (Test6.java:19) caused By:org.apache.ibatis.executor.ExecutorException:No constructor found in entity. person matching [Java.lang.Long, java.lang.String, Java.lang.Integer, java.lang.String] at Org.apache.ibatis.executor . ResultSet. Defaultresultsethandler.createbyconstructorsignature (Defaultresultsethandler.java:660) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:613) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject ( Defaultresultsethandler.java:48W) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue (Defaultresultsethandler.java: 388) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap ( Defaultresultsethandler.java:347) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues ( Defaultresultsethandler.java:322) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet ( Defaultresultsethandler.java:295) at Org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets ( Defaultresultsethandler.java:192) at Org.apache.ibatis.executor.statement.PreparedStatementHandler.query (Preparedstatementhandler.java:64) at Org.apache.ibatis.executor.statement.RoutingStatementHandler.query (Routingstatementhandler.java:79) at Org.apache.ibatis.executor.SimpleExecutor.doQuery (Simpleexecutor.java:63) at Org.apache.ibatis.executor.BaseExecutor.queryFromDatabase (Baseexecutor.java:324) at Org.apache.ibatis.executor.BaseExecutor.query (Baseexecutor.java:156) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:109) at Org.apache.ibatis.executor.CachingExecutor.query (Cachingexecutor.java:83) at Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (Defaultsqlsession.java:148) ... 3 MoreNULLProcess finished with exit code0
And then I knew it was me. A custom constructor is written in JavaBean, which causes the default parameterless constructor to be overwritten. The default constructor is called when the MyBatis query results in JavaBean, and is not found. The solution is to explicitly write out the default parameterless constructor after defining the custom constructor.
Packageentity;/*** Created by Administrator on 2017/8/5. * Entity class for person*/ Public classPerson {PrivateInteger ID; PrivateString name; PrivateInteger age; PrivateString Remark; /*MyBatis corresponding JavaBean must have a default parameterless constructor, * If we customize the constructor of a parameter, we will overwrite it, when executing the query, *mybatis cannot save the parameter, so we want to write its explicit*/ PublicPerson () {}//Full-parameter constructors PublicPerson (integer ID, String name, integer age,string remark) {Super(); This. ID =ID; This. Name =name; This. Age =Age ; This. Remark =remark; } //constructors that do not contain IDs PublicPerson (String name, Integer age,string remark) {Super(); This. Name =name; This. Age =Age ; This. Remark =remark; } PublicInteger getId () {returnID; } Public voidsetId (Integer id) { This. ID =ID; } PublicString GetName () {returnname; } Public voidsetName (String name) { This. Name =name; } PublicInteger getage () {returnAge ; } Public voidsetage (Integer age) { This. Age =Age ; } PublicString Getremark () {returnremark; } Public voidSetremark (String remark) { This. Remark =remark; }}
6.mybatis of JavaBean