spring cloud+mybatis+阿里Druid：如何开启配置multiStatementAllow支持一次执行多条sql

最新推荐文章于 2023-10-08 20:14:39 发布
最新推荐文章于 2023-10-08 20:14:39 发布
阅读量8k 收藏 9
点赞数 4
分类专栏： java8 Mybatis 文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/reggergdsg/article/details/107567700
版权

 

关于如何开启multiStatementAllow，一次执行多条sql，这里结合项目，来说明一下。

 

首先搞清楚，multiStatementAllow配置在哪，其实就是阿里Druid框架中WallConfig.class中的一个属性。源码如下：

 

package com.alibaba.druid.wall;

import com.alibaba.druid.util.Utils;
import com.alibaba.druid.wall.spi.WallVisitorUtils;
import java.util.Properties;
import java.util.Set;
import java.util.concurrent.ConcurrentSkipListSet;

public class WallConfig implements WallConfigMBean {
    private boolean noneBaseStatementAllow = false;
    private boolean callAllow = true;
    private boolean selelctAllow = true;
    private boolean selectIntoAllow = true;
    private boolean selectIntoOutfileAllow = false;
    private boolean selectWhereAlwayTrueCheck = true;
    private boolean selectHavingAlwayTrueCheck = true;
    private boolean selectUnionCheck = true;
    private boolean selectMinusCheck = true;
    private boolean selectExceptCheck = true;
    private boolean selectIntersectCheck = true;
    private boolean createTableAllow = true;
    private boolean dropTableAllow = true;
    private boolean alterTableAllow = true;
    private boolean renameTableAllow = true;
    private boolean hintAllow = true;
    private boolean lockTableAllow = true;
    private boolean startTransactionAllow = true;
    private boolean conditionAndAlwayTrueAllow = false;
    private boolean conditionAndAlwayFalseAllow = false;
    private boolean conditionDoubleConstAllow = false;
    private boolean conditionLikeTrueAllow = true;
    private boolean selectAllColumnAllow = true;
    private boolean deleteAllow = true;
    private boolean deleteWhereAlwayTrueCheck = true;
    private boolean deleteWhereNoneCheck = false;
    private boolean updateAllow = true;
    private boolean updateWhereAlayTrueCheck = true;
    private boolean updateWhereNoneCheck = false;
    private boolean insertAllow = true;
    private boolean mergeAllow = true;
    private boolean minusAllow = true;
    private boolean intersectAllow = true;
    private boolean replaceAllow = true;
    private boolean setAllow = true;
    private boolean commitAllow = true;
    private boolean rollbackAllow = true;
    private boolean useAllow = true;
    private boolean multiStatementAllow = false;
    private boolean truncateAllow = true;
    private boolean commentAllow = false;
    private boolean strictSyntaxCheck = true;
    private boolean constArithmeticAllow = true;
    private boolean limitZeroAllow = false;
    private boolean describeAllow = true;
    private boolean showAllow = true;
    private boolean schemaCheck = true;
    private boolean tableCheck = true;
    private boolean functionCheck = true;
    private boolean objectCheck = true;
    private boolean variantCheck = true;
    private boolean mustParameterized = false;
    private boolean doPrivilegedAllow = false;
    protected final Set<String> denyFunctions = new ConcurrentSkipListSet();
    protected final Set<String> denyTables = new ConcurrentSkipListSet();
    protected final Set<String> denySchemas = new ConcurrentSkipListSet();
    protected final Set<String> denyVariants = new ConcurrentSkipListSet();
    protected final Set<String> denyObjects = new ConcurrentSkipListSet();
    protected final Set<String> permitFunctions = new ConcurrentSkipListSet();
    protected final Set<String> permitTables = new ConcurrentSkipListSet();
    protected final Set<String> permitSchemas = new ConcurrentSkipListSet();
    protected final Set<String> permitVariants = new ConcurrentSkipListSet();
    protected final Set<String> readOnlyTables = new ConcurrentSkipListSet();
    private String dir;
    private boolean inited;
    private String tenantTablePattern;
    private String tenantColumn;
    private WallConfig.TenantCallBack tenantCallBack;
    private boolean wrapAllow = true;
    private boolean metadataAllow = true;
    private boolean conditionOpXorAllow = false;
    private boolean conditionOpBitwseAllow = true;
    private boolean caseConditionConstAllow = false;
    private boolean completeInsertValuesCheck = false;
    private int insertValuesCheckSize = 3;

