<pre code_snippet_id="1749645" snippet_file_name="blog_20160707_1_7626269" name="code" class="java"><pre name="code" class="html"><pre code_snippet_id="1749645" snippet_file_name="blog_20160707_1_7626269" name="code" class="java"><pre name="code" class="html">//javaint count = xx.insert(obj);
//<span style="font-family: Arial, Helvetica, sans-serif;">此时要取得主键id,是取obj的id属性,insert的返回值永远都是受影响行数!</span>
//第一种
<insert id="insert" parameterType="cn.**.beans.LogObject" >
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID() AS ID
</selectKey>
INSERT INTO S_T_LOGS (
ID,
USER_ID,
USER_NAME,
USER_IP,
OPERATION_TIME,
DESCRIPTION,
RESOURCE_ID)
VALUES (
#{id},
#{userId},
#{userName},
#{userIp},
#{operationTime},
#{description},
#{resourceId})
</insert>
//第二种
<insert id="insert" parameterType="cn.***.beans.LogObject" useGeneratedKeys="true" keyProperty="id">
INSERT INTO S_T_LOGS (
ID,
USER_ID,
USER_NAME,
USER_IP,
OPERATION_TIME,
DESCRIPTION,
RESOURCE_ID)
VALUES (
#{id},
#{userId},
#{userName},
#{userIp},
{operationTime},
{description},
{resourceId})
</insert>