<?xml version="1.0" encoding="UTF-8" ?>
select last_name lastnamel,email,gender from employee;
insert into employee (last_name,email,gender) values (#{lastname},#{email},#{gender})
</insert>
<update id="updateEmp" parameterType="pojo.Employee">
update employee set email =#{email},gender =#{gender} where last_name =#{lastname}
</update>
<delete id="delEmp" parameterType="int">
delete from employee where id = #{id}
</delete>
注意: ① Mapper接口与Mapper映射文件的绑定在Mppper映射文件中的标签中的namespace中必须指定Mapper接口的全类名 ② Mapper映射文件中的增删改查标签的id必须指定成Mapper接口中的方法名. ![在这里插入图片描述](https://img-blog.csdnimg.cn/20201019195115879.png#pic_center) ![在这里插入图片描述](https://img-blog.csdnimg.cn/20201019195115880.png#pic_center)