Mybatis动态批量插入

原创于 2021-09-03 14:45:59 发布 · 304 阅读

CC 4.0 BY-SA版权

文章标签：

这个示例展示了如何使用MyBatis的XML映射文件进行数据操作，包括插入数据（insertTrainInfo）、删除数据（removeTrainById）和获取数据（getTrainInfoById）的方法。每个方法详细定义了SQL语句和参数绑定。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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>