mybatis 批量修改_MyBatis批量新增、修改、删除、查询

1.批量新增接口

2.批量新增xml
<strong><span style="font-size:18px;"><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//http://mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.my.da.mapper.data.StoredRecordVarianceDataMapper" >
<resultMap id="BaseList" type="cn.my.model.data.RecordVarianceData" >
<result column="CID" property="id" jdbcType="INTEGER" />
<result column="GROUP_CENTRE_RUNNING_NUM" property="gropCenterRuningNum" jdbcType="DECIMAL" />
<result column="PRO_CENTRE_RUNNING_NUM" property="proCenterRuningNum" jdbcType="DECIMAL" />
<result column="ROWINFO" property="rowInfo" jdbcType="VARCHAR" />
<result column="CHECKTIME" property="checkTime" jdbcType="VARCHAR" />
</resultMap>
<insert id="insertCheckData" parameterType="cn.my.model.data.RecordVarianceData">
insert into OSD_CHECK_DATA_INFO(GROUP_CENTRE_RUNNING_NUM,PRO_CENTRE_RUNNING_NUM,ROWINFO,CHECKTIME)
<foreach item="item" index="index" collection="list" separator=",">
( #{item.gropCenterRuningNum,jdbcType=DECIMAL},#{item.proCenterRuningNum,jdbcType=DECIMAL},#{item.rowInfo,jdbcType=VARCHAR},#{item.checkTime,jdbcType=VARCHAR})
</foreach>
</insert>
</mapper></span></strong>3.批量修改接口及xml

4.批量删除接口及xml

5.批量查询接口及xml