MyBatis的关于批量数据操作的体会
?
<!-- 在外部for循环调用一千次 --><insert id="insert" parameterType="sdc.mybatis.test.Student">??? insert into student (id, name, sex,??? address, telephone, t_id??? )??? values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR},??? #{sex,jdbcType=VARCHAR},??? #{address,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{tId,jdbcType=INTEGER}??? )</insert><!--? 批量，传入一个长度为1000的list? --><insert id="insertBatch">??? insert into student ( <include refid="Base_Column_List"/> ) ??? values ??? <foreach collection="list" item="item" index="index" separator=",">??????? (null,#{item.name},#{item.sex},#{item.address},#{item.telephone},#{item.tId})??? </foreach></insert>