mybatis 新增返回自增的id值

简单的介绍一下吧

1-实体类

public class Department {
        private Integer id;
        private String name;
        private Integer parentId;
        private String logoName;
        private String logoPath;
        private String introduce;
        private String oid;
       // get set  省略
}

2-Dao类

 public void add(Department department) {
        try {
            mapper.add(department);
            System.out.println(department.getId());
        } catch (Exception e) {
            logger.error(e.getMessage());
        }

    }

返回 id 有两种方法，其中一种是使用注解，返回的id会自动复制在 Department 实体类的id属性中

3.1 注解（Interface）

@Insert("INSERT INTO department(`name`,introduce,parent_id,org_id)\n" +
        "            VALUES (\n" +
        "            #{department.name,jdbcType = VARCHAR},\n" +
        "            #{department.introduce,jdbcType = VARCHAR},\n" +
        "            #{department.parentId,jdbcType = VARCHAR},\n" +
        "            #{department.oid,jdbcType = VARCHAR}\n" +
        "            )")
      @Options(useGeneratedKeys = true, keyProperty = "department.id",keyColumn = "id")
        void add(@Param("department") Department department);

3.2 Mapper.xml 

void add(@Param("department") Department department);

    <insert id="add" useGeneratedKeys="true" keyProperty="department.id" parameterType="mp.module.daomain.department.Department">
        <!--<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="department.id">-->
            <!--select last_insert_rowid() as id-->
        <!--</selectKey>-->
        INSERT INTO department(`name`,introduce,parent_id,org_id)
            VALUES (
            #{department.name,jdbcType = VARCHAR},
            #{department.introduce,jdbcType = VARCHAR},
            #{department.parentId,jdbcType = VARCHAR},
            #{department.oid,jdbcType = VARCHAR}
            )
    </insert>

4 测试结果均可显示