<insert id="user.insertUserAndGetId" parameterClass="user">
<![CDATA[
INSERT INTO t
(
name
)
VALUES
(
#name#
)
]]>
<selectKey keyProperty="id" resultClass="Integer">
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
UserVO user = new UserVO();
user.setName("Bob");
System.out.println("Index of user " + user.getName() + " is " + user.getId() + " (before insert)");
int id = ((Integer) sqlMap.insert("user.insertUserAndGetId")).intValue();
System.out.println("Index of user " + user.getName() + " is " + user.getId() + " (after insert)");
No comments:
Post a Comment