    ... 省略
}

multiStatementAllow默认值为false，也就是说默认不开启一次执行多条sql语句的。

 

如何支持呢？本质就是把multiStatementAllow的值置为false，但是考虑到不同项目，数据源的配置是不同的，所以具体的实现

方案也是不同的。但是核心思想是不变的，我们需要拦截数据源，然后把我们的修改注入到Datasource。

 

    @Bean(name = "wallFilter")
    @DependsOn("wallConfig")
    public WallFilter wallFilter(WallConfig wallConfig) {

        WallFilter wallFilter = new WallFilter();
        wallFilter.setConfig(wallConfig);
        return wallFilter;
    }

    @Bean(name = "wallConfig")
    public WallConfig wallConfig() {

        WallConfig wallConfig = new WallConfig();
        wallConfig.setMultiStatementAllow(Boolean.TRUE);
        return wallConfig;
    }

 

如何把这个filter注入到datasource呢，如果我们可以直接获取到datasource的话，那么，直接按照网上的方式，就可以了。如下

List<Filter> filters = new ArrayList<>();
filters.add(wallFilter);
datasource.setProxyFilters(filters);

 

但是有些项目，数据源是进行了统一的管理的，也就是我们不能直接获取到datasource，只能通过配置来注入这个filter，

怎么办呢？思路是：找到filter配置，然后把我们自定义的filter这个bean：wallFilter配置上去即可。

 

