一、查询;配置的代码都是在User.xml中
<!-- 返回单结果查询 -->
<select id="selectUserByID" parameterType="Integer" resultType="User">
select * from user where userName = #{id}
</select>
<!--
返回列表结果查询;
resultMap需要自己定义;
-->
<resultMap type="User" id="resultListUser">
<id column="id" property="id" />
<result column="userName" property="userName" />
<result column="userAge" property="userAge" />
<result column="userAddress" property="userAddress" />
</resultMap>
<select id="selectUsers" parameterType="String" resultMap="resultListUser">
select * from user where userName like #{userName}
</select>
二、添加;
<!-- insert -->
<insert id="addUser" parameterType="User" useGeneratedKeys="true" keyProperty="id">
insert into user(userName,userAge,userAddress)
values(#{userName,jdbcType=VARCHAR},#{userAge,jdbcType=INTEGER},
#{userAddress,jdbcType=VARCHAR})
</insert>
在使用时,一定要记得 commit。不然数据库表里是没有插入的。
userMapper.addUser(user);
sqlsession.commit();
三、修改;
<!-- update -->
<update id="updateUser" parameterType="User" >
update user
set userName=#{userName,jdbcType=VARCHAR},
userAge=#{userAge,jdbcType=INTEGER},
userAddress=#{userAddress,jdbcType=VARCHAR}
where id=#{id,jdbcType=INTEGER}
</update>
四、删除
<delete id="deleteUser" parameterType="java.lang.Integer">
delete from user where id=#{id,jdbcType=INTEGER}
</delete>