增
<insert id="insert" parameterType=”map”>
insert into users (id, name, funkyNumber, roundingMode) values (
#{id}, #{name}, #{funkyNumber}, #{roundingMode})
</insert>
改
<update id="updateAuthor" parameterType=”map”>
update Author set
username = #{username},
password = #{password},
email = #{email},
bio = #{bio}
where id = #{id}
</update>
删
<delete id="deleteAuthor" parameterType=”java.lang.Integer”>
delete from Author where id = #{id}
</delete>
通过接口映射方法的方式执行结束后会返回一个int值,为被操作记录条数
在操作完之后别忘了commit 不然操作会失败
session.commit();
session.close();
//session.rollback();//这个是撤销操作的方法
