mybatis(2) : mybatis插入主键返回

参考: https://www.cnblogs.com/xingyunblog/p/6243179.html

1. mybatis映射文件添加配置    useGeneratedKeys="true" keyProperty="id"

keyProperty是实体类的主键字段

<insert id="insertSelective" parameterType="com.pro.huanbao.pojo.TpMessageText"  useGeneratedKeys="true" keyProperty="id">
    insert into tp_message_text
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
    

 

2. 获取返回的主键 

			TpMessageText messageText = new TpMessageText(null,content, date , "来自"+company.getName()+"的留言",0, null,null);
			messageTextMapper.insertSelective(messageText);
			System.err.println(messageText.getId());

 

插入之后直接用对象获取主键即可

 

END。