expect DOT, actual DOT pos 27, line 2, column 13, token DOT；SQL state [null]；

最新推荐文章于 2023-09-27 16:51:38 发布
最新推荐文章于 2023-09-27 16:51:38 发布
阅读量1.2k 收藏
点赞数
分类专栏： Java Spring 文章标签： sql 数据库 sqlserver
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/WoodYangOY/article/details/126639957
版权
Java 同时被 2 个专栏收录
11 篇文章 0 订阅
订阅专栏
Spring
9 篇文章 1 订阅
订阅专栏

项目场景：

新增数据的一个接口，页面请求数据，保存数据在其他系统，还有请求日志保存操作。
数据库：sqlserver、mysql

问题描述

此bug刚开发现是偶发性，请求就报错，重启后这种情况就不存在了，等一段时间，又会出现。
后续通过测试稳定复现后发现，有一个参数（主键），同一个主键的情况下，第一次请求会报错，第二次请求就是不会报错。
看到sql报错后就一直围绕sqlserver sql 语法上进行排查问题，请教了大佬，也尝试了很多方法优化sql，排除关键字，都是无效。

报错sql： sql看起来也没什么问题

    SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = #{staffId}

问题代码：这段代码看起来没什么错，转换保存数据用的


    @Override
    public void add(String bizType, String params, String result, String errorMessage) {
        this.save(crmToErpSysLog);
    }
    
    @Async("taskLogExecutor")
    @Override
    public void saveResult(String bizType, String param, String result) {
        add(bizType, JSONObject.toJSONString(param), resultCode, errorMsg);
    }

报错日志

Creating a new SqlSession
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5dd014d2] was not registered for synchronization because synchronization is not active
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4d2d8d3b] was not registered for synchronization because synchronization is not active
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5a8e80c7] will not be managed by Spring
==>  Preparing: SELECT top (1) tbdsl.FNAME AS fname , t_bd_operatorentry.FNUMBER AS fnumber FROM T_BD_STAFF tbds LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID WHERE tbds.FNUMBER = ?
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5dd014d2]
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5a8e80c7] will not be managed by Spring
==>  Preparing: INSERT INTO crm_to_erp_sys_log ( biz_type, params, result, origin, destination, create_time, update_time ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
==> Parameters: CONTRACT(String), "{\"ignoreInterationFlag\":\"\",\"interationFlags\":\"\",\"isAutoAdjustField\":\"false\",\"isAutoSubmitAndAudit\":\"true\",\"isDeleteEntry\":\"true\",\"isEntryBatchFill\":\"true\",\"isVerifyBaseDataField\":\"false\",\"model\":{\"fDataValue\":\"HT202208300111112\",\"fEntryID\":0,\"fId\":{\"fNumber\":\"keyanhetong\"},\"fNumber\":\"HT202208300111112\"},\"needReturnFields\":[],\"needUpDateFields\":[],\"numberSearch\":\"true\",\"subSystemId\":\"\",\"validateFlag\":\"true\"}"(String), 0(String), CRM(String), ERP(String), 2022-08-31T14:23:40.367008(LocalDateTime), 2022-08-31T14:23:40.367008(LocalDateTime)
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4d2d8d3b]
2022-08-31 14:23:40.618 ERROR 42168 --- [nio-8012-exec-1] c.n.c.d.advice.WebExceptionAdvice        : RuntimeException occurred

