如下配置
jdbc.url=jdbc:mysql://127.0.0.1:3306/chubb_2?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
allowMultiQueries=true参数的作用:
①可以在sql语句后携带分号,实现多语句执行。
如:mybatis的mapper.xml文件
SELECT * FROM x;
②可以执行批处理,同时发出多个SQL语句。
UPDATE
dev_rel
gmt_modified=now(),
pro_id = #{devRelDO.proId},
dev_id = #{devRelDO.devId},
group_id = #{devRelDO.groupId},
own_type = #{devRelDO.ownType}
id = #{devRelDO.id}
底层原理:
参考:
https://my.oschina.net/zhuguowei/blog/411853
https://blog.csdn.net/xuezhezhishen/article/details/78692698
https://my.oschina.net/freedemon/blog/1813816
https://www.cnblogs.com/jeffen/p/6038261.html
https://blog.csdn.net/qq_26718271/article/det