请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
qqq(uid:1079757)
职业资格认证:FCA-FineReport
  • 是前一天,在线等
  • 想要这种效果,显示成几月几日,下面日期是控件日期的前一天
  • 我想给带宽这个字段添加一个参数,大致如下,如果这个参数为空或者选择的是全量,那么返回该字段所有值,如果选择千兆,那么就返回1000或者1024000
  • where  left(结束时间,7)='2022-08-08' and (业务类型 not like '%A%' and 业务类型<>'B' and 业务类型<>'C' or 业务类型 is null)  我想知道在这个条件下,业务类型为空的值能不能查出来,如果能,那写 or 业务类型 is null    这句话的意义是什么
  • javax.mail.AuthenticationFailedException: 535 Login Fail. Please enter your authorization code to login. More information in http://service.mail.qq.com/cgi-bin/help?subtype=1&&id=28&&no=1001256at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:965)at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:876)at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:780)at javax.mail.Service.connect(Service.java:388)at javax.mail.Service.connect(Service.java:246)at com.fr.base.EmailManager.connect(EmailManager.java)at com.fr.base.EmailManager.sendEmail(EmailManager.java)at com.fr.base.EmailManager.send(EmailManager.java)at com.fr.base.EmailManager.sendWithRecord(EmailManager.java)at com.fr.base.EmailManager.send(EmailManager.java)at com.fr.base.EmailManager.send(EmailManager.java)at com.fr.base.EmailManager.send(EmailManager.java)at com.fr.base.EmailManager.send(EmailManager.java)at com.fr.base.EmailManager.sendTestMail(EmailManager.java)at com.fr.decision.webservice.v10.config.ConfigService.testEmailConnection(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 com.fr.decision.config.ConfigInterceptor.intercept(Unknown Source)at com.fr.decision.webservice.v10.config.ConfigService$$EnhancerByCGLIB$$fb9e39a3.testEmailConnection(at com.fr.web.controller.decision.api.config.EmailResource.testEmail(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 com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.fr.decision.webservice.BackupActivator$1.doFilter(Unknown Source)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.fr.decision.webservice.filter.TenantFilter.doFilter(Unknown Source)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(Unknown Source)at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown Source)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1647)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:748)
  •  最后一列计算方式为(b+d)/(a+c),但是目前有的值显示null,怎么写sql语句才能正常计算这一列的值,

31

124

31

10

个人成就
内容被浏览8,196
加入社区2年256天
返回顶部