Java Dao书写
@Override
public void insertStaffBatch(List<A5StaffApply> list) {
this.getSqlMapClientTemplate().insert("insertStaffBatch", list);
}
对应的xml
<insert id ="insertStaffBatch" parameterClass ="java.util.ArrayList" >
<![CDATA[
INSERT INTO `a5_staff_apply` (
col1,
col2,
col3,
col4,
) VALUES
]]>
<iterate conjunction ="," >
<![CDATA[
( NULL,
#list[].property1#,
#list[].property2#,
#list[].property3#,
#list[].property4#
NOW()
)
]]>
</iterate>
</insert>