<insert id="insertRecord" parameterClass="jginfoBean">
INSERT INTO
ams_supersiveinfo
(REGCODE,TYPE,UPLOADPATH,SUBMITFLAG,REGNAME,NIANDU,MONTH,RANDOMCOMPANY,ZFTIME)
VALUES(#regcode#,#type#,#uploadpath#,#submitFlag#,#regname#,#niandu#,#month#,#randomcompany#,#zftime#)
<selectKey type="post" resultClass="java.lang.Integer" keyProperty="id">
SELECT LAST_INSERT_ID() AS ID
</selectKey>
</insert>
update获取修改条目数量
<update id="updateCreateUserId">
<![CDATA[$value$]]>
</update>
dao代码:
@Override
public int updateCreateUserId(String sql) {
return getSqlMapClientTemplate().update("UupmUser.updateCreateUserId", sql);
}