映射方式增删改

增

<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();//这个是撤销操作的方法