亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定

插入數據的問題

entity:
@Data
@TableName("sys_area")
public?class?Area?{

????@TableId
????private?Integer?areaId;

????private?String?areaName;

????private?Integer?priority;

????private?Date?createTime;

????private?Date?lastEditTime;
}
Test方法
????@Test
????public?void?addUer(){

????????Area?area?=?new?Area();
????????area.setAreaName("南苑");
????????area.setPriority(3);
//????????area.setAreaId(1);
????????area.setCreateTime(new?Date());
????????area.setLastEditTime(new?Date());
????????areaMapper.insert(area);
//????????System.out.println("insertID="+id);
????}
報錯如下
Creating?a?new?SqlSessionSqlSession
?[org.apache.ibatis.session.defaults.DefaultSqlSession@319c3a25]?was?not?registered?for?synchronization?because?synchronization?is?not?active
?Closing?non?transactional?SqlSession?[org.apache.ibatis.session.defaults.DefaultSqlSession@319c3a25]org.mybatis.spring.MyBatisSystemException:?nested?exception?is?org.apache.ibatis.reflection.ReflectionException:?Could?not?set?property?'areaId'?of?'class?com.imooc.secondapp.entiy.Area'?with?value?'1294924723589332994'?Cause:?java.lang.IllegalArgumentException:?argument?type?mismatch	
?at?org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)	
?at?org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)	
?at?com.sun.proxy.$Proxy53.insert(Unknown?Source)	
?at?org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)	
?at?com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:68)	
?at?com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)	
?at?com.sun.proxy.$Proxy61.insert(Unknown?Source)	
?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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)	
?at?org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)	
?at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)	
?at?org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)	
?at?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)	
?at?org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)	
?at?com.sun.proxy.$Proxy62.insert(Unknown?Source)	
?at?com.imooc.secondapp.SecondAppApplicationTests.addUer(SecondAppApplicationTests.java:38)	
?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.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:686)	
?at?org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)	
?at?org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)	
?at?org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)	
?at?org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)	
?at?org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)	
?at?org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)	
?at?org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)	
?at?org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)	
?at?org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)	
?at?org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)	
?at?org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)	
?at?org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)	at?org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)	at?org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:212)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	
?at?org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:208)	at?org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:137)	at?org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:71)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)	
?at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)	at?org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	
?at?org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)	at?java.util.ArrayList.forEach(ArrayList.java:1249)	at?org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)	at?org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)	at?java.util.ArrayList.forEach(ArrayList.java:1249)	at?org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)	at?org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)	at?org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)	at?org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)	at?org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)	at?org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)	at?org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)	at?org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)	at?org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)	at?org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)	at?org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)	at?org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)	at?com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69)	at?com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)	at?com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)	at?com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)Caused?by:?org.apache.ibatis.reflection.ReflectionException:?Could?not?set?property?'areaId'?of?'class?com.imooc.secondapp.entiy.Area'?with?value?'1294924723589332994'?Cause:?java.lang.IllegalArgumentException:?argument?type?mismatch	at?org.apache.ibatis.reflection.wrapper.BeanWrapper.setBeanProperty(BeanWrapper.java:185)	at?org.apache.ibatis.reflection.wrapper.BeanWrapper.set(BeanWrapper.java:59)	at?org.apache.ibatis.reflection.MetaObject.setValue(MetaObject.java:140)	at?com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.populateKeys(MybatisDefaultParameterHandler.java:209)	at?com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.processBatch(MybatisDefaultParameterHandler.java:147)	at?com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.<init>(MybatisDefaultParameterHandler.java:59)	at?com.baomidou.mybatisplus.core.MybatisXMLLanguageDriver.createParameterHandler(MybatisXMLLanguageDriver.java:37)	at?org.apache.ibatis.session.Configuration.newParameterHandler(Configuration.java:545)	at?org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:69)	at?org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:40)	at?org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:46)	at?org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:558)	at?org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)	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:198)	at?org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)	...?80?moreCaused?by:?java.lang.IllegalArgumentException:?argument?type?mismatch	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.reflection.invoker.MethodInvoker.invoke(MethodInvoker.java:41)	at?org.apache.ibatis.reflection.wrapper.BeanWrapper.setBeanProperty(BeanWrapper.java:180)	...?101?more2020-08-16?17:11:27.324??INFO?7676?---?[extShutdownHook]?com.zaxxer.hikari.HikariDataSource???????:?HikariPool-1?-?Shutdown?initiated...2020-08-16?17:11:27.329??INFO?7676?---?[extShutdownHook]?com.zaxxer.hikari.HikariDataSource???????:?HikariPool-1?-?Shutdown?completed.Process?finished?with?exit?code?255


正在回答

2 回答

我懷疑這應該是MP默認主鍵策略的問題,你沒配置策略,他的默認策略是雪花算法,用雪花算法生成主鍵了。而你主鍵類型為Integer,最大21億左右,超范圍了,所以報錯。后來你配置了策略為AUTO,就是數據庫自增,MP就不給你設置主鍵了,所以正常。

0 回復 有任何疑惑可以回復我~

但是我用這樣就可以插入了。

我這個樣子寫就沒有問題了。老師請問這是問什么了?

http://img1.sycdn.imooc.com//5f38fe6e00018ecd11140790.jpg

0 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

插入數據的問題

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號