结果集为什么会查询出多条？

Blade 未结

关注举报

 1  565

3092844924 剑圣 2021-05-17 13:26

一、该问题的重现步骤是什么？

1. 这是用代码生成改过之后的代码,并非你们所写。

2.具体为什么selectOne对应的结果集超过了1条，个人推测是:单击记录详情的时候，可能没有where条件，但是有时能，有时又不能，原因不清楚。

3.以下是有关的代码：

[_7E(}9V8DJ32N2$L]PS31K.png

$8D_SU`22{{{NUSFQE[Y_X$3.png$ VQ305{EJNDR}I(NAZ5}SJWP.png DMJOOPP~NKQXM[QMS(X7E@8.png 二、你期待的结果是什么？实际看到的又是什么？

三、你正在使用的是什么产品，什么版本？在什么操作系统上？

四、请提供详细的错误堆栈信息，这很重要。

================ Request Start ================

===> GET: /desk/projectmanager/detail Parameters: {"projectmanager":{"id":null,"projectname":null,"mainid":null,"main":null,"viceid":null,"vice":null,"risk":null,"deadline":null,"feelline":null}}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJ1c2VyIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDgiLCJ1c2VyX2lkIjoiMTM5MzA3NDMwNTY3NTkyNzU1MyIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAyIiwidXNlcl9uYW1lIjoiemhhbmdzYW4iLCJuaWNrX25hbWUiOiLlvKDkuIkiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiemhhbmdzYW4iLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTYyMDk4OTIzNiwibmJmIjoxNjIwOTg1NjM2fQ.qhit0MqzzLDpPBOcro6XsO6fUNj6Y4gUKnvVIn5L15YZakSl_-CqR8J5142jxKmWfr4KNWHZWsxB9afWA7MV8w

===Headers=== cookie: Webstorm-a327319a=fa239cad-a2aa-47fa-9b73-4ccd0b4bd083; _ga=GA1.1.1413714226.1617356461; Idea-8296e771=4d3f10ae-8b56-4211-b8a0-64a0bc09b9ef; saber-access-token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJ1c2VyIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDgiLCJ1c2VyX2lkIjoiMTM5MzA3NDMwNTY3NTkyNzU1MyIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAyIiwidXNlcl9uYW1lIjoiemhhbmdzYW4iLCJuaWNrX25hbWUiOiLlvKDkuIkiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiemhhbmdzYW4iLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTYyMDk4OTIzNiwibmJmIjoxNjIwOTg1NjM2fQ.qhit0MqzzLDpPBOcro6XsO6fUNj6Y4gUKnvVIn5L15YZakSl_-CqR8J5142jxKmWfr4KNWHZWsxB9afWA7MV8w; saber-refresh-token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ1c2VyX2lkIjoiMTM5MzA3NDMwNTY3NTkyNzU1MyIsInRva2VuX3R5cGUiOiJyZWZyZXNoX3Rva2VuIiwiY2xpZW50X2lkIjoic2FiZXIiLCJleHAiOjE2MjE1OTA0MzYsIm5iZiI6MTYyMDk4NTYzNn0.Ir-i-I2Sc2XfmRNmL_pV1XvoSQB4HjTtBiN-fxNgPyePd0bvIV3u39DVydkvzlRyFb1bY4n1BiUs8kTFFxfATg

===Headers=== accept-language: zh-CN,zh;q=0.9

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== sec-ch-ua: "Google Chrome";v="89", "Chromium";v="89", ";Not A Brand";v="99"

===Headers=== sec-ch-ua-mobile: ?0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: 192.168.0.135:8089

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2021-05-14 17:47:25.697 INFO 9600 --- [ XNIO-1 task-77] o.s.core.mp.plugins.SqlLogInterceptor :

============== Sql Start ==============

Execute SQL : select id, projectName, mainId, main, viceId , vice, risk, deadline, feelline from projectmanager

Execute Time: 12.251ms

============== Sql End ==============

2021-05-14 17:47:25.697 INFO 9600 --- [ XNIO-1 task-77] o.s.core.log.aspect.RequestLogAspect :

=============== Response Start ================

<=== GET: /desk/projectmanager/detail (19 ms)

=============== Response End ================

2021-05-14 17:47:25.701 ERROR 9600 --- [ XNIO-1 task-77] o.s.c.l.e.BladeRestExceptionTranslator : 服务器异常

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)

at com.sun.proxy.$Proxy156.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at com.sun.proxy.$Proxy198.selectOne(Unknown Source)

at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.getOne(ServiceImpl.java:201)

at com.baomidou.mybatisplus.extension.service.IService.getOne(IService.java:229)

at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687)

at org.springblade.modules.desk.service.impl.ProjectmanagerServiceImpl$$EnhancerBySpringCGLIB$$6ad5ccf5.getOne(<generated>)

at org.springblade.modules.desk.controller.ProjectmanagerController.detail(ProjectmanagerController.java:60)

at org.springblade.modules.desk.controller.ProjectmanagerController$$FastClassBySpringCGLIB$$8b6cf941.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)

at org.springblade.core.log.aspect.RequestLogAspect.aroundApi(RequestLogAspect.java:112)

at sun.reflect.GeneratedMethodAccessor495.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)

at org.springblade.modules.desk.controller.ProjectmanagerController$$EnhancerBySpringCGLIB$$c9b563e2.detail(<generated>)

at sun.reflect.GeneratedMethodAccessor585.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)

at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)

at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)

at org.springblade.core.log.filter.LogTraceFilter.doFilter(LogTraceFilter.java:39)

at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)