<selectid="getStudents"resultType="student"parameterType="map">
select * from mybatis_test.student where
<iftest="id != null">
id = #{id}
</if><iftest="name!= null">
and name = #{name}
</if></select>
当id==null,name!=null的时候,SQL语句变成:select * from mybatis_test.student where and name = #{name}
2.使用where标签解决问题
<selectid="getStudents"resultType="student"parameterType="map">
select * from mybatis_test.student
<where><iftest="id != null">
id = #{id}
</if><iftest="name!= null">
and name = #{name}
</if></where></select>