一.Mapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.schedulemanager.ScheduleDAO">
<update id="test">
UPDATE A a INNER JOIN B b on a._id = b._id
<![CDATA[and a.end_time < SYSDATE() ]]>
and a.state != "0" set a.state = "0";
UPDATE C c INNER JOIN D d on c.id = d.id
<![CDATA[and c.end_time < SYSDATE() ]]>
and c.state != "0" set c.state = "0";
UPDATE E e INNER JOIN F f on e.id = f.id
<![CDATA[and e.end_time < SYSDATE()]]>
and e.state != "0" set e.state = "0";
</update>
</mapper>
二.数据源增加配置
<![CDATA[jdbc:mysql://xxxx:3306/project?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true]]>
&allowMultiQueries=true 这个配置可以让Mybatis执行多条语句
三、注意
每条执行语句后必须加;号