[color=red]1.自动参数映射[/color]
[color=red]2.内联参数映射[/color]
[color=red]3.外联参数映射[/color]
<insert id="inserUser" parameterClass="User">
insert into t_user(id, name, sex, address)
values (#id#, #name#, #sex#, #address#)
</insert>
[color=red]2.内联参数映射[/color]
<insert id="inserUser3" parameterClass="User">
insert into t_user(id, name, sex, address)
values (#id:NUMBER#, #name:VARCHER#, #sex:NUMBER#, #address:NUMBER#)
</insert>
[color=red]3.外联参数映射[/color]
<parameterMap class="User" id="paramMap">
<parameter property="id" jdbcType="NUMBER"/>
<parameter property="name" jdbcType="VERACHER"/>
<parameter property="sex" jdbcType="NUMBER"/>
<parameter property="address" jdbcType="NUMBER"/>
</parameterMap>
<insert id="inserUser" parameterMap="paramMap">
insert into t_user(id, name, sex, address) values (?, ?, ?, ? )
</insert>