博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
mybatis批量插入
阅读量:5263 次
发布时间:2019-06-14

本文共 1758 字,大约阅读时间需要 5 分钟。

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
(#{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} )

mapper:

void insertBatch(BizIndexesDay[] bizIndexes);

 

转载于:https://www.cnblogs.com/grey-wolf/p/6962712.html

你可能感兴趣的文章
mysql远程连接失败的两种解决方法
查看>>
PHP实现冒泡排序
查看>>
【源代码】StringBuilder和StringBuffer震源深度分析
查看>>
RelativeLayout经常使用属性介绍
查看>>
Swift 编程语言新手教程
查看>>
SAP BW 数据库表命名规则
查看>>
MySQL Community Server 8.0.16
查看>>
css实现隐藏效果
查看>>
IOS-详解KVO底层实现
查看>>
iOS-程序启动原理和UIApplication
查看>>
java中集合,数组,字符串相互转换
查看>>
Linux上Blogilo连接博客园账户
查看>>
socket(7)
查看>>
去除HTML标签--2005SQL写法
查看>>
js、javascript正则表达式验证身份证号码
查看>>
42 和为S的两个数字
查看>>
python3 实现对代码文件中注释的翻译
查看>>
delete 与 delete []
查看>>
[WCF安全系列]谈谈WCF的客户端认证[Windows认证]
查看>>
cocoPods常见错误(一)
查看>>