IBatis批量插入数据

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>