1.js:首先序列化表单然后将值传到后台
2.Controller:
获取前台传来的序列化表单,并转化为List集合:
3.Service以及ServiceImpl层:
4.Mybatis:
字段以及数据库类型一定要对应
批量插入:
<insert id="insertBatch" parameterType="java.util.Map">
insert into customs_declare_bill_detail(
id,
gno,
relman_no,
code_t,
g_name,
g_model,
g_qty,
g_unit,
decl_total,
decl_curr,
decl_price,
exg_version,
goods_no,
origin_country,
unit_1,
qty_1,
unit_2,
qty_2,
duty_mode,
work_usd,
dest_country,
rtn_code,
rtn_info,
invalid,
bill_id,
main_factor,
bill_no,
creator,
create_time,
amender,
amend_time)
values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.id,jdbcType=BIGINT},
#{item.gno,jdbcType=VARCHAR},
#{item.relmanNo,jdbcType=VARCHAR},
#{item.codeT,jdbcType=VARCHAR},
#{item.gName,jdbcType=VARCHAR},
#{item.gModel,jdbcType=VARCHAR},
#{item.gQty,jdbcType=INTEGER},
#{item.gUnit,jdbcType=VARCHAR},
#{item.declTotal,jdbcType=DECIMAL},
#{item.declCurr,jdbcType=VARCHAR},
#{item.declPrice,jdbcType=DECIMAL},
#{item.exgVersion,jdbcType=VARCHAR},
#{item.goodsNo,jdbcType=VARCHAR},
#{item.originCountry,jdbcType=VARCHAR},
#{item.unit1,jdbcType=VARCHAR},
#{item.qty1,jdbcType=DECIMAL},
#{item.unit2,jdbcType=VARCHAR},
#{item.qty2,jdbcType=DECIMAL},
#{item.dutyMode,jdbcType=VARCHAR},
#{item.workUsd,jdbcType=DECIMAL},
#{item.destCountry,jdbcType=VARCHAR},
#{item.rtnCode,jdbcType=VARCHAR},
#{item.rtnInfo,jdbcType=VARCHAR},
#{item.invalid,jdbcType=VARCHAR},
#{item.billId,jdbcType=BIGINT},
#{item.mainFactor,jdbcType=VARCHAR},
#{item.billNo,jdbcType=VARCHAR},
#{item.creator,jdbcType=INTEGER},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.amender,jdbcType=INTEGER},
#{item.amendTime,jdbcType=TIMESTAMP}
)
</foreach>
</insert>
2.批量删除:
<delete id="deleteById" parameterType="java.lang.String">
delete from customs_declare_bill_detail where id in
<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
#{item}
</foreach>
</delete>