MyBatis+MySQL map 返回插入的主键ID

来源:互联网 发布:淘宝申诉成功率 编辑:程序博客网 时间:2024/06/01 21:13

MyBatis+MySQL map返回插入的主键ID

1.service

userDao.insert(map);
int i = Integer.parseInt(map.get("id").toString());

2.Mapper.xml

    <insert id="insert"  parameterType="java.util.Map" useGeneratedKeys="true" keyProperty="id" keyColumn="id">          <selectKey resultType="int" order="AFTER" keyProperty="id">               SELECT LAST_INSERT_ID() as id          </selectKey>              insert into user_info(name,age,create_time,address)           values (#{name,jdbcType=VARCHAR},          #{age,jdbcType=TINYINT},          #{create_time,jdbcType=DATE},          #{address,jdbcType=VARCHAR})      </insert>