org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
### The error may exist in file [D:\Project\dsc-data\nmdx-cloud-dataswitchcenter\target\classes\mapper\erp\ErpUserMapper.xml]
### The error may involve com.nmdx.cloud.dataswitchcenter.mapper.erp.ErpUserMapper.queryStaffSaleNumber
### The error occurred while executing a query
### SQL: SELECT top (1)       tbdsl.FNAME AS fname ,       t_bd_operatorentry.FNUMBER AS fnumber     FROM       T_BD_STAFF tbds       LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID       LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID     WHERE tbds.FNUMBER = ?
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) ~[spring-jdbc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at com.sun.proxy.$Proxy196.selectOne(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) ~[mybatis-spring-2.0.5.jar:2.0.5]
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.sun.proxy.$Proxy259.queryStaffSaleNumber(Unknown Source) ~[na:na]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpUserServiceImpl.queryStaffSaleNumber(ErpUserServiceImpl.java:63) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpUserServiceImpl$$FastClassBySpringCGLIB$$59a4ce8.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:49) ~[dynamic-datasource-spring-boot-starter-3.1.0.jar:3.1.0]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpUserServiceImpl$$EnhancerBySpringCGLIB$$bd5b6f41.queryStaffSaleNumber(<generated>) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.foreign.erp.processor.ErpSaleOrderProcessor.buildSaveOrderEntity(ErpSaleOrderProcessor.java:303) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.foreign.erp.processor.ErpSaleOrderProcessor$$FastClassBySpringCGLIB$$63fe5959.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:49) ~[dynamic-datasource-spring-boot-starter-3.1.0.jar:3.1.0]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.nmdx.cloud.dataswitchcenter.foreign.erp.processor.ErpSaleOrderProcessor$$EnhancerBySpringCGLIB$$e9166334.buildSaveOrderEntity(<generated>) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpSaleOrderServiceImpl.addSaleOrder(ErpSaleOrderServiceImpl.java:78) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpSaleOrderServiceImpl$$FastClassBySpringCGLIB$$62df3830.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:49) ~[dynamic-datasource-spring-boot-starter-3.1.0.jar:3.1.0]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at com.nmdx.cloud.dataswitchcenter.service.impl.ErpSaleOrderServiceImpl$$EnhancerBySpringCGLIB$$89d37e19.addSaleOrder(<generated>) ~[classes/:na]
	at com.nmdx.cloud.dataswitchcenter.controller.ErpSaleOrderController.addSaleOrder(ErpSaleOrderController.java:40) ~[classes/:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:888) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at com.nmdx.cloud.dataswitchcenter.filter.RepeatableFilter.doFilter(RepeatableFilter.java:40) ~[classes/:na]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108) ~[spring-boot-actuator-2.2.1.RELEASE.jar:2.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.27.jar:9.0.27]
	at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]
Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
	at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:805) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:258) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:350) ~[druid-1.1.22.jar:1.1.22]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
	at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55) ~[mybatis-3.5.6.jar:3.5.6]
	at com.sun.proxy.$Proxy400.prepareStatement(Unknown Source) ~[na:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) ~[mybatis-3.5.6.jar:3.5.6]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) ~[mybatis-3.5.6.jar:3.5.6]
	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:83) ~[mybatis-plus-extension-3.4.1.jar:3.4.1]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
	at com.sun.proxy.$Proxy399.prepare(Unknown Source) ~[na:na]
	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:94) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:68) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.6.jar:3.5.6]
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:165) ~[mybatis-plus-core-3.4.1.jar:3.4.1]
	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:65) ~[mybatis-plus-extension-3.4.1.jar:3.4.1]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
	at com.sun.proxy.$Proxy398.query(Unknown Source) ~[na:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~[mybatis-3.5.6.jar:3.5.6]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.5.jar:2.0.5]
	... 97 common frames omitted
Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:344) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:532) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:182) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:624) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:578) ~[druid-1.1.22.jar:1.1.22]
	at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:792) ~[druid-1.1.22.jar:1.1.22]
	... 137 common frames omitted

2022-08-31 14:23:40.650  WARN 42168 --- [nio-8012-exec-1] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
### The error may exist in file [D:\Project\dsc-data\nmdx-cloud-dataswitchcenter\target\classes\mapper\erp\ErpUserMapper.xml]
### The error may involve com.nmdx.cloud.dataswitchcenter.mapper.erp.ErpUserMapper.queryStaffSaleNumber
### The error occurred while executing a query
### SQL: SELECT top (1)       tbdsl.FNAME AS fname ,       t_bd_operatorentry.FNUMBER AS fnumber     FROM       T_BD_STAFF tbds       LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID       LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID     WHERE tbds.FNUMBER = ?
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?
; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'     tbdsl.FNAME AS fname ,
      t', expect DOT, actual DOT pos 27, line 2, column 13, token DOT : SELECT top (1)
      tbdsl.FNAME AS fname ,
      t_bd_operatorentry.FNUMBER AS fnumber
    FROM
      T_BD_STAFF tbds
      LEFT JOIN T_BD_STAFF_L tbdsl ON tbds.FSTAFFID = tbdsl.FSTAFFID
      LEFT JOIN T_BD_OPERATORENTRY t_bd_operatorentry ON t_bd_operatorentry.FSTAFFID = tbds.FSTAFFID
    WHERE tbds.FNUMBER = ?]

原因分析：

经过测试定位问题点得知异常是在保存数据代码那段的 @Async 注解 ，猜测可能是 SpringBoot 的事务和异步机制导致sql注入问题，导致sql报错。

解决方案：

