Mapper.xml中SQL语句的用法示例

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="top.softcn.mapper.EmpMapper"><select id="getPageEmp" resultType="top.softcn.pojo.Emp">select emp.*,dept.name deptName from emp left join dept on emp.dept_id = dept.id<where><if test="name != null and name != ''">and emp.name like concat('%',#{name},'%')</if><if test="gender != null">and emp.gender = #{gender}</if><if test="begin != null and end != null">and emp.entry_date between #{begin} and #{end}</if></where>order by emp.update_time desc
</select></mapper>