{"version":"1.0","provider_name":"Blog - Silicon Cloud","provider_url":"https:\/\/www.silicloud.com\/blog","author_name":"Sophia Anderson","author_url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/","title":"\"mybatis retrieves the automatically generated primary key\"","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"rnVWuaRP7i\"><a href=\"https:\/\/www.silicloud.com\/blog\/mybatis-retrieves-the-automatically-generated-primary-key\/\">&#8220;mybatis retrieves the automatically generated primary key&#8221;<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.silicloud.com\/blog\/mybatis-retrieves-the-automatically-generated-primary-key\/embed\/#?secret=rnVWuaRP7i\" width=\"600\" height=\"338\" title=\"&#8220;&#8220;mybatis retrieves the automatically generated primary key&#8221;&#8221; &#8212; Blog - Silicon Cloud\" data-secret=\"rnVWuaRP7i\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.silicloud.com\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"In MyBatis, you can use the parameter useGeneratedKeys to fetch the automatically generated primary key. Firstly, set useGeneratedKeys to true in the insert statement, and specify keyProperty to indicate the attribute name that will receive the primary key. For example: &lt;insert id=\"insertUser\" useGeneratedKeys=\"true\" keyProperty=\"id\"&gt; INSERT INTO user (username, password) VALUES (#{username}, #{password}) &lt;\/insert&gt; Next, in [&hellip;]"}