mybatis xml 同时操作多条sql语句

_Weck2

于 2018-08-02 17:32:51 发布

阅读量8.1k

点赞数 1

本文链接：https://blog.csdn.net/qq_37012304/article/details/81364418

版权

jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true

jdbc.url加上标红字体

sql ：

<update id="delete">
		UPDATE test SET 
			del_flag = #{DEL_FLAG_DELETE}
		WHERE id = #{id};

		UPDATE test2 SET
			del_flag = #{DEL_FLAG_DELETE}
		WHERE test_id = #{id};

		UPDATE test3 SET
			del_flag = #{DEL_FLAG_DELETE}
		WHERE test_id = #{id};

		UPDATE srt_mp_report SET
			del_flag = #{DEL_FLAG_DELETE}
		WHERE test_id = #{id};
	</update>