mysql数据库插入一条新数据,返回新插入数据的主键Id

mysql数据库插入一条新数据,返回新插入数据的主键Id

mapping映射文件的sql语句

<insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.wanmait.hospital.pojo.Doctor" useGeneratedKeys="true">
    insert into doctor
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="name != null">
        `name`,
      </if>
      <if test="scope != null">
        `scope`,
      </if>
      <if test="info != null">
        info,
      </if>
      <if test="visible != null">
        visible,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="name != null">
        #{name,jdbcType=VARCHAR},
      </if>
      <if test="scope != null">
        #{scope,jdbcType=VARCHAR},
      </if>
      <if test="info != null">
        #{info,jdbcType=VARCHAR},
      </if>
      <if test="visible != null">
        #{visible,jdbcType=BIT},
      </if>
    </trim>
  </insert>

返回的主键Id的获取方法

 @Test
    public void testInsert()
    {
        Doctor doctor = new Doctor();
        doctor.setName("靳医生");
        doctor.setInfo("66666一个字6");
        doctorMapper.insertSelective(doctor);
        System.out.println(doctor.getId());
    }