<insert id="addPeople" parameterType="com.sjt.entity.api.AskPeople">
insert
into
t_ask_people(notes_code,PARTY_NAME,PARTY_SEX,PARTY_AGE,PARTY_IDENTITY_ID,PARTY_TELEPHONE,PARTY_CASE_RELATION,PARTY_UNITS,PARTY_JOB,PARTY_ADRESS)
values(#{notesCode,jdbcType=VARCHAR},#{partyName,jdbcType=VARCHAR},#{partySex,jdbcType=VARCHAR},
#{partyAge,jdbcType=VARCHAR},#{partyIdentityId,jdbcType=VARCHAR},#{partyCaseRelation,jdbcType=VARCHAR},#{partyTelephone,jdbcType=VARCHAR},
#{partyUnits,jdbcType=VARCHAR},#{partyJob,jdbcType=VARCHAR},#{partyAdress,jdbcType=VARCHAR})
<selectKey resultType="int" keyProperty="askId" >
select seq_ask_people_id.currval as askId from dual
</selectKey>
insert
into
t_ask_people(notes_code,PARTY_NAME,PARTY_SEX,PARTY_AGE,PARTY_IDENTITY_ID,PARTY_TELEPHONE,PARTY_CASE_RELATION,PARTY_UNITS,PARTY_JOB,PARTY_ADRESS)
values(#{notesCode,jdbcType=VARCHAR},#{partyName,jdbcType=VARCHAR},#{partySex,jdbcType=VARCHAR},
#{partyAge,jdbcType=VARCHAR},#{partyIdentityId,jdbcType=VARCHAR},#{partyCaseRelation,jdbcType=VARCHAR},#{partyTelephone,jdbcType=VARCHAR},
#{partyUnits,jdbcType=VARCHAR},#{partyJob,jdbcType=VARCHAR},#{partyAdress,jdbcType=VARCHAR})
<selectKey resultType="int" keyProperty="askId" >
select seq_ask_people_id.currval as askId from dual
</selectKey>
</insert>
controller:
entity.getId()