mybatis批量执行sql语句
xml配置
<insert id="batchUpdate" parameterType="map">
<foreach collection="list" item="id" separator=";">
${id}
</foreach>
</insert>
@Mapper
public interface CommonMapper {
int batchUpdate(Map map);
}
Map map = new HashMap();
List list = new ArrayList<>();
# mysql
list.add("insert into test values(1)");
# oracle
list.add("insert into test select 1 from dual");
int i1 = commonMapper.batchUpdate(map);
数据库配置
数据库配置的url连接:
mysql 数据库连接一定要加上 参数 allowMultiQueries=true