select
<select id="getUserById" parameterType="int" resultType="com.itheima.pojo.User"> select * from user where id = #{id} </select>
insert
<!--对象中的属性,可以直接取出来--> <insert id="addUser" parameterType="com.itheima.pojo.User"> insert into user(id,name,pwd) values(#{id},#{name},#{pwd}); </insert>
update
<update id="updateUser" parameterType="com.itheima.pojo.User"> update user set name=#{name},pwd=#{pwd} where id =#{id}; </update>
delete
<delete id="deleteUser" parameterType="int"> delete from user where id = #{id}; </delete>
要提交事务