增
<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>
通過接口映射方法的方式執(zhí)行結(jié)束后會返回一個int值,為被操作記錄條數(shù)
在操作完之后別忘了commit 不然操作會失敗
session.commit();
session.close();
//session.rollback();//這個是撤銷操作的方法