1. where
<select id="getByName" resultMap="student" parameterType="String">
select * from student
<where>
<!-- 当name=null时在select * from student后加上where name = #{name}
否则执行select * from student语句-->
<if test="name != null">
name = #{name}
</if>
</where>
</select>
测试类
public class Test1 {
public static void main(String[] args) throws IOException {
/*获取配置文件mybatis-config.xml*/
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
/*建造会话工厂SqlSessionFactory*/
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
/*生产SqlSession*/
SqlSession session = sessionFactory.openSession();
/*通过反射获取TeacherMapper*/
StudentMapper mapper = session.getMapper(StudentMapper.class);
/*调用TeacherMapper的方法*/
List<Student> student = mapper.getByName("张三");
System.out.println(student);
}
}