<?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.api.app.dao.my.FeedbackDao">
    <insert id="insertAdvice" parameterType="com.api.model.butlerService.SysAdvice">
        insert into sys_advice(
            type,
            status,
            content,
            hits,
            create_id,
            create_date,
            create_user_type,
            is_delete,
            user_delete
        ) values (
            #{type},
            #{status},
            #{content},
            #{hits},
            #{createId},
            #{createDate},
            #{createUserType},
            #{isDelete},
            #{userDelete}
        )
        <selectKey keyProperty="id" resultType="java.lang.Integer">
            select LAST_INSERT_ID() AS id
        </selectKey>
    </insert>
</mapper>