将@Async 注解放其他方法上

    @Async("taskLogExecutor")
    @Override
    public void add(String bizType, String params, String result, String errorMessage) {
        this.save(crmToErpSysLog);
    }
   
    @Override
    public void saveResult(String bizType, String param, String result) {
        add(bizType, JSONObject.toJSONString(param), resultCode, errorMsg);
    }
WoodYangOY
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
如何通过金蝶云星空API，创建客户联系人？
m0_51344028的博客
10-17 350
这个问题之所以存在，是因为按照正常的方式去创建客户联系人，发现都创建失败了！文档里客户联系人是客户的一个子单据体，实际上是动态表单，要想为客户创建联系人，需要根据：供应链-》采购管理-》联系人，按照这个接口去创建客户的联系人。 适用场景：纷享销客CRM客户联系人向金蝶云星空同步客户联系人，文档中没有特别的说明，按照文档中的方法无法创建，按照本文方法可以为客户创建联系人。 JSON数据： { "NeedUpDateFields":[ ], "NeedReturnFie.
Shiro——Bug篇——AuthenticationException 异常无法自定义返回值结果集
WoodYangOY的博客
03-29 2579
项目场景： 刚接触到公司的项目时候，项目内没有权限框架这一块，后面项目成型之后引进权限框架shiro。 问题描述： 引进shiro后续发现一些问题，抛出AuthenticationException异常后，未能统一自定义返回结果集，前端未能接收到之前约定的状态码，导致token过期之后，结果集是shiro内部抛出的，后面导致前端访问后台所有的接口抛出次异常。 后续在全局自定义捕获器内增加此异常的捕获，发现根本捕获不了；在网上找了很久，都没有发现很好的解决方案，我都准备把shiro换成security（在
TSP问题——遗传算法matlab实现.zip_expect2v3_gravitytz9_tsp_行商问题matlab程序_路径
09-23
行商问题，自动生成最短路径。该算法可以生成经过拓扑每一点一次且仅一次最后回到起点的最短路径。
Web实验_expect6h2_Web；聊天室_web实验室名称_web聊天_ｗｅｂ_
09-30
简单的Web聊天室开发，有程序员登录窗口和用户登录窗口，且可通过数据库进行管理。
syntax error, expect {, actual [, pos 1, line 1, column 2[]
最新发布
我有一张床的博客
09-27 1808
syntax error, expect {, actual [, pos 1, line 1, column 2[]
MyBatis与MyBatis-Plus的分页以及转换
weixin_52721608的博客
08-29 1802
MyBatis和MyBatis-Plus都是Java持久化框架，用于简化数据库访问和操作。它们提供了面向对象的方式来管理关系型数据库中的数据。是一个轻量级的持久化框架，通过XML或注解配置，将SQL语句与Java对象进行映射，使开发者可以使用简单的API来执行数据库操作。MyBatis支持动态SQL、缓存、批处理等功能，并与多种数据库兼容。是在MyBatis的基础上构建的增强版框架。它提供了更多的便利功能和增强特性，使开发者能够更加高效地进行数据库访问。
JSON解析错误:语法错误，expect {， actual [， pos 1，第1行，第2列[{“id”:“110805214923063296”，“casId”:“5515251865965035
stone的博客
11-20 2997
今天在前后端联调的时候出现了这个问题 ，前端传递了一个JSON数组给我，我后端使用@RequestBody +map的方式和@RequestBody + object的方式都报错如下错误， 解决的部分后面使用@RequestBody + jsonarray去接收 应该还有一种办法，就是创建一个实体 ，实体字段存在需要得到的数据名称，在创建@RequestBody + List<实体&gt; 这种方法应该可行 ，只不过我还没试 ...
syntax error, expect {, actual string, pos 126, line 1, column 127
a13032160710的博客
05-26 3117
调用接口时报错syntax error, expect {, actual string, pos 126, line 1, column 127，之后再用Json.parseObject（jsonString， Domain）
com.alibaba.fastjson.JSONException: syntax error, expect {, actual [
qq_54571327的博客
06-28 5471
com.alibaba.fastjson.JSONException: syntax error, expect {, actual [
IDEA运行spring boot报ERROR. pos 145, line 2, column 21, token COMMA 错误该怎么解决
weixin_42868605的博客
06-08 8872
ERROR. pos 145, line 2, column 21, token COMMA 错误该如何解决? 如图: 注意看圈红的地方,一般报这个错都是因为不细心导致逗号符号多了一个,开发的过程中注意一定要好好检查!
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :‘ TOP 3 * FROM 。。。
热门推荐
悟●禅●酒的专栏
04-02 1万+
先说一下现象，此处我使用是国产达梦6数据库，该处SQL在数据库客户端中能正常执行，且该错误对系统运行，目前没发现有何异常，但，看着该接口每次被调用后，都打出一堆Exception，也是很不爽的事。 此处报错日志异常如下（仅供参考）： 11:11:47.031 [main] DEBUG c.r.p.t.s.m.S.searchSql - [debug,143] - ==&gt; Preparing: SELECT TOP 3 * FROM XXXXXX WHERE XXXX ORDER BY XXX A.
运行Shell文件.sh报错syntax error near unexpected token `$’do\r”
01-09
start.sh: line 17: syntax error near unexpected token `$'do\r'' 'tart.sh: line 17: ` do 原因 运行cat -v start.sh，如果内容结尾为是^M，这是因为你所处理的文件换行符是dos格式的”\r\n”，你可能在windows...
Vue项目报错：Uncaught SyntaxError: Unexpected token
01-19
控制台的提示：Uncaught SyntaxError: Unexpected token < 按照提示进入文件，再看如下图： 仔细看了看 index.html 文件,发现原本我的 JS 文件是放在 /src/utils 文件夹下的，但引入 /src 和 /static 的文件是...
解决vue打包后刷新页面报错：Unexpected token
12-12
今天遇到了一个很怪的问题，在vue-cli+webpack的项目中，刷新特定页面后页面会变空白，报错为index.html文件中Unexpected token <。 怪点一是开发环境没有问题，只有生产环境有问题，怪点二是只有一个页面有问题...
Minio——上传10M图片文件失败
WoodYangOY的博客
11-01 7413
项目场景： 在安卓App有上传文件，文件接口是项目统一的。 问题描述： 提示：这里描述项目中遇到的问题： 安卓App内上传10M以下（只测试了10M左右的图片文件）图片文件可以正常上传，而超过10M就会抛出异常，用PostMan测试文件上传接口，一切正常！！！！！ 原因分析： 1、partCount 异常抛出位置是 uploadId == null 条件内，我以为是partCount 异常导致的，因为抛异常的文件的 partCount=4 ，不会抛异常的文件的partCount = 1 ，结果不然，此
SpringCloudStream——RabbitMQ 手动ACK，Channel 参数为空？
WoodYangOY的博客
05-07 2686
问题描述 使用SpringCloudStream 集成RabbitMQ的过程中，一直无法使用手动ACK功能。 SpringCloud版本：Hoxton.RELEASE SpringBoot 版本：2.2.1.RELEASE SpringCloudStream 版本 ：3.0.0.RELEASE MQ 配置文件： spring: cloud: stream: bindings: greetings-in: destination: greeting
微信小程序—Java后端提供Https服务以及踩过的坑
WoodYangOY的博客
08-31 1534
微信小程序—Java后端提供Https服务以及踩过的坑 文章目录微信小程序—Java后端提供Https服务以及踩过的坑前言一、自签名证书1、KeyTool工具生成证书2、添加配置文件3、更改yml配置4、测试二、SSL证书1.腾讯云申请免费SSL证书2.修改配置文件3.http强制转换为Https 前言 公司小程序开发阶段完成后，小程序需要发布测试版本，需要在公网环境的服务。注：微信小程序服务必须使用Https域名，否则认证不通过，页面也会一直抛网络不可用。 提示：以下是本篇文章正文内容，下面案例可供
Java地图坐标转换
WoodYangOY的博客
09-29 1087
地图坐标转换 最近涉及到地图坐标的转换，开始深入了解了一下。不同的使用的坐标系，不同的坐标系使用的标准不一样，导致不同的地图同一地点的经纬度偏差很大。 文章目录地图坐标转换前言一、坐标系1.概念2.不同地图使用的坐标系3.转换3.1 算法转换3.2 API 转换3.2.1 高德坐标转换Web API3.2.2 百度坐标转换Web API3.2.3 GPS坐标转换Web API3.3 SDK 转换3.3.1 高德 sdk api 转换3.3.2 百度 sdk api 转换 前言 提示：以下是本篇文章正
syntax error, expect EQ, actual IDENTIFIER pos 72, line 3, column 16, token IDENTIFIER element_id
09-24
syntax error, expect EQ, actual IDENTIFIER pos 72, line 3, column 16, token IDENTIFIER element_id这个错误信息表明在语法中期望是等号(EQ)，但实际上是标识符(IDENTIFIER)的位置。这通常发生在SQL语句中，可能...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值