mybatis XML 的基本配置

<?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.sky.mapper.DishMapper">

    <!-- useGeneratedKeys开启插入后的数据字段返回给Dish实体类 keyProperty将那个插入到数据库中后返回给java实体类 -->
    <insert id="addDish" parameterType="com.sky.entity.Dish" useGeneratedKeys="true" keyProperty="id">
        insert into sky_take_out.dish(name, category_id, price, image, description, status, create_time, update_time, create_user, update_user)
                            values(#{name},#{categoryId},#{price},#{image},#{description},#{status},#{createTime},#{updateTime},#{createUser},#{updateUser});
    </insert>
    
     	<!-- separator 代表循环的item之间会以，隔开 -->
        <insert id="addBatch" parameterType="com.sky.entity.DishFlavor">
            insert into dish_flavor(dish_id, name, value) VALUES
            <foreach collection="dishFlavorList" item="item" separator=",">
                (#{item.dishId},#{item.name},#{item.value)})
            </foreach>
        </insert>
    
</mapper>