佟刚mysql_EmployeeMapper.xml例子，学习佟刚老师的myBatis课程，记录下的EmployeeMapper.xml，注释详细...

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select id, last_name LastName, email from tbl_employee where id = #{id}

select EMPLOYEE_ID id, LAST_NAME lastName, GENDER gender, EMAIL email

from EMPLOYEE where EMPLOYEE_ID = #{id}

select id, last_name LastName, email, gender from tbl_employee where id = #{id}

insert into tbl_employee(id, last_name, gender, email) values(#{id}, #{lastName}, #{gender}, #{email})

insert into EMPLOYEE(EMPLOYEE_ID, LAST_NAME,GENDER,EMAIL) values(#{id}, #{lastName}, #{gender}, #{email})

select * from EMPLOYEE where EMPLOYEE_ID = #{id} and LAST_NAME = #{lastName}

select * from EMPLOYEE where EMPLOYEE_ID = #{id} and LAST_NAME = #{lastName}

delete from EMPLOYEE where EMPLOYEE_ID = #{id}

update EMPLOYEE

set LAST_NAME = #{lastName}, EMAIL = #{email}, GENDER = #{gender}

where id = #{id}

原文：https://www.cnblogs.com/zjulanjian/p/9194923.html