<insert id="insert_log_info_list" parameterClass="java.util.Map">
INSERT INTO
log_info
(
name,
tel_no,
sms_content,
status,
reg_date
)
VALUES
<iterate conjunction="," property="infoList">
(
#infoList[].name#,
#infoList[].telNo#,
#infoList[].status#,
#infoList[].smsContent#,
'1',
NOW()
)
</iterate>
<selectKey keyProperty="id" resultClass="int">
SELECT @@IDENTITY AS id
</selectKey>
</insert>
log_info表中字段 id,name, tel_no, sms_content, status, reg_date,其中id为主键,自增长