Mybatis insert 返回创建的自增ID

1.参数一定要封装成实体对象,对象中定义接收创建的id字段
public class SmjOrderManageBean implements Serializable {

    //主键
    private String id;

         //get,set 

}

2.调用MySQL数据

int createOrder(SmjOrderManageBean orderBean);

3.Mybatis 插入语句，useGeneratedKeys="true" keyProperty="id"   //指定bean中的id字段接收 自增主键

<insert id="createOrder" parameterType="com.sydata.cscm.smj.ordermanage.bean.SmjOrderManageBean" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO smj_order_manage (
        userid,
        orgunitid,
        devid,
        snumber,
        paystatus,
        creatorid,
        createtime,
        modifiedid,
        modifiedtime
    )
    VALUES
    (
        #{creatorid},
        #{orgunitid},
        #{devId},
        #{snumber},
        #{paystatus},
        #{creatorid},
        current_timestamp(),
        #{creatorid},
        current_timestamp()
    )

</insert>

 

 

https://www.cnblogs.com/sxdcgaq8080/p/10869336.html