<parameterMap class="User" id="insertUser-param">
<parameter property="username"/>
<parameter property="password"/>
</parameterMap>
<insert id="insertUser" parameterMap="insertUser-param">
insert into t_user values (
null,?,?
)
<selectKey resultClass="int" keyProperty="id">
SELECT @@IDENTITY AS ID
</selectKey>
</insert>
parameterMap用于传入参数,以便匹配SQL语句中的?号, 跟JDBC中的
PreparedStatement类似
User user = new User();
user.setUsername("张三dd");
user.setPassword("dd");
Object obj = sqlMapper.insert("insertUser", user);
利用parameterMap,可以定义参数对象的属性映射到SQL查询语句的动态参数上,注意parameterMap中<parameter/>标签的先后顺序不能颠倒!