mybatis的动态SQL查询语句

<select id="getPerson" resultType="com.lzj.bean.Employees">

select * from tbl_employees

<where>

<if test="id!=null">

id=#{id} and

</if>

<if test="lastName!=null and lastName!=''">

last_name like #{lastName} and

</if>

<if test="email!=null and email.trim()!=''">

email=#{email} and

</if>

<if test="gender==0 or gender==1">

gender=#{gender}

</if>

</where>

</select>