mybatis动态sql模糊查询之Example

背景

根据姓名和工号查询某学校某班级学生

sql

select * from user_info where school=#{school} and class=#{class} and (name=#{name} or work_id=#{workId}) 

使用Example

Example example = new Example(UserInfo.class);
example.createCriteria().andEqualTo("school",school).andEqualTo("class",class);
if (StringUtils.isNotEmpty(nameOrId)) {
  example.and(example.createCriteria().andLike("name","%" + nameOrId + "%").orLike("workId","%" + nameOrId + "%"));
}
userInfoMapper.selectByExample(example);