1.mybatis的parameterType类型为list时,
注意:<foreach collection="list" item="item" separator=","> 里面不能有open="(" close=")"
<insert id="insertListContacts" parameterType="java.util.List">
insert into t_org_contact ( Forg_id, Fcontact_type, Fcontact_name,Fcontact_mobile,Fcontact_email,
Fproduct, Fcontract_num )
values
<foreach collection="list" item="item" separator=",">
(#{item.orgId,jdbcType=BIGINT},
#{item.contactType,jdbcType=BIGINT},
#{item.contactName,jdbcType=VARCHAR},
#{item.contactMobile,jdbcType=VARCHAR},
#{item.contactEmail,jdbcType=VARCHAR},
#{item.product,jdbcType=VARCHAR},
#{item.contractNum,jdbcType=VARCHAR} )
</foreach>
</insert>
2.mybatis的resultType类型为list时,
注意这里的 resultType 返回值类型是集合内存储数据的类型,不是 'list'
<select id="getAllEmps" resultType="employee">
select * from t_employee
</select>