mybatis批量插入数据
程序员文章站
2022-10-06 21:11:29
1.service层 int i=0; try { i = fqDao.insertBatch_BFQ(bfqs);//批量插入 } catch (Exception e) { e.printStackTrace(); } 2.dao层 1 //批量插入不复权数据 2 public int inse ......
1.service层
int i=0; try { i = fqDao.insertBatch_BFQ(bfqs);//批量插入 } catch (Exception e) { e.printStackTrace(); }
2.dao层
1 //批量插入不复权数据 2 public int insertBatch_BFQ(List<GSXQ_K_LineOfDay> list);
3.map文件
1 <!-- 批量插入不复权数据 --> 2 <insert id ="insertBatch_BFQ" parameterType="java.util.List" > 3 insert into bfq_gsxq 4 (uuid, qyname, gpdm, time,kpj,spj,zgj,zdj,cjsl,cjje,zf,hsl,gpgs) 5 values 6 <foreach collection ="list" item="bfq" index= "index" separator =","> 7 ( 8 #{bfq.uuid}, #{bfq.qyname},#{bfq.gpdm}, 9 #{bfq.time},#{bfq.kpj}, #{bfq.spj}, 10 #{bfq.zgj},#{bfq.zdj}, #{bfq.cjsl}, 11 #{bfq.cjje},#{bfq.zf}, #{bfq.hsl},#{bfq.gpgs} 12 ) 13 </foreach > 14 </insert >