<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.adminserver.mapper.TrainInfoMapper">
<insert id="insertTrainInfo">
insert into train_info(
train_id, trai_comment, standing_order, station_name, arrive_time, leave_time, super_seat, first_seat, second_seat, stand_thick, state
) VALUES
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.trainId},
#{item.traiComment},
#{item.standingOrder},
#{item.stationName},
#{item.arriveTime},
#{item.leaveTime},
#{item.superSeat},
#{item.firstSeat},
#{item.secondSeat},
#{item.standThick},
#{item.state})
</foreach>
</insert>
<delete id="removerTrainById">
delete from train_info where train_id = #{trainId}
</delete>
<select id="getTrainInfoById" resultType="com.atguigu.adminserver.pojo.entity.TrainInfo">
select * from train_info where train_id=#{trainId}
</select>
</mapper>
Mybatis动态批量插入
最新推荐文章于 2023-08-02 19:34:38 发布