在mybatis中进行批量操作

1、批量删除

<delete id="deleteCollect" parameterType="Map">
	delete from FIN_PRODUCT_COLLECT 
	where fin_product_id in 
	<foreach collection="finProductIds" item="item" index="index" open="(" separator="," close=")">#{item}</foreach>
	and fin_consult_id=#{finConsultId}
</delete>

 

String[] deleteIdsArray = deleteIds.split(",");
List<Long> finProductIds = new ArrayList<Long>();
for(int i=0; i<deleteIdsArray.length; i++){
	finProductIds.add(Long.parseLong(deleteIdsArray[i]));
}

Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("finConsultId", finConsultId);
parameters.put("finProductIds", finProductIds);
dao.deleteCollect(parameters);

 

2、批量添加

    1）范例一

<insert id="insertCollect" parameterType="java.util.Map">
	insert all 
	into FIN_PRODUCT_COLLECT (fin_consult_id,fin_product_id) values(col1, col2)  
	<foreach collection="finProductIds" item="item" separator="union all" >
	select #{finConsultId} as col1, #{item} as col2 from dual
	</foreach>
</insert>

 

String[] insertIdsArray = insertIds.split(",");
List<Long> finProductIds = new ArrayList<Long>();
for(int i=0; i<insertIdsArray.length; i++){
	finProductIds.add(Long.parseLong(insertIdsArray[i]));
}

Map<String,Object> map = new HashMap<String,Object>();
map.put("finConsultId", finConsultId);
map.put("finProductIds", finProductIds);
dao.insertCollect(map);

 

    2）范例二

<insert id="batchInsert" parameterType="java.util.List">
	insert into page_logs (PAGE_TYPE, FILE_NAME, BORROW_NID, BORROW_TYPE, BORROW_NAME, CREATE_TIME) 
	values 
	<foreach collection="list" item="item" index="index" separator="," >
		(#{item.pageType}, #{item.fileName}, #{item.borrowNid}, #{item.borrowType}, #{item.borrowName}, #{item.createTime})
	</foreach>
</insert>

 

//mapper class method
public int batchInsert(List<PageLogsEntity> list);

public class PageLogsEntity {
	private Long id;
	private String pageType;
	private String fileName;
	private String borrowNid;
	private String borrowType;
	private String borrowName;
	private Date createTime;
}