mybatis 插入集合数据



//接口定义
int insertList(@Param("list") List<TAstTsLinearrester> list);

<
insert id="insertList" parameterType="java.util.List"> insert into "表名"(PSR_ID, AST_ID, NAME, CITY, MAINT_ORG, MAINT_GROUP, EQUIPMENT_OWNER, LINE, POLE, VOLTAGE_LEVEL, PSR_STATE, START_TIME, STOP_TIME, INSTALL_PHASE, INSTALLATION_LOCATION, CTIME, LAST_UPDATE_TIME, SUPERIOR_LINE ) values <foreach collection="list" separator="," item="val"> (#{val.psrId}, #{val.astId}, #{val.name}, #{val.city}, #{val.maintOrg}, #{val.maintGroup}, #{val.equipmentOwner}, #{val.line}, #{val.pole}, #{val.voltageLevel}, #{val.psrState}, #{val.startTime}, #{val.stopTime}, #{val.installPhase}, #{val.installationLocation}, #{val.ctime}, #{val.lastUpdateTime}, #{val.superiorLine} ) </foreach> </insert>

 

posted @ 2021-10-26 18:01  晓*雨  阅读(760)  评论(0)    收藏  举报