<resultMap type="XX" id="XXMap">
<id property="id" column="colid"/>
<id property="name" column="colname"/>
</resultMap>
前为别名后为主查询getXXX语句中字段
<select id="getXXX" parameterType="HashMap" resultMap="XXX">
SELECT colid,colname FROM table1
</select>
<select id="getSubXXX" parameterType="HashMap" resultType="XXX">
SELECT * FROM table2 WHERE id = #{id} AND name = #{name}
</select>
<
insert
id
=
"insertXXXX"
parameterClass
=
"com.test.model.XXXX"
>
insert into TableName(………略
<
selectKey
resultClass
=
"java.lang.Integer"
keyProperty
=
"id"
>
SELECT @@IDENTITY AS id
</
selectKey
>
</
insert
>