mybatis批量插入
2024-10-13 19:25:34
<insert id="insertBatch" parameterType="java.util.List" >
insert into biz_indexes_day (company_code, type,
record_date, idx501, idx502,
idx503, idx504, idx505,
idx506, idx507, idx508,
idx509, idx510, idx511,
idx512, idx513, idx514,
idx515, idx516, idx517,
idx518, idx519, idx520,
idx521, idx522, idx523,
idx524, idx525, idx526,
idx527, idx528, idx529,
idx530, gtm_create, gtm_modify
)
values <foreach collection="array" item="obj" index="index" separator=",">
(#{obj.companyCode,jdbcType=VARCHAR}, #{obj.type,jdbcType=CHAR},
#{obj.recordDate,jdbcType=CHAR}, #{obj.idx501,jdbcType=DOUBLE}, #{obj.idx502,jdbcType=DOUBLE},
#{obj.idx503,jdbcType=DOUBLE}, #{obj.idx504,jdbcType=DOUBLE}, #{obj.idx505,jdbcType=DOUBLE},
#{obj.idx506,jdbcType=DOUBLE}, #{obj.idx507,jdbcType=DOUBLE}, #{obj.idx508,jdbcType=DOUBLE},
#{obj.idx509,jdbcType=DOUBLE}, #{obj.idx510,jdbcType=DOUBLE}, #{obj.idx511,jdbcType=DOUBLE},
#{obj.idx512,jdbcType=DOUBLE}, #{obj.idx513,jdbcType=DOUBLE}, #{obj.idx514,jdbcType=DOUBLE},
#{obj.idx515,jdbcType=DOUBLE}, #{obj.idx516,jdbcType=DOUBLE}, #{obj.idx517,jdbcType=DOUBLE},
#{obj.idx518,jdbcType=DOUBLE}, #{obj.idx519,jdbcType=DOUBLE}, #{obj.idx520,jdbcType=DOUBLE},
#{obj.idx521,jdbcType=DOUBLE}, #{obj.idx522,jdbcType=DOUBLE}, #{obj.idx523,jdbcType=DOUBLE},
#{obj.idx524,jdbcType=DOUBLE}, #{obj.idx525,jdbcType=DOUBLE}, #{obj.idx526,jdbcType=DOUBLE},
#{obj.idx527,jdbcType=DOUBLE}, #{obj.idx528,jdbcType=DOUBLE}, #{obj.idx529,jdbcType=DOUBLE},
#{obj.idx530,jdbcType=DOUBLE}, #{obj.gtmCreate,jdbcType=TIMESTAMP}, #{obj.gtmModify,jdbcType=TIMESTAMP}
)
</foreach>
</insert>
mapper:
void insertBatch(BizIndexesDay[] bizIndexes);
最新文章
- 纪念BLives 1.0版本发布
- 3分钟干货学会使用node-inspector调试NodeJS代码
- android 中View的优化
- PUT vs POST in REST
- JS写返回上一级
- proxy解析
- UITableViewStyleGrouped 模式下 headview 多出一块高度问题
- 配置《算法 第四版》的Eclipse开发环境
- 浅说Java中的反射机制(二)
- *[topcoder]GUMIAndSongsDiv1
- 用DataSet方式更新数据库表
- The end of other
- JAVA Calendar详解(转)
- 关于java集合排序
- PHP生成带有干扰线的验证码,干扰点、字符倾斜
- 用CAS方案解决高并发一致性问题
- LABjs、RequireJS、SeaJS 哪个最好用?为什么?
- pair在vector和map中的使用
- Django REST Framework限速
- 登录页面和FORM的职责不对称,处理方法,刷新工作流程