SQL批处理

allowMultiQueries=true 的使用:

 

配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration  
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--1.3配置连接池需要的参数-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/db1?allowMultiQueries=true&amp;serverTimezone=GMT%2B8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="com/xxxx/dao/ListenerDao.xml"/>
    </mappers>
</configuration>

接口

public interface ListenerDao {

        void createTable();

        void deleteTable();
}

接口映射文件

<?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.midea.dao.ListenerDao">

    <update id="createTable">
        create table test1(id int primary key auto_increment,name varchar(20));
        create table test2(id int primary key auto_increment,name varchar(20),birthday date,dept_id int);
    </update>

    <update id="deleteTable">
        drop table test1;
        drop table test2;
    </update>

</mapper>



也可以在接口中使用@Update注解   省略了写接口映射文件

public interface ListenerDao {


        Book findUserById(int id);

        @Update("create table test1(id int primary key auto_increment,name varchar(20));\n" +
                "create table test2(id int primary key auto_increment,name varchar(20),birthday date,dept_id int);")
        void createTable();

        
        @Update("drop table test1;\n" +
                "drop table test2;")
        void deleteTable();
}
注意SQL间  有  ;\n"  分开