map文件oracle批量添加,mybatis插入List<Map<String, String>>批量数据到Oracle数据库
beginINSERT into TT_ENGINE_EBOM_FROM_TC(ENGINE_EBOM_TC_ID,ENGINE_TYPE,FUNCTION_MODULE,GROUP_ZU,PART_CODE,PART_NAME,PART_NAME_EN,VERSION,PART_NUM,SUBSTITUTE_LIST,PUBLISH_DATE,PART_PHASE,PART_IMPORTANCE
beginINSERT into TT_ENGINE_EBOM_FROM_TC
(
ENGINE_EBOM_TC_ID,
ENGINE_TYPE,
FUNCTION_MODULE,
GROUP_ZU,
PART_CODE,
PART_NAME,
PART_NAME_EN,
VERSION,
PART_NUM,
SUBSTITUTE_LIST,
PUBLISH_DATE,
PART_PHASE,
PART_IMPORTANCE_LEVEL,
PART_RESPONSIBLE_PERSON,
PART_USE_POSITION,
REFERENCE_TIGHTENING_TORQUE,
REMARK
)
VALUES(
SEQ_TT_ENGINE_EBOM_TC_ID.nextval,
#{paramMap.ENGINE_TYPE, jdbcType=VARCHAR},
#{paramMap.FUNCTION_MODULE, jdbcType=VARCHAR},
#{paramMap.GROUP_ZU, jdbcType=VARCHAR},
#{paramMap.PART_CODE, jdbcType=VARCHAR},
#{paramMap.PART_NAME, jdbcType=VARCHAR},
#{paramMap.PART_NAME_EN, jdbcType=VARCHAR},
#{paramMap.VERSION, jdbcType=VARCHAR},
#{paramMap.PART_NUM, jdbcType=VARCHAR},
#{paramMap.SUBSTITUTE_LIST, jdbcType=VARCHAR},
#{paramMap.PUBLISH_DATE, jdbcType=VARCHAR},
#{paramMap.PART_PHASE, jdbcType=VARCHAR},
#{paramMap.PART_IMPORTANCE_LEVEL, jdbcType=VARCHAR},
#{paramMap.PART_RESPONSIBLE_PERSON, jdbcType=VARCHAR},
#{paramMap.PART_USE_POSITION, jdbcType=VARCHAR},
#{paramMap.REFERENCE_TIGHTENING_TORQUE, jdbcType=VARCHAR},
#{paramMap.REMARK, jdbcType=VARCHAR}
);commit;
end;
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)