xx:
  xxxx:
    server:
      enablecache: true
      datasource:
        driver : com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/databasename?serverTimezone=GMT%2b8&useSSL=false&Unicode=true&characterEncoding=utf8&autoReconnectForPools=true&allowMultiQueries=true
        user: root
        password: 123456789
        mapperLocations: classpath:mybatis/*.xml
        timeBetweenEvictionRunsMillis: 60000
        filters: wallFilter

 

这样配置以后，我们就可以执行下面这种多条sql了。

 

    <update id="batchUpdateTest">
        <foreach collection="pojos" item="pojo" index="index" open="" close="" separator=";">
            UPDATE table_name
            SET `name` = #{pojo.name},
                `update_time` = #{pojo.updateTime}
            WHERE `id` = #{pojo.id} and  `code` = #{pojo.code}
        </foreach>
    </update>

 

本地测试是OK的，但是后面部署到测试环境，发现有问题，报错如下：

2020-07-27 16:23:31,565 [http-nio-10015-exec-7] ERROR xx.xxxxxx.xxx.xxxxx.xxx.controller.XxxxController - [ANONYMOUS - 6b636ad5b9e949ff - 6b636ad5b9e949ff] - error
org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:275)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at xx.xxxxxx.xxx.xxxxx.xxx.service.impl.OmsSapActualInventoryServiceImpl$$EnhancerBySpringCGLIB$$6e9713d5.batchUpdateBySkuAndWarehouse(<generated>)
	at xx.xxxxxx.xxx.xxxxx.xxx.service.impl.OmsInventoryBatchUpdateService.updateInventoryThenNoticeInv(OmsInventoryBatchUpdateService.java:204)
	at xx.xxxxxx.xxx.xxxxx.xxx.controller.OmsInventoryController.batchUpdateReserveInventory(OmsInventoryController.java:180)
	at xx.xxxxxx.xxx.xxxxx.xxx.controller.OmsInventoryController$$FastClassBySpringCGLIB$$d31d8de7.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at xx.xxxxxx.xxx.xxxxx.xxx.controller.OmsInventoryController$$EnhancerBySpringCGLIB$$1305761d.batchUpdateReserveInventory(<generated>)
	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.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:281)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:115)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.cloud.sleuth.instrument.web.TraceFilter.doFilterInternal(TraceFilter.java:122)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:103)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
	at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1618)
	at com.alibaba.druid.pool.DruidPooledConnection.commit(DruidPooledConnection.java:731)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:272)
	... 94 common frames omitted

 

首先这是一个新的报错了，这个报错的原因网上搜了一下。

春秋战国程序猿
关注
  • 4
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
MyBatis使用Druid数据源批量更新失败
12-14
已经允许批量更新 filter: wall: config: multi-statement-allow: true #允许一次批量更新操作，会导致SQL注入 Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect EQ, actual IDENTIFIER pos 372, line 22, column 20, token IDENTIFIER id : update sys_role
mybatis 批量 update时报错 multi-statement not allow解决方案
weixin_44019182的博客
06-04 4214
mybatis 批量 update时报错 multi-statement not allow解决方案 原因 mysql默认不支持批量更新 Druid的multiStatementAllow默认是false 解决方案 方法一 修改application配置 spring.datasource.url 后面加上 &allowMultiQueries=true 如果配置了druid 注释掉 filters: wall，加上 filter: wall: config: multi-statement
SpringBoot+Mybatis+Druid批量更新 multi-statement not allow异常
编码行者的博客
12-30 1931
在日常的开发过程中难免会有批量操作的功能，Mybatis 集成 Druid 批量更新时经常会出现 Error updating database. Cause: java.sql.SQLException: sql injection violation, multi-statement not allow 异常。导致该异常出现是因为 Druid 的 multiStatementAllow 默认是 false，所以需要开启，设置成 true。 一、解决方法 配置数据库连接，添加 allowMultiQue
springmvc配置allowMultiQueries批量执行多个SQL，解决multi-statement not allow问题
dqb4531的博客
01-06 1582
今天尝试使用springmvc使用mybatis一次执行多个SQL，首先在jdbc的url中配置了allowMultiQueries=true，但是报错multi-statement not allow。废话不多说，直接上配置。1、dataSource下的filters中必须要去掉wall，否则spring会自动生成一个wall不会使用下面自定义的wall。2、dataSource增加proxyFilters用来配置wall。
mybatisPlus批量更新multi-statement not allow问题
05-30 782
由控制台可见，其mybatis默认不支持多条语句的更新，需要设置相关属性。从社区里看到的解决方案大致思路为，先检查本地配置文件的url中是否配置了allowMultiQueries=true，如果配置了，但还是不起作用，再写一个配置类来解决。在配置类MyBatisPlusConfig中 (mybatis 的话就在MyBatisConfig中改,没有配置文件的话就加一个)添加如下配置就可以了。这个时候大多数情况下基本是可以解决问题了的,如果还是报错的话 就直接在配置文件中添加配置。
Spring Boot集成Druid实现多数据源的两种方式
热门推荐
涛哥是个大帅比
04-12 1万+
Spring Boot集成Druid实现多数据源的两种方式： 1、集成com.baomidou，引入dynamic-datasource依赖； 2、原生的方式，基于AOP手动实现多数据源；
SpringBoot - 配置Druid允许批量执行SQL
b9x__的博客
11-09 4375
Druid默认是不开启批量SQL执行的，属性为MultiStatementAllow.配置为true即可. yml文件配置： filters：stat  spring: profiles: active: dev datasource: type: com.alibaba.druid.pool.DruidDataSource driver-class-nam...
springboot解决multi-statement not allow(已部署生产)
最新发布
qq_39839075的博客
10-08 1212
看报错的堆栈，是一个叫做WallFilter的过滤器中报出来的。首先来说，解决思路没有问题，就是将这个属性multiStatementAllow的值设置为true，关键是怎么做是有效的？反正我试了网上的思路，不管用，还是报错，要不然就是不报错了，但是。解决思路很简单，首先将我们已经生成的数据源注入到代码中，然后添加MultiStatementAllow=true的配置。我对druid的源码也不熟悉，碰到了这个问题，也是google，第一：很简单，既然是wall引起的，直接把它去掉不就行了。
Mybatis + mysql + Druid批量更新时multi-statement not allow异常
wjs_007的博客
09-14 844
sql injection violation, multi-statement not allow错误
new-cloud:基于SpringBoot+SpringCloud+Mybatis+Docker分布式敏捷开发系统架构
04-30
cloud基于SpringBoot+SpringCloud+Mybatis+Docker分布式敏捷开发系统架构，提供整套公共微服务服务模块：内容管理、支付中心、用户管理（包括第三方）、微信平台、存储系统、配置中心、日志分析、任务和通知等，支持...
Spring Boot+Apache Shiro+Spring MVC+MyBatis+Quartz+Druid DEMO
03-30
Spring Boot+Apache Shiro+Spring MVC+MyBatis+Quartz+Druid DEMO
cloud-seata-nacos：springcloud + mybatis plus + nacos +伪装+ mysql
03-03
这个项目架构由自己建造使用架构为主流的Spring Cloud Alibaba主要用于尝试新技术并进行整合测试，最终用于实践 环境 杰克1.8 Maven 3.6.3 工具 想法2020.3 吉特邮差导航外壳MobaXterm Mobaxterm redis-desktop-...
Spring boot+mybatis+druid+SQL监控
02-28
本文使用Druid的连接池，然后配置Druid的相关属性，完成对Spring web工程的JDBC监控。 其实，我采用Druid替换其它连接池，最关键的一个理由是Druid有对SQL执行的监控统计功能。 druid 实现 SQL、URI 等监控
基于springboot微服务框架的个人博客系统，技术栈SpringCloud+MyBatis+Redis+shiro+vue
06-20
基于springboot微服务框架的个人博客系统，技术栈SpringCloud+MyBatis+Redis+shiro+vue 基于springboot微服务框架的个人博客系统，技术栈SpringCloud+MyBatis+Redis+shiro+vue 基于springboot微服务框架的个人博客...
关于mybatis配置一次执行多条sql
zsj777的专栏
09-18 818
1、数据源配置 添加allowMultiQueries=true spring.datasource.druid.url=jdbc:mysql://192.168.2.41:3306/stm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true 2、druid如果配...
multi-statement not allow
chengmin123456789的博客
05-24 679
在配置druid 之后出现multi-statement not allow 错误， druid: filters: stat,wall 将wall 去掉 就可以修复这个错误
MyBatis，集成Druid批量更新报错multi-statement not allow
gaoshan12345678910的博客
08-05 1095
有两个原因,一个数据库层面的限制,通过在url地址中添加allowMultiQueries=true可以解决 spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test_account?characterEncoding=utf-8&useSSL=false&allowMultiQueries=true 另外一个原因,与Drui...
springboot 解决 阿里 druid 数据源 批量更新错误 multi-statement not allow
qq_36911595的博客
06-28 2962
网上看到一些 解决 批量更新，出现 multi-statement not allow 错误 的解决方案，自己断点查看源码和执行过程，多方总结得出结论 一、首先数据库连接必须增加 allowMultiQueries=true 以支持批量更新，如下 spring.datasource.url=jdbc:mysql://localhost:3306/xxx?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&rewrit
springcloud+mybatis写一个交易
05-17
下面是一个简单的交易的示例，使用Spring Cloud和MyBatis框架： 1. 创建数据库表 ``` CREATE TABLE `transaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ``` 2. 创建实体类 ``` public class Transaction { private int id; private int userId; private BigDecimal amount; // 省略getter和setter方法 } ``` 3. 创建Mapper接口 ``` @Mapper public interface TransactionMapper { @Insert("INSERT INTO transaction(user_id, amount) VALUES(#{userId}, #{amount})") int insert(Transaction transaction); } ``` 4. 创建Service类 ``` @Service public class TransactionService { @Autowired private TransactionMapper transactionMapper; public void insert(Transaction transaction) { transactionMapper.insert(transaction); } } ``` 5. 创建Controller类 ``` @RestController public class TransactionController { @Autowired private TransactionService transactionService; @PostMapping("/transaction") public void createTransaction(@RequestBody Transaction transaction) { transactionService.insert(transaction); } } ``` 6. 配置Spring Cloud 在application.yml中添加以下配置： ``` spring: datasource: url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false username: root password: 123456 mybatis: mapper-locations: classpath:mapper/*.xml type-aliases-package: com.example.demo.entity ``` 7. 启动应用程序 运行主类，即可启动应用程序。然后，您可以使用Postman或其他HTTP客户端发送POST请求来创建交易： ``` POST http://localhost:8080/transaction { "userId": 1, "amount": 100.00 } ``` 以上就是一个简单的交易的示例，您可以根据自己的需求进行修改和扩展。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值