<insert id="insert" parameterType="models.Transaction">
insert into transaction
<trim prefix="(" suffix=")" suffixOverrides=",">
id,
player_number,
expense_type,
expense_count,
operation_type,
operation_person,
caption,
type,
player_id,
money,
points,
remain_points,
coin,
remain_coin,
app_id,
desk_id,
position_id,
biz_id,
channel,
status,
finished,
create_time,
note,
detail_json,
merchant_id,
room_num
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
#{id},
#{playerNumber},
#{expenseType},
#{expenseCount},
#{operationType},
#{operationPerson},
#{caption},
#{type},
#{playerId},
#{money},
#{points},
#{remainPoints},
#{coin},
#{remainCoin},
#{appId},
#{deskId},
#{positionId},
#{bizId},
#{channel},
#{status},
#{finished},
#{createTime},
#{note},
#{detailJson},
#{merchantId},
#{roomNum}
</trim>
</insert>
mybatis 动态添加数据
最新推荐文章于 2024-08-15 12:22:25 发布