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());
}