//接口定义
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>