<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.lhx.dao.EmpDAO"><deleteid="delectById">
delete from employee where id =#{id}
</delete><selectid="selectById"resultType="employee">
select * from employee where id =#{id}
</select><!-- mysql的自增主键使用useGeneratedKeys=true来获取,用keyProperty设置pojo中哪个值获取--><insertid="insert"parameterType="employee"useGeneratedKeys="true"keyProperty="id">
insert into employee(last_name, gender, email) values(#{lastName},#{gender},#{email})
</insert><updateid="update"parameterType="employee">
update employee set last_name=#{lastName} ,email=#{email},gender=#{gender} where id=#{id}
</update></